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

Thanks for the help. Things are working now. For host string entry I had to just enter TESTDB.

Now I have run into another problem. I have installed 1) Oracle 9i Database
2) Oracle 9i Developer Suite

When I try and access the database via the Developer Suite I get same error.

ERROR: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor.

Are two installation different ? Should there be new listener services etc.
My Database Server software is under c:\software\oracle9i My Database Suite Software is under e:\oracle9iDS

thanks - bill

Imprecise <f_puhan_at_precise.com> wrote in message news:<f_puhan-A4ADB4.22454417062002_at_vienna7.his.com>...
> I'm going to hope someone will correct me where I'm (probably) wrong.
>
> I note that in your trace file the CONNECT string seems to think it's
> looking for a SERVICE_NAME of 'mango,' when in fact that's the HOST
> address. I did see that your LISTENER posts a SID_NAME but your
> TNSNAMES.ORA asks for a SERVICE_NAME. Perhaps if you change this in
> your TNSNAMES.ORA file?
>
> No, I'm not smoking anything interesting.
>
> In article <c1042146.0206171731.74e806b6_at_posting.google.com>,
> bill_at_antrix.com (Bill Kurani) wrote:
>
> > 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:\softwar
> > e\oracle\ora90\BIN\sqlplusw.exe)(HOST=MANGO)(USER=Administrator)))(ADDRESS=(PR
> > OTOCOL=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 - 12:38:33 CDT