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

Try adding '.world' (without the quotes) to global_dbname
and service_name.

It's not my normal working area, so -
However, I believe that Howard wrote something like the above
(eeh, not the working area stuff :-))
in one of his posts (maybe not in this NG) in March ('It's a convoluted story')
Anyway, Thanks Howard ! (and certainly also for all off your other
contributions).

Bill,
You have done a (google) search, right !

"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.c om...
> > 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.or a
> > # 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.or a
> > # 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=ma ngo)(CID=(PROGRAM=C:\softw
>

are\oracle\ora90\BIN\sqlplusw.exe)(HOST=MANGO)(USE R=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 - 12:43:05 CDT