Re: More info -- PLEASE HELP
Date: Thu, 16 May 2002 17:56:25 +0000 (UTC)
Message-ID: <ac0rs8$p10$1_at_helle.btinternet.com>
I've tried to get some more information to try and figure out whats going on and I noticed that when the Installer starts up the listener even though it shows the listener as listening and in progress the task lsnrctl has actually gone defunct. I've attached the details of the logs and config files in the hope some some kind oracle guru can spot what may be causing me the problems !!!!!!
When thew listener starts in the Oracle Universal Installer the following is displayed :
NSN_NUMBER=1 NSN_NAMES={"EXTPROC_CONNECTION_DATA"} NSN_DBVERSION={"80"} NSN_SERVICE_OR_SID = {"PLSExtProc"} NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
The listener.log contains :
TNSLSNR for Linux: Version 9.0.1.0.0 - Production on 16-MAY-2002 18:01:27
Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
System parameter file is
/opt/oracle/product/9.0.1/network/admin/listener.ora
Log messages written to /opt/oracle/product/9.0.1/network/log/listener.log
Trace information written to
/opt/oracle/product/9.0.1/network/trace/listener.trc
Trace level is currently 0
Started with pid=18312
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hotrats)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
16-MAY-2002 18:01:28 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=hotrats)(USER=oracle))(COMMAND=status)(AR
GUMENTS=64)(SERVICE=LISTENER)(VERSION=150999040)) * status * 0
16-MAY-2002 18:09:41 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=hotrats)(USER=oracle))(COMMAND=status)(AR
GUMENTS=64)(SERVICE=LISTENER)(VERSION=150999040)) * status * 0
And the listener.ora contains :
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.0.1/network/admin/listener.ora # Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) )
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc) (ORACLE_HOME = /opt/oracle/product/9.0.1) (PROGRAM = extproc)
)
) Received on Thu May 16 2002 - 19:56:25 CEST