This content has been marked as final. Show 9 replies
thanks for your reply.
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) trace_level_client = 16 trace_file_client = cli.trc trace_directory_client = C:\temp log_file_client = sqlnet.log log_directory_client = C:\temp
DB11G3 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myPC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = db11g3) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) RSERVER = (ADDRESS= (PROTOCOL=tcp) (HOST=localhost) (PORT=1949) )
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\Oracle11gDB_3\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\Oracle11gDB_3\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =myPC)(PORT = 1521)) ) ) ADR_BASE_LISTENER = D:\Oracle11gDB_3
tnsping db11g3 => TNS-3505
is the same as
ORA-12154: TNS:could not resolve the connect identifier specified
which means that the alias (@DB11G3) could not be found & resolved.
The connection request never start & NEVER left the client system.
oracle@bcm-laptop:~$ tnsping db11g3 TNS Ping Utility for Linux: Version 220.127.116.11.0 - Production on 21-NOV-2011 16:20:18 Copyright (c) 1997, 2009, Oracle. All rights reserved. Used parameter files: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora TNS-03505: Failed to resolve name oracle@bcm-laptop:~$ sqlplus scott/tiger@db11g3 SQL*Plus: Release 18.104.22.168.0 Production on Mon Nov 21 16:20:40 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
Can try the following:
Adding the entry for db11g3 in listener.ora and restarting the listener.
The request never left the client. It never got to the listener. Any time spent on the listener when dealing with a ora-03535 (and ora-12154, which is exactly the same error) is a waste of time.
Thanks and Regards,
user12155310 wrote:IN spite of what others are telling you, looking at the listener is a total, complete waste of time for this error.
on Win7 32Bit I used a 11gR1 DB and it worked fine.
I had to rename the hostname of the workstation and corrected the new hostname in the listener.ora and tnsnames.ora.
Now I cannot connect or get a tnsping: I am getting TNS-03505,
in the \diag\tnslsnr there is the new hostname folder of the listener.
Is there a solution for this problem ?
Please read http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
See if the third paragraph ("Hardly a day goes by ....") doesn't sound like this thread.
I had to rename the hostname of the workstation and corrected the new hostname in the listener.ora and tnsnames.ora.First you have conform that the host name is finally set or not. Fire the below command to check
If not change reboot the system and try connect it again ..
Hope this help you