Extproc listener restart causes calling program to sleep/hang
Date: 17 Jul 2003 02:27:41 -0700
Message-ID: <c6d78d84.0307170127.4212e512_at_posting.google.com>
Hi,
I have a wierd problem when restarting listener. Basically we have a
install utility that updates the listener.ora and tnsnames.ora files
for "extproc"
And then restarts the listener (for extproc only).
Thought the restart works just fine, the installer utility does not come back to the shell and I need to use Ctrl-C :(
Here is an example of what we add to the .ora files:
tnsnames.ora:
-------------------------------------------------------------------------------EXTPROC_CONNECTION_DATA
=
(DESCRIPTION =
(ADDRESS=(PROTOCOL=IPC)(KEY=extproc)) (CONNECT_DATA=(SID=extproc))
)
listener.ora:
-------------------------------------------------------------------------------EXTERNAL_PROCEDURE_LISTENER
=
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=extproc)))
SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
(SID_LIST=(SID_DESC=(SID_NAME=extproc) (ORACLE_HOME=/usr/up/oracle)(PROGRAM=extproc)))
-------------------------------------------------------------------------------
Then restart of the listener:
# lsnrctl stop EXTERNAL_PROCEDURE_LISTENER
# lsnrctl start EXTERNAL_PROCEDURE_LISTENER
Here is the log of the listener restart:
LSNRCTL for Solaris: Version 8.1.7.4.0 - Production on 17-JUL-2003 09:58:35
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=extproc)) The command completed successfully
LSNRCTL for Solaris: Version 8.1.7.4.0 - Production on 17-JUL-2003 09:58:36
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting /usr/up/oracle/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 8.1.7.4.0 - Production
System parameter file is /usr/up/oracle/network/admin/listener.ora
Log messages written to
/usr/up/oracle/network/log/external_procedure_listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=extproc)) STATUS of the LISTENER
Alias EXTERNAL_PROCEDURE_LISTENER Version TNSLSNR for Solaris: Version 8.1.7.4.0 - Production Start Date 17-JUL-2003 09:58:36 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /usr/up/oracle/network/admin/listener.ora Listener Log File
/usr/up/oracle/network/log/external_procedure_listener.log Services Summary...
extproc has 1 service handler(s) The command completed successfully
So basically all has gone fine. But the installer utlity does not come back and following are the related processes I see running on the system:
root 13027 5959 0 09:58:21 pts/4 0:01 [the installer]
root 13112 13027 0 0:10 <defunct>
-------------------------------------------------------------------------------
Anything I am doing wrong when updating/starting the listener?
Thanks
Fareeda
Received on Thu Jul 17 2003 - 11:27:41 CEST