| TNS:could not resolve the connect identifier specified [message #606881] |
Thu, 30 January 2014 06:57  |
 |
taoqir.hassan
Messages: 16
Registered: February 2013
Location: LAHORE
|
Junior Member |
|
|
Hi Everyone,
I am to trying to connect with SQLPLUS with an allias and geting this error
ERROR"ORA-12154: TNS:could not resolve the connect identifier specified
C:\Documents and Settings\taoqir>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 30-JAN-2014 17:50
:26
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 30-JAN-2014 12:41:09
Uptime 0 days 5 hr. 9 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=flexcube-touqir.taoqir.com)(PORT=1
521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=
HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Documents and Settings\taoqir>tnsping fc_prod
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 30-JAN-2
014 17:51:19
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact ( DESCRIPTION = ( ADDRESS=(PROTOCOL=TCP)(HOST=10.10.1.42)(
PORT=1521)) ( CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=orcl))) TEST_35= (
DESCRIPTION = ( ADDRESS=(PROTOCOL=TCP)(HOST=10.10.1.35)(PORT=1521)) ( CONNECT_DA
TA= (SERVER=DEDICATED) (SERVICE_NAME=SORCL) ) )
TNS-12533: TNS:illegal ADDRESS parameters
Please Guide,
Thanks and Best Regads,
Taoqir
[Updated on: Thu, 30 January 2014 06:57] Report message to a moderator |
|
|
|
| Re: TNS:could not resolve the connect identifier specified [message #606886 is a reply to message #606881] |
Thu, 30 January 2014 08:17  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
>(HOST=flexcube-touqir.taoqir.com)
what is IP# for hostname above?
>Attempting to contact ( DESCRIPTION = ( ADDRESS=(PROTOCOL=TCP)(HOST=10.10.1.42)(
>PORT=1521)) ( CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=orcl))) TE
listener knows nothing about any SERVICE_NAME=orcl
[Updated on: Thu, 30 January 2014 08:26] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
