Home » RDBMS Server » Networking and Gateways » listener and password
listener and password [message #237005] Fri, 11 May 2007 10:24 Go to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi All,
I have protected the listener by adding password. Following are the steps:

LSNRCTL>SET SAVE_CONFIG_ON_STOP ON
LSNRCTL> CHANGE_PASSWORD
OLD PASSWORD:
NEW PASSWORD: newPassword
Reenter the new password: newPassword

LSNRCTL>SET PASSWORD
Password: newPassword

LSNRCTL>STOP


The Listener stops successfully. I again start the listener and come out of the LSNRCTL prompt.

After this when I try to stop the listener from the UNIX prompt, it allows without asking for password and the listener stops.
$LSNRCTL STOP myInstance

Can anyone explain why this behaviour? I expect this statement to fail because I am not entering any password.

Thanks in advance
qA



Re: listener and password [message #237070 is a reply to message #237005] Fri, 11 May 2007 15:22 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Have you check the staus of your listner? If the Security setting is shown as ON, then the password is set for the listener. Else you have to reset the password
Re: listener and password [message #237475 is a reply to message #237070] Mon, 14 May 2007 10:53 Go to previous message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi,
The security status is ON
Previous Topic: how to use database link on the remote database?
Next Topic: Connection Error ORA 12154
Goto Forum:
  


Current Time: Fri Apr 26 19:45:21 CDT 2024