Impossible to start UVMS / Reporter after having migrated to Oracle 12c from Oracle 11g: "ORA-01017: invalid username/password; logon denied"
Article ID: 86694
CA Automic Dollar Universe
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.
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.
In order to connect to an Oracle Database 12c via UVMS / Reporter with this kind of connection string:
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