My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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