Re: More Info -- PLEASE HELP

From: Steven Webb <Swebb999_at_btopenworld.com>
Date: Thu, 16 May 2002 17:57:32 +0000 (UTC)
Message-ID: <ac0rub$ae2$1@paris.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 :

Parsing command line arguments:

 Parameter "orahome" = /opt/oracle/product/9.0.1
 Parameter "instype" = typical
 Parameter "inscomp" = client,oraclenet,javavm,server,ano
 Parameter "insprtcl" = tcp, tcps
 Parameter "cfg" = local
 Parameter "authadp" = NO_VALUE
 Parameter "nodeinfo" = NO_VALUE
 Parameter "responsefile" =

/opt/oracle/product/9.0.1/network/install/netca_typ.rsp Done parsing command line arguments.Oracle Net Services Configuration: Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/opt/oracle/product/9.0.1/bin/lsnrctl start LISTENER

It then just sits there however the lsnrctl is show as :

oracle 18310 18300 0 18:01 pts/1 00:00:00 [lsnrctl <defunct>]

The response file contains :

[GENERAL]

RESPONSEFILE_VERSION="8.1.7"
CREATE_TYPE= "TYPICAL"
[Session]

TOPLEVEL_COMPONENT={"oracle.net.ca","8.1.7"}
[oracle.net.ca]

INSTALLED_COMPONENTS={"server","net8","javavm"} INSTALL_TYPE=""typical""

LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""

NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}

NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_DBVERSION={"80"}
NSN_SERVICE_OR_SID = {"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}

the netca_clt.rsp contains :

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

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 - 12:57:32 CDT