"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:37:30 CDT
