Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
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.