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

I'll try not to hit the "SEND" button too soon this time!

The problem is that your host string shouldn't be "mango" (the name of your server), but TESTDB, the name of the service you are trying to connect to.

Regards
HJR "Bill Kurani" <bill_at_antrix.com> wrote in message news:c1042146.0206171731.74e806b6_at_posting.google.com...
> 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:\softw are\oracle\ora90\BIN\sqlplusw.exe)(HOST=MANGO)(USER=Administrator)))(ADDRESS =(PROTOCOL=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
Received on Mon Jun 17 2002 - 21:39:33 CDT