Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i Windows - ORA-12514 TNS: listener could not resolve SERVICE_NAME

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

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Wed, 19 Jun 2002 12:22:59 +0400
Message-ID: <aepf0t$hs1$1@babylon.agtel.net>


Yeah, I realized this after posting the response. Sometimes the answer is much more obvious than one thinks it is... :)

-- 
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:aeo38b$e60$1_at_lust.ihug.co.nz...

> He's talking about the old GUI-version of SQL Plus (I assume), which comes
> up with a pop-up dialog that does (in 9i release 2 at least) ask for a 'Host
> String'.
>
> I stick my tnsnames alias in there, and everything works fine. I stick my
> Server name in there, and it all goes pear-shaped.
>
> He's typing his machine name. It ought to be his SID or Service.
>
> Regards
> HJR
>
>
> "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message
> news:aentjc$5vi$1_at_babylon.agtel.net...
> > 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_at_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 Wed Jun 19 2002 - 03:22:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US