oidctl status Fails to Show Correct Information (Doc ID 946668.1)

Last updated on OCTOBER 14, 2019

Applies to:

Symptoms

• After starting OID using opmnctl, oidctl shows it as not running, using either of the SID or service name in the command:
  
  
  oidctl connect=<CONNECT_STRING> status
      oidctl:Checking Oracle Internet Directory Processes ...
      Process oidmon is not running
      OIDLDAPD instance is not configured
  ...
  oidctl connect=<CONNECT_STRING> status
      oidctl:Checking Oracle Internet Directory Processes ...
      Process oidmon is not running
      OIDLDAPD instance is not configured
  ...

• opmnctl status shows OID as Alive:
  
  
  Processes in Instance:  
  -------------------+--------------------+---------+---------
  ias-component | process-type | pid | status
  -------------------+--------------------+---------+---------
  DSA | DSA | N/A | Down
  HTTP_Server | HTTP_Server | N/A | Down
  LogLoader | logloaderd | N/A | Down
  dcm-daemon | dcm-daemon | N/A | Down
  OID | OID | 5935172 | Alive

• A ps command shows the OID processes running:
  
  
  oracle <PID> 1 2 07:45:38 - 5:16 oidldapd connect=<CONNECT_STRING> control=5099602 dispatcher=1 worker=2 debug=33554432 configset=0 instance=1 key=272919841 host=<HOSTNAME> trcdimension=511 logchange=TRUE port=<OID_NONSSL_PORT> sport=<OID_SSL_PORT> 
  
  oracle <PID> 1 3 07:45:37 - 0:45 <ORACLE_HOME>/bin/oidldapd connect=<CONNECT_STRING> -p <OID_NONSSL_PORT> -i 1 -conf 0 -sport <OID_SSL_PORT> -sslenable 2 key=272919841
  
  oracle <PID> 0 07:45:37 - 0:18 <ORACLE_HOME>/bin/oidmon connect=<CONNECT_STRING> -opmnuid xxxxxxxx start

• opmn.xml shows the same connect string as used in the oidctl comand:
  
  
  - <process-set id="OID" numprocs="1">
    - <module-data>
    - <category id="oidctl-parameters">
        <data id="connect" value="<CONNECT_STRING>" />
        <data id="startoidldapd" value="true" />
    </category>
    - <category id="oidmon-parameters">
        <data id="connect" value="<CONNECT_STRING>" />
        <data id="run-oidctl" value="true" />
    </category>
  ...

• ldapbind is successful to this OID
• oidctl status returns the correct information when using the hostname:
  
  
  oidctl host=<HOSTNAME> status
      oidctl:Checking Oracle Internet Directory Processes ...
      Process oidmon is alive as PID = <PID>
      Checking OIDLDAPD instance 1 ... 
      Process oidldapd (dispatcher) is alive as PID = <PID> port=<OID_NONSSL_PORT> sslport=<OID_SSL_PORT> 
          oidldapd (server) is alive as PID = <PID> 
  ...

• $TNS_ADMIN is set to the OID $ORACLE_HOME/network/admin directory
• $PATH shows the OID $ORACLE_HOME/bin first
• $ORACLE_SID is set to the SID (<SID>)
• nslookup returns identical information for hostname, and hostname.domain
• ods.ods_process table shows the same records whether connecting with the listener (sqlplus ods/<PASSWORD>@<SID>) or not (sqlplus ods/<PASSWORD>), and the hostname listed is fully qualified (<HOSTNAME>)
• /etc/resolv.conf correctly shows a line with the domain:
  
  
  domain <COMPANY>.com
  nameserver <IP>
  nameserver <IP>

• sqlnet.ora correctly shows TNSNAMES first in the NAMES.DIRECTORY_PATH
• tnsnames.ora includes the domain for the HOST parameter for this database
• The command 'hostname' returns only the hostname (no domain listed)
• Every line is commented out in the /etc/netsvc.conf
• "netstat -a" returns "<HOSTNAME>.<PORT>" instead of "<FQ_HOSTNAME>.<PORT>"
• The issue reported here was on AIX, which may or may not be relevant

Cause

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