Re: Oracle 9i Windows - ORA-12514 TNS: listener could not resolve SERVICE_NAME

I'm going to hope someone will correct me where I'm (probably) wrong.

I note that in your trace file the CONNECT string seems to think it's looking for a SERVICE_NAME of 'mango,' when in fact that's the HOST address. I did see that your LISTENER posts a SID_NAME but your TNSNAMES.ORA asks for a SERVICE_NAME. Perhaps if you change this in your TNSNAMES.ORA file?

No, I'm not smoking anything interesting.

In article <c1042146.0206171731.74e806b6_at_posting.google.com>,  bill_at_antrix.com (Bill Kurani) wrote:

> Hi folks
>
> I just installed Oracle 9i Enterprise edition on windows
> machine. I traced everything as specified but while trying
> to connect to SQL*Plus. I am typing
> User Name: scott
> Password: tiger
> Host String: mango
>
> I get following message
>
> ERROR: ORA-12514: TNS:listener could not resolve SERVICE_NAME
> given in connect descriptor.
>
> Here are my settings.
> 1) My machine name is mango and I am using as dedicated server.
> 2) From sqlplus on dos windows I can connect as system and scott.
> 3) IP address of my machine is 192.168.1.3
> 4) I have created TESTDB database.
>
> My config files and client trace files are as follows.
> listener.ora, tnsnames.ora, sqlnet.ora and client trace file.
>
> 1) listener.ora
> # LISTENER.ORA Network Configuration File:
> C:\software\oracle\ora90\NETWORK\ADMIN\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = mango)(PORT = 1521))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = C:\software\oracle\ora90)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = TESTDB)
> (ORACLE_HOME = C:\software\oracle\ora90)
> (SID_NAME = TESTDB)
> )
> )
>
> TRACE_LEVEL_LISTENER = USER
>
> 2) tnsnames.ora
>
> # TNSNAMES.ORA Network Configuration File:
> C:\software\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> TESTDB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = mango)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = TESTDB)
> )
> )
>
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = mango)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = MODOSE)
> (PRESENTATION = http://HRService)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> 3) sqlnet.ora
>
> # SQLNET.ORA Network Configuration File:
> C:\software\oracle\ora90\NETWORK\ADMIN\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> TRACE_DIRECTORY_CLIENT = c:\tmp\client
>
> TRACE_UNIQUE_CLIENT = on
>
> TRACE_DIRECTORY_SERVER = c:\tmp\server
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> TRACE_FILE_SERVER = server
>
> TRACE_LEVEL_CLIENT = USER
>
> TRACE_LEVEL_SERVER = USER
>
> 4) Client Trace file
>
>
>
> --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
> New trace stream is c:\tmp\client\cli_2748_1.trc
> New trace level is 4
> --- TRACE CONFIGURATION INFORMATION ENDS ---
>
> --- PARAMETER SOURCE INFORMATION FOLLOWS ---
> Attempted load of system pfile source
> C:\software\oracle\ora90\network\admin\sqlnet.ora
> Parameter source loaded successfully
>
> Attempted load of local pfile source
> C:\software\oracle\ora90\BIN\sqlnet.ora
> Parameter source was not loaded
>
> -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
> Successful parameter table load
> -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
> TRACE_DIRECTORY_SERVER = c:\tmp\server
> TRACE_DIRECTORY_CLIENT = c:\tmp\client
> TRACE_LEVEL_CLIENT = USER
> TRACE_FILE_SERVER = server
> SQLNET.AUTHENTICATION_SERVICES = (NTS)
> TRACE_UNIQUE_CLIENT = on
> TRACE_LEVEL_SERVER = USER
> --- PARAMETER SOURCE INFORMATION ENDS ---
>
> --- LOG CONFIGURATION INFORMATION FOLLOWS ---
> Log stream will be "C:\software\oracle\ora90\BIN\sqlnet.log"
> Log stream validation not requested
> --- LOG CONFIGURATION INFORMATION ENDS ---
>
> nigini: Count in NI global area now: 1
> nigini: Count in NI global area now: 1
> nrigbni: Unable to get data from navigation file tnsnav.ora
> niotns: niotns: setting up interrupt handler...
> niotns: Not trying to enable dead connection detection.
> niotns: Calling address:
> (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=mango)(CID=(PROGRAM=C:\softwar
> e\oracle\ora90\BIN\sqlplusw.exe)(HOST=MANGO)(USER=Administrator)))(ADDRESS=(PR
> OTOCOL=TCP)(HOST=mango)(PORT=1521)))
> nscall: connecting...
> nttgetport: port resolved to 1521
> nttbnd2addr: looking up IP addr for host: mango
> nsopen: opening transport...
> nttcnp: Validnode Table IN use; err 0x0
> nttcni: trying to connect to socket 504.
> nttcon: set TCP_NODELAY on 504
> nsopen: transport is open
> nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61
> nsopen: global context check-in (to slot 0) complete
> nscon: doing connect handshake...
> nscon: sending NSPTCN packet
> nscon: got NSPTRF packet
> nscall: refused
> nstimarmed: no timer allocated
> nsclose: closing transport
> nsclose: global context check-out (from slot 0) complete
> nscall: connecting...
> nioqper: error from nscall
> nioqper: nr err code: 0
> nioqper: ns main err code: 12564
> nioqper: ns (2) err code: 0
> nioqper: nt main err code: 0
> nioqper: nt (2) err code: 0
> nioqper: nt OS err code: 0
> niqme: reporting NS-12564 error as ORA-12564
> niomapnserror: returning error 12564
> niqme: reporting NSG-12514 error as ORA-12514
> niotns: Couldn't connect, returning 12514
> nigtrm: Count in the NI global area is now 0
> nigtrm: Count in the NL global area is now 0

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!