Oracle 8.1.7.0 and Listener - cannot connect to database or service

From: Robert Mendonca <robtechie_at_yahoo.ca>
Date: 5 Sep 2002 14:11:49 -0700
Message-ID: <6d8d02b5.0209051311.14a22db2_at_posting.google.com>

Hi

I am having the following issues with the Listener task and Oracle installation.
Oracle 8.1.7 [no patches] on Win2K platform. I need this installation for my WebSphere server and it was setup for me by the DBAs. They have not been able to resolve the issue [obviously looks like wrongly configured].
The listener log has the SID specified as orcl but all references to orcl in the ora files are in upper case. Also there does not seem to be consistency in the Service names e.g ORCL or ORCL.world in the various ora files.

Any pointers greatly appreciated.

I. listener.log extract
05-SEP-2002 12:07:50 *
(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.24.40.142)(PORT=3275)) * establish * orcl * 12500
TNS-12500: TNS:listener failed to start a dedicated server process  TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error
   32-bit Windows Error: 2: No such file or directory

TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production on 05-SEP-2002 12:09:50 (c) Copyright 1998 Oracle Corporation. All rights reserved.

System parameter file is D:\oracle\ora81\network\admin\listener.ora Log messages written to D:\oracle\ora81\network\log\listener.log Trace information written to
D:\oracle\ora81\network\trace\listener.trc Trace level is currently 0

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TORONTSN41.nam.pwcinternal.com)(PORT=1521))) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

05-SEP-2002 12:10:02 * service_register * ORCL * 0
05-SEP-2002 12:10:11 * service_update * ORCL * 0
05-SEP-2002 12:10:30 *

(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.24.40.142)(PORT=1047)) * establish * orcl * 0
05-SEP-2002 12:10:44 *
(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.24.40.142)(PORT=1054)) * establish * orcl * 0
05-SEP-2002 12:11:35 *
(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.24.40.142)(PORT=1078)) * establish * orcl * 0
05-SEP-2002 12:11:36 *
(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.24.40.142)(PORT=1081)) * establish * orcl * 0
05-SEP-2002 12:11:37 * service_update * ORCL * 0 05-SEP-2002 15:11:42 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=NOtesops))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0
05-SEP-2002 15:12:01 * ping * 0
05-SEP-2002 15:16:45 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=NOtesops))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0

II. Listener.ora
# LISTENER.ORA Network Configuration File: D:\oracle\ora81\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = TORONTSN41)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = ORCL)
    )
  )

III.TNSNames.ora
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

INST1_HTTP.NAM.PWCINTERNAL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = torontsn41)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ORCL)
(PRESENTATION = http://admin)

    )
  )

ORCL.nam.pwcinternal.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = torontsn41)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = ORCL)

    )
  )

PRDNEWS.nam.pwcinternal.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = torontss96)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = PRDNEWS)

    )
  )

IV. SQLNet.ora
# SQLNET.ORA Network Configuration File: D:\oracle\ora81\network\admin\sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = nam.pwcinternal.com SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) V. INITorcl.ora
# LISTENER.ORA Network Configuration File: D:\oracle\ora81\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = TORONTSN41)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = ORCL)
    )
  )

VI. output of Listener status command

	Service ORCL has 1 instances. 		Status Ready	CLASS Oracle
	Total handlers 1	Relevant handlers 1
	Service ORCL.world has 1 instances. 	Status Ready	CLASS Oracle
	Total handlers 1	Relevant handlers 1

VII. output of Listener Services ORCL command
	TNS-01101 - could not find service name ORCL
	NNC 00405: network failure

VIII. output of Listener Services ORCL.world command
	TNS-01101 - could not find service name ORCL
	NNC 00405: network failure

IX.	TNSListener and ORCL service tasks have been set up as NT service

and start up automatically. Received on Thu Sep 05 2002 - 23:11:49 CEST