OraFAQ Forum: Networking and Gateways » listener and password

Home » RDBMS Server » Networking and Gateways » listener and password

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

listener and password [message #237005]

Fri, 11 May 2007 10:24

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

Report message to a moderator

Re: listener and password [message #237070 is a reply to message #237005]

Fri, 11 May 2007 15:22

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

Report message to a moderator

Re: listener and password [message #237475 is a reply to message #237070]

Mon, 14 May 2007 10:53

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi,
The security status is ON

Report message to a moderator

Previous Topic:	how to use database link on the remote database?
Next Topic:	Connection Error ORA 12154

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 14:44:19 CST 2024