OAM Audit to RDBMS Database Is Not Working: TNS Connection Errors Seen in Trace Level oblog.log (Doc ID 565805.1)

Last updated on MARCH 08, 2017

Applies to:

COREid Identity - Version: 10.1.4 and later   [Release: 10g and later ]
Information in this document applies to any platform.
Checked for relevance on 05-MAY-2011

Symptoms

Oracle Access Manager (OAM ) auditing to Oracle RDBMS database has been configured, however the audit entries are not being created in the oblix_audit_events table.

The Identity Server/Access Server trace level oblog.log shows OAM is generating TNS connection errors when trying to connect to the audit database.

Reference: <> - How To Turn On Trace/Logging Oracle Access Manager (OAM)/COREid

For example:

Error 1: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

2008/04/17@00:24:27.630407 5073 131080 DB_RUNTIME TRACE 0x00000203
../sql_connection_mngr.cpp:79 "Function entered" _TraceName^SQLConnectionManager::_CreateAndOpenConnection
2008/04/17@00:24:27.630444 5073 131080 SQL_ADAPTER DEBUG1 0x00000201 ../ociconnection.cpp:58 "OCI error handle created successfully"
2008/04/17@00:24:27.630456 5073 131080 SQL_ADAPTER DEBUG1 0x00000201 ../ociconnection.cpp:77 "OCI service context handle created successfully"
2008/04/17@00:24:27.697933 5073 131080 SQL_ADAPTER ERROR 0x00000066 ../ocierrormap.cpp:53 "OCI server connect failed" method^OCIConnection::OCIConnection ociRetCode^OCI_ERROR Diagnostic Record number^1 Error Message^ORA-12514: TNS:listener does not currently know of service requested in connect descriptor%0a Error Code from OCIErrorGet^12514
2008/04/17@00:24:27.698067 5073 131080 DB_RUNTIME WARNING 0x00000504
../db_connection_mngr.cpp:346 "Exception during DB runtime code" function^DBConnectionManager::CheckOutConnection


Error 2: ORA-12541: TNS:no listener

2008/04/17@00:25:27.708748 5073 131080 SQL_ADAPTER DEBUG1 0x00000201 ../ociconnection.cpp:58 "OCI error handle created successfully"
2008/04/17@00:25:27.708761 5073 131080 SQL_ADAPTER DEBUG1 0x00000201 ../ociconnection.cpp:77 "OCI service context handle created successfully"
2008/04/17@00:25:27.818867 5073 131080 SQL_ADAPTER ERROR 0x00000066 ../ocierrormap.cpp:53 "OCI server connect failed" method^OCIConnection::OCIConnection ociRetCode^OCI_ERROR Diagnostic Record number^1 Error Message^ORA-12541: TNS:no listener%0a Error Code from OCIErrorGet^12541


Error 3: ORA-12170: TNS:Connect timeout occurred

2008/04/17@00:29:30.201579 26842 639015 DB_RUNTIME DEBUG3 0x00000201
../db_failover.cpp:677 "Connection Pool Status in ValidateConnections()" NumLivePrimaryConnections^1 Maximum Connections^1 UpConnections^0 Failover Threshold^1 Max Session Time^0 SleepFor^60
2008/04/17@00:29:36.902836 5073 131080 SQL_ADAPTER ERROR 0x00000066 ../ocierrormap.cpp:53 "OCI server connect failed" method^OCIConnection::OCIConnection ociRetCode^OCI_ERROR Diagnostic Record number^1 Error Message^ORA-12170: TNS:Connect timeout occurred%0a Error Code from OCIErrorGet^12170


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms