OID 11g Fails To Start / Oidmon Log (and/or SQLPlus) Shows Error: ORA-12154: TNS:could not resolve the connect identifier specified (Doc ID 1328258.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

Oracle Internet Directory (OID) 11g startup fails:

> opmnctl startall
opmnctl startall: starting opmn and all managed processes...
================================================================================
opmn id=s1dda32:6701
  0 of 1 processes started.

ias-instance id=asinst_1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
  oid1/oidmon/OID/

Error
--> Process (index=1,uid=522675534,pid=12931)
  time out while waiting for a managed process to start
  Log:
  /u01/app/product/Middleware/asinst_1/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: myoidhost] [pid: 3167] [tid: 0] Guardian: Connecting to database, connect string is oiddb

[2011-06-01T10:05:43-04:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: myoidhost] [pid: 3167] [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: myoidhost] [pid: 3167] [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

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