Hmm... Unless the syntax changed in 9i, (HOST=hostname) and
(SERVICE_NAME=service name), and I see that it is set correctly
to (HOST=mango)...(SERVICE_NAME=TESTDB)
in the TNSNAMES.ORA Bill quoted. Can it be that sqlplusW picks
up wrong tnsnames.ora for some reason (Bill also states that he
can make connections ok with plain sqlplus) or that the client
tnsnames.ora he tries on is different and invalid? Or am I drinking
too much coffee lately? :)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:aem6ht$ju0$1_at_lust.ihug.co.nz...
> 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 Tue Jun 18 2002 - 13:19:30 CDT
