OAM Audit to RDBMS Database Is Failing With Error ORA-12154 (Doc ID 1265963.1)

Last updated on MARCH 08, 2017

Applies to:

COREid Access - Version: 10.1.4.3.0 and later   [Release: and later ]
COREid Identity - Version: 10.1.4.3 and later ]
Information in this document applies to any platform.

Symptoms


Oracle Access Manager (OAM) auditing to RDBMS database is not working for a specific Access Server installation on a Windows platform.

The tnsnames.ora entry is valid and is working for Identity Server audit to database and/or other Access Server installations on different servers.

The Access Server TRACE level log entries shows error 'ORA-12154: TNS:could not resolve the connect identifier specified' when establishing the OCI connection to the audit database:

....
2010/10/25@07:04:32.299000 108572 19352 DB_RUNTIME TRACE 0x00000203 sql_connection_mngr.cpp:79 "Function entered" _TraceName^SQLConnectionManager::_CreateAndOpenConnection
2010/10/25@07:04:32.424000 108572 19352 SQL_ADAPTER DEBUG1 0x00000201 ociadapter.cpp:121 "OCI environment handle created successfully"
2010/10/25@07:04:32.424000 108572 19352 SQL_ADAPTER DEBUG1 0x00000201 ociconnection.cpp:58 "OCI error handle created successfully"
2010/10/25@07:04:32.424000 108572 19352 SQL_ADAPTER DEBUG1 0x00000201 ociconnection.cpp:77 "OCI service context handle created successfully"
2010/10/25@07:04:41.658000 108572 19352 SQL_ADAPTER ERROR 0x00000066 ocierrormap.cpp:53 "OCI server connect failed" method^OCIConnection::OCIConnection ociRetCode^OCI_ERROR Diagnostic Record number^1 Error Message^ORA-12154: TNS:could not resolve the connect identifier specified%0a Error Code from OCIErrorGet^12154
2010/10/25@07:04:41.658000 108572 19352 DB_RUNTIME WARNING 0x00000504 \Oblix\oam\np_common\db\utils\db_connection_mngr.cpp:350 "Exception during DB runtime code" function^DBConnectionManager::CheckOutConnection
....



The tnsnames.ora entry is valid and is working for Identity Server audit to database and/or other Access Server installations on different servers.

Unable to test the TNS alias using SQLPlus on the problem Access Server machine because SQLPlus is not installed there.


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