Re: Oracle 8.1.7.0 and Listener - cannot connect to database or service RESOLVED

sorted out the mis-confiurations and got it working

robtechie_at_yahoo.ca (Robert Mendonca) wrote in message news:<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 Sat Sep 07 2002 - 13:51:15 CEST