Re: LSNRCTL and SPAWN

From: Daniel <danielroy10junk_at_hotmail.com>
Date: 15 Jan 2006 09:39:04 -0800
Message-ID: <1137346744.096184.316810@g47g2000cwa.googlegroups.com>

You could at least provide your version. I'll assume you're on 9.2. I've never spawned a program from lsnrctl, but according to the 9i Net Services Reference Guide (Chapter 1), an example is

LSNRCTL> SPAWN nstest_alias (ARGUMENTS='')

Your program alias name has to be defined in your listener.ora (look up PROGRAM in chapter 8 of the same manual). An example they give is

SID_LIST_listener_name=
(SID_LIST=
(SID_DESC=
(SID_NAME=extproc)
(ORACLE_HOME=/usr/oracle)
(PROGRAM=extproc)))

I think that with these Oracle-provided "examples" (even though I agree they're not very down-to-earth), that should be enough for you to spawn your program from lsnrctl.

HTH Daniel Received on Sun Jan 15 2006 - 11:39:04 CST