Oracle Listener - Stop

[Sanjay Kumar Suri]

We have implemented password protection to listener process (Oracle 9i HP-UX 11i).

Now listener can be started with the following command:
$lsnrctl start

But to stop the listener following sequence has to be done:
$lsnrctl
LSNRCTL> set password
Password:
The command completed successfully

LSNRCTL> stop

Question: Is it possible to stop the listner (with password set) through a script instead of giving stop command in LSNRCTL> prompt?

sks

[Jean-Luc Oudart]

What about

echo | lsnrctl <set password
stop
exit
EOP

Regards,
Jean-Luc

[Sanjay Kumar Suri]

Hello Jean

I tried your method:

echo | lsnrctl <set password
passwd
stop
exit
EOP

Oracle is not taking the password in the next line of set password and give the following error:

TNS-01169: The listener has not recognized the password

If the password is used as below:

set password passwd

although there is no error at the line set password passwd, the system gives the following error:

TNS-01169: The listener has not recognized the password

Any more ideas?

sks

[Jean-Luc Oudart · Accepted solution]

This is an encrypted password.

Check the encrypted value in the listener.ora

and change script :
lsnrctl <set password 195645F4F5.. <= encrypted value
stop
exit
EOP

Regards
Jean-Luc

[Sanjay Kumar Suri]

Hello Jean

Thanks a lot. You solution has worked.

Regards.

sks