DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: OID not resloving service names after bouncing repository

  1. #11
    Join Date
    Oct 2005
    Posts
    90
    --------
    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

  2. #12
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    This is your error

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

    resolve it first

    regards
    Hrishy

  3. #13
    Join Date
    Oct 2005
    Posts
    90
    $ 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

  4. #14
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Ask your DBA please he can resolve this.

    He needs to correctly configure the tnsnames.ora file

    regards
    Hrishy

  5. #15
    Join Date
    Oct 2005
    Posts
    90
    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

  6. #16
    Join Date
    Oct 2005
    Posts
    90
    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

  7. #17
    Join Date
    Oct 2005
    Posts
    90
    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

  8. #18
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Check it everything seems fine to me no ?

    regards
    Hrishy

  9. #19
    Join Date
    Oct 2005
    Posts
    90
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width