-
--------
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|