Impossible to start UVMS / Reporter after having migrated to Oracle 12c from Oracle 11g: "ORA-01017: invalid username/password; logon denied"

Document ID : KB000086694
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
The following error appears on the uvserver.log after having migrated the Database from a server with Oracle 11g to another server with Oracle 12c.
ORA-01017: invalid username/password; logon denied

Patch level detected:Univiewer Management Server 6.7.01
Product Version: Dollar.Universe 6.7.01

Description :After doing a migration from the database used by UVMS / Reporter from Oracle 11g to a server on Oracle 12c, the UVMS could not start any more.
Many attempts of different configurations were tried on the values.xml without success.
Environment:
OS: All
Cause:
Cause type:
Configuration
Root Cause: The settings (Database name / Service Name ) of the Database on Oracle 12c were different than the ones on Oracle 11g.
Resolution:
In order to connect to an Oracle Database 12c via UVMS / Reporter with this kind of connection string:

@//db_host_name:port_number/service_name

You should set the following values on the values.xml of the UVMS / default.load.xml of the Reporter:

Y
db_host_name
port_number
service_name

There is no need to specify anything on the variable DB_NAME.
You can consult this link for further information:
http://stackoverflow.com/questions/4832056/java-jdbc-how-to-connect-to-oracle-using-service-name-instead-of-sid

Fix Status: Released

Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.7.01
Additional Information:
Workaround :
N/A