OID not resloving service names after bouncing repository

I installed and configured OID(10g) and repository name is oidtest on hpux 11.1.

1)Before shutting down the repository

C:\Oracle\ora92\network\ADMIN>tnsping dbtest1

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-NOV-20
07 16:34:05

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
c:\oracle\ora92\network\admin\sqlnet.ora

Used LDAP adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(address=(protocol=tcp)(host=xx
xxxx.xx.xxx.com)(port=1533)))(CONNECT_DATA=(SID=DBTEST1)(GLOBAL_NAME=DBTEST1.xx
xx.xx.com)))
OK (60 msec)

2)after restarting the repository

C:\Oracle\ora92\network\ADMIN>tnsping dbtest1

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-NOV-20
07 16:37:24

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
c:\oracle\ora92\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

$ ps -ef|grep pmon
oracle 29430 1 0 22:35:23 ? 0:00 ora_pmon_oidtest
oracle 29756 21439 2 22:38:16 pts/2 0:00 grep pmon

$ opmnctl status

Processes in Instance: panther_oid_a.panther.am.kwe.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
DSA | DSA | N/A | Down
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 26840 | Alive
HTTP_Server | HTTP_Server | 26704 | Alive
OID | OID | 26435 | Alive

Any ideas why it can't resolve service name anymore after bouncing the repository?



Thanks

Hi

Any error messages in

$ORACLE_HOME/ldap/log


You can also try

opmnctl stopall

wait for a about 2-3 minutes and then try

opmnctl startall


or opmnctl reload

regards
Hrishy

$ opmnctl stopall
opmnctl: stopping opmn and all managed processes...

$ opmnctl startall
opmnctl: starting opmn and all managed processes...

It hang here for almost 30 min and then came out with this error.

================================================================================
opmn id=panther:6200
1 of 2 processes started.

ias-instance id=panther_oid_a.panther.am.kwe.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
OID/OID/OID

Error
--> Process (pid=0)
database dependency failed
oidtest
failed to start a managed process because a dependency check failed
Log:
none

Hi

Any error messages in

$ORACLE_HOME/ldap/log

has the listener been started on the oidtest database ?

regards
Hrishy

Yes listener is up and running.No errors in the log.

ps -ef|grep lsnr
oracle 20703 1 0 Nov 30 ? 0:12 /amoidts1/OID/bin/tnslsnr LISTENER -inherit

This is the error i am getting from application server farm page


Logs Topology Preferences Help




Farm >



Error



Error initializing page. Error initializing SMISessionManager.createSession(). Resolution: Please make sure the file is in the correct location. Base Exception: OPMN Request: /start?mode=sync&ias-component=dcm-daemon OPMN Response: HTTP/1.1 204 No Content Content-Length: 709 Content-Type: text/html Response: 0 of 1 processes started. Resolution: If there is no response from OPMN, check OPMN configuration and restart DCM daemon. If OPMN response is available, identify the failure and the corresponding log files indicated in the OPMN response contents. Base Exception: OPMN Request: /start?mode=sync&ias-component=dcm-daemon OPMN Response: HTTP/1.1 204 No Content Content-Length: 709 Content-Type: text/html Response: 0 of 1 processes started. Resolution: If there is no response from OPMN, check OPMN configuration and restart DCM daemon. If OPMN response is available, identify the failure and the corresponding log files indicated in the OPMN response contents

Hi

Whats the output of
# opmnctl status

Anything in
ORACLE_HOME/opmn/logs/opmn.log

regards
Hrishy

$ opmnctl status

Processes in Instance: panther_oid_a.panther.am.kwe.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
DSA | DSA | N/A | Down
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | N/A | Down
HTTP_Server | HTTP_Server | 10570 | Alive
OID | OID | N/A | Down


/amoidts1/OID/opmn/logs/
vi opmn.log
OPMN worker process exited with status 4. Restarting
OPMN worker process exited with status 4. Restarting
OPMN worker process exited with status 4. Restarting

Hi

Are there any other logfiles in ORACLE_HOME/opmn/logs/
for specific components like oid and dcmdeamon.

what happens if you try and start the individual components

opmnctl startproc ias-component=OID

regards
Hrishy

