OID Fails to Start / Oidmon Log Shows Error: ORA-12154: TNS:could not resolve the connect identifier specified
(Doc ID 1328258.1)
Last updated on AUGUST 07, 2024
Applies to:
Oracle Internet Directory - Version 11.1.1 and laterInformation in this document applies to any platform.
Symptoms
12c:
Oracle Internet Directory (OID) 12c fails to start with log error:
will retry again after 10 sec
[2017-10-24T14:01:30.484774+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [gsdsiConnect] ORA-12154, ORA-12154: TNS:could not resolve the connect identifier specified
The database is up and reachable from OID software owner via sqlplus.
11g:
Oracle Internet Directory (OID) 11g startup fails:
opmnctl startall: starting opmn and all managed processes...
================================================================================
opmn id=<ID>:<PORT>
0 of 1 processes started.
ias-instance id=<INSTANCE_NAME>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
oid1/oidmon/OID/
Error
--> Process (index=1,uid=<UID>,pid=<PID>)
time out while waiting for a managed process to start
Log:
$ORACLE_INSTANCE/diagnostics/logs/OID/oid1/console~OID~1.log
$ORACLE_INSTANCE/diagnostics/logs/OID/oid1/oidmon-0001.log shows error:
[2011-06-01T10:05:43-04:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <OID_HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [gsdsiConnect] ORA-12154, ORA-12154: TNS:could not resolve the connect identifier specified
[2011-06-01T10:05:43-04:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <OID_HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [oidmon]: Unable to connect to database,
will retry again after 10 sec
Tried the following to no avail:
- Setting and unsetting $TNS_ADMIN variable.
- Checked $ORACLE_INSTANCE/config/tnsnames.ora and that no sqlnet.ora exists in that location.
- Checked that $ORACLE_INSTANCE/config/OPMN/opmn/opmn.xml points to $ORACLE_INSTANCE/config/tnsnames.ora and its connecting information looks correct.
SQLPlus command line (sqlplus ods@oiddb) works, but may also return the same ORA-12154 error when $TNS_ADMIN is set to $ORACLE_INSTANCE/config.
Changes
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 |
Changes |
Cause |
Solution |
References |