Home » RDBMS Server » Networking and Gateways » TNS:could not resolve the connect identifier specified (Oracle,10.2.0,Windows XP)
TNS:could not resolve the connect identifier specified [message #606881] Thu, 30 January 2014 06:57 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
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

Re: TNS:could not resolve the connect identifier specified [message #606895 is a reply to message #606886] Thu, 30 January 2014 08:55 Go to previous messageGo to next message
gazzag
Messages: 332
Registered: November 2010
Location: Bristol, UK
Senior Member
Also, what is this in your connect string?

TEST_35=...
Re: TNS:could not resolve the connect identifier specified [message #606948 is a reply to message #606895] Fri, 31 January 2014 01:26 Go to previous message
taoqir.hassan
Messages: 16
Registered: February 2013
Location: LAHORE
Junior Member

Hi,
Thank you BlackSwan,gazzag Problem soleved by carefuly and properly indinting all tns entries,all parenthese,spellings in tnsnames.ora file
Now
:\Documents and Settings\taoqir>tnsping fc_prod

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 31-JAN-2
014 12:15:09

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)))
OK (60 msec)


Thanks and Best Regards,

Taoqir
Previous Topic: Oracle ports
Next Topic: TNS Error when using DB link
Goto Forum:
  


Current Time: Wed Oct 22 07:43:17 CDT 2014

Total time taken to generate the page: 0.11605 seconds