“OCI server connect failed” error while creating Database instance for DB Auditing in Oracle Access Manager
I have come across an error while creating a DB instance for configuring the DB auditing in Oracle Access Manager.
The error message shown in identity server oblog is this:
2011/03/07@11:50:00.796402 14540 14540 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
The DB instance creation page details are as shown below.
When I saved the configurations, I got the error as shown below.
Workaround:
- Modify the start_ois_server present in OAM_IDENTITY_SERVER/oblix/apps/common/bin location to include and export the parameters ORACLE_HOME and ORACLE_SID as shown below.
##### OAM Auditing feature settings starts ####
ORACLE_SID=IDMTEST; export ORACLE_SID
ORACLE_HOME=/u01/apps/oracle_db_client; export ORACLE_HOME
#######OAM Auditing feature settings end ########
- Set the environment variable TNS_ADMIN in the machine. I am using Linux machine and hence set it in .bash_profile of the user installed OAM as shown below. This setting is required if you are using OAM 10.1.4.2+. For this env variable to take into effect, bounce the machine.
### This env variable TNS_ADMIN is for OAM DB auditing
TNS_ADMIN=/u01/apps/oracle_db_client
export TNS_ADMIN
### done DB Auditing env setting
Referenced documents:
Metalink note: 1111391.1
About the Author Mahendra
I am engulfed in Oracle Identity & Access Management domain. I have expertise on providing the optimized solutions for user provisioning, web access management, Single Sign-On and federation capabilities etc., I am also well versed with complex integrations within Identity Management and other product domains. I have expertise on building demos and implementation experience on products Oracle Access Manager, Oracle Adaptive Access Manager, Oracle Entitlement Server, Oracle Virtual Directory, Oracle Internet Directory etc., Look @ my blog: http://talkidentity.blogspot.com