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

From: Bill Kurani <bill_at_antrix.com>
Date: 17 Jun 2002 18:31:15 -0700
Message-ID: <c1042146.0206171731.74e806b6@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.

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:\software\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 - 20:31:15 CDT

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