Extproc listener restart causes calling program to sleep/hang

From: fareeda <fareeda_at_pspl.co.in>
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

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

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

This message: [ Message body ]
Next message: Maximus: "Re: Returning record X-Y from a table"
Previous message: Praveen: "Re: How to make database to work with other languages!!!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message