cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Listener - Stop

SOLVED
Go to solution
Sanjay Kumar Suri
Honored Contributor

Oracle Listener - Stop

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

A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
4 REPLIES
Jean-Luc Oudart
Honored Contributor

Re: Oracle Listener - Stop

What about

echo | lsnrctl <set password
stop
exit
EOP

Regards,
Jean-Luc
fiat lux
Sanjay Kumar Suri
Honored Contributor

Re: Oracle Listener - Stop

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
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Jean-Luc Oudart
Honored Contributor
Solution

Re: Oracle Listener - Stop

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
fiat lux
Sanjay Kumar Suri
Honored Contributor

Re: Oracle Listener - Stop

Hello Jean

Thanks a lot. You solution has worked.

Regards.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.