/amoidts1/OID/opmn/logs
vi dcm-daemon~dcm-daemon~dcm~1
07/12/03 15:39:48 Start process
--------

ADMN-202046
The OracleAS Repository API threw an exception when obtaining the connect string to the Metadata Repository
Resolution:
Check the exception thrown by the Repository API for resolution information.
Some common causes of this problem are as follows:
OID is not running or unavailable
the ias.properties file is misconfigured with incorrect OID connection information
OID permissions are incorrectly defined
Base Exception:
oracle.ias.repository.schema.SchemaException
Unable to establish connection to the Oracle Internet Directory Server ldap://panther.am.kwe.com:389/. Base Exception : javax.naming.CommunicationException: panther.am.kwe.com:389 [Root exception is java.net.ConnectException: Connection refused]

/amoidts1/OID/opmn/logs
vi oidtest
--------
07/11/30 22:12:32 Dependency check
--------
Error - ORA-28000: the account is locked

oidtest is available
SUCCEEDED


Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified




Command is just hangng there....
opmnctl startproc ias-component=OID

Hi

This is your error

Code:

---

Unable to establish connection to
the Oracle Internet Directory Server
 ldap://panther.am.kwe.com:389/

---

Try pinging to your repository sid

tnsping reposid

if the tnsping doesnt work that means you need to restart the listener at the repository SID.

You need to get the copmmand tnsping reposid to work and then do opmnctl startall

regards
Hrishy

--------
07/11/30 22:12:32 Dependency check
--------
Error - ORA-28000: the account is locked

oidtest is available
SUCCEEDED

--------
07/12/03 15:21:48 Dependency check
--------
Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Error - ORA-12154: TNS:could not resolve the connect identifier specified

Hi

This is your error

Error - ORA-12154: TNS:could not resolve the connect identifier specified

resolve it first

regards
Hrishy

$ lsnrctl start LISTENER

LSNRCTL for HPUX: Version 10.1.0.5.0 - Production on 03-DEC-2007 17:10:01

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Starting /amoidts1/OID/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.1.0.5.0 - Production
System parameter file is /amoidts1/OID/network/admin/listener.ora
Log messages written to /amoidts1/OID/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxx.am.xxx.com)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=panther.am.kwe.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.1.0.5.0 - Production
Start Date 03-DEC-2007 17:10:01
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /amoidts1/OID/network/admin/listener.ora
Listener Log File /amoidts1/OID/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxx.xx.xxx.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$ tnsping oidtest

TNS Ping Utility for HPUX: Version 10.1.0.5.0 - Production on 03-DEC-2007 17:10:13

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/amoidts1/OID/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

Hi

Ask your DBA please he can resolve this.

He needs to correctly configure the tnsnames.ora file

regards
Hrishy

opmnctl startall

$ opmnctl status

Processes in Instance: panther_oid_a.panther.am.kwe.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
DSA | DSA | N/A | Down
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | N/A | Down
HTTP_Server | HTTP_Server | 10570 | Alive
OID | OID | 20301 | Alive

Tns issue is resolved my wrong.But opmnctl status still show

$ opmnctl status

Processes in Instance: panther_oid_a.panther.am.kwe.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
DSA | DSA | N/A | Down
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | N/A | Down
HTTP_Server | HTTP_Server | 10570 | Alive
OID | OID | 20301 | Alive

Hurray!!! you rock Hrishy :)

C:\Documents and Settings\sali>tnsping dbtest1

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 03-DEC-20
07 11:20:44

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
c:\oracle\ora92\network\admin\sqlnet.ora

Used LDAP adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(address=(protocol=tcp)(host=PA
NTHER.am.kwe.com)(port=1533)))(CONNECT_DATA=(SID=DBTEST1)(GLOBAL_NAME=DBTEST1.gi
tdal.kwe.com)))
OK (20 msec)

Thanks a ton Hrishy

Hi

Check it everything seems fine to me no ?

regards
Hrishy

Yep,You saved my day 2day Hrishy :) ,i really appreciate it.

$ opmnctl status

Processes in Instance: panther_oid_a.panther.am.kwe.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
DSA | DSA | N/A | Down
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | 20652 | Alive
HTTP_Server | HTTP_Server | 10570 | Alive
OID | OID | 20301 | Alive

Thanks once again.