ORA-12514 Errors and Unable to Bring Up OFSAA or Run Batches After Database Rename (Doc ID 2774651.1)

Last updated on OCTOBER 03, 2024

Applies to:

Symptoms

On OFSAA 8.1.0.1.0, OFSAA batches are not executing and there are errors bringing up the FICServer after renaming the Service Name on the database. The following errors are found in the $FIC_APP_HOME/common/FICServer/bin/nohup.out:

ERROR

com.ofs.aai.exception.OFSAAException: DB Connection failed for DBName: <ATOMIC SCHEMA>, DBType: ORACLE
...
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
 )
...
Caused by: 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:854)
...
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
...
com.ofs.aai.exception.OFSAAException: DB Connection failed for DBName: CONFIG, DBType: ORACLE
at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getConnection(GenericOFSAAConnectionFactory.java:405)

None of the agent log files are updated after executing a batch.

The issue can be reproduced at will with the following steps:
1. Executed steps from Doc ID 1682915.1
2. Restart services and check running batches.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.