My Oracle Support Banner

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

Last updated on MAY 12, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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