Admin Server Does Not Start After ODI Database Moved to Another Server (Doc ID 2628392.1)

Last updated on AUGUST 10, 2023

Applies to:

Symptoms

After moving the database that hosts the Oracle Data Integrator (ODI) repository to a different server, the admin server is still pointing to the old database instance and gives the below error when trying to start: 

Jan 10, 2020 8:14:06 PM oracle.security.jps.internal.policystore.util.JpsDataManagerUtil getDBConnection
WARNING: Can not connect DB with URL jdbc:oracle:thin:@//<OLD_DATABASE_HOST>:<OLD_PORT>/<SID>
java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:775)
  at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:833)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:40)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
  at java.sql.DriverManager.getConnection(DriverManager.java:664)
  at java.sql.DriverManager.getConnection(DriverManager.java:247)
  at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.getDBConnection(JpsDataManagerUtil.java:400)
  at oracle.security.jps.internal.policystore.util.JpsDataManagerUtil.isNewSchema(JpsDataManagerUtil.java:249)
  at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.isNewSchema(DataManagerFactoryImpl.java:252)
  at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.getDBDataManager(DataManagerFactoryImpl.java:319)
  at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.getDataManager(DataManagerFactoryImpl.java:186)
  at oracle.security.jps.internal.core.datamanager.DataManagerFactoryImpl.getDataManager(DataManagerFactoryImpl.java:137)
  at oracle.security.jps.internal.common.config.AbstractSecurityStore.createDataManager(AbstractSecurityStore.java:96)
  at oracle.security.jps.internal.common.config.AbstractSecurityStore.getSecurityStoreVersionInternal(AbstractSecurityStore.java:164)
  at oracle.security.jps.internal.common.config.AbstractSecurityStore.getSecurityStoreVersion(AbstractSecurityStore.java:146)
  at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.init(LdapCredentialStore.java:187)
  at oracle.security.jps.internal.credstore.ldap.LdapCredentialStore.start(LdapCredentialStore.java:1030)
  at oracle.security.opss.internal.runtime.ServiceContextImpl.start(ServiceContextImpl.java:220)
  at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.createDefaultContext(ServiceContextManagerImpl.java:325)
  at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.initialize(ServiceContextManagerImpl.java:242)
  at oracle.security.jps.internal.config.OpssCommonStartup$1.run(OpssCommonStartup.java:166)
  ...
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
  at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
  at oracle.net.ns.NSProtocol.connect(NSProtocol.java:328)
  at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1439)
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:519)
  ... 49 more

Changes

 The database was moved to another server.

Cause