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
oracle@bcm-laptop:~$ tnsping db11g3 TNS Ping Utility for Linux: Version 188.8.131.52.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 184.108.40.206.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.
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 ?
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