My Oracle Support Banner

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 MARCH 07, 2023

Applies to:

Oracle Internet Directory - Version 11.1.1 and later
Information in this document applies to any platform.

Symptoms

12c:

Oracle Internet Directory (OID) 12c fails to start with log error:

[2017-10-24T14:01:20.471091+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [oidmon]: Unable to connect to database,
           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
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: Connecting to database, connect string is oiddb

[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


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