OraFAQ Forum: Networking and Gateways » resetting password for Listener -inherit

Home » RDBMS Server » Networking and Gateways » resetting password for Listener -inherit (Oracle 8i, 9.0.1.0, Solaris 10)

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

resetting password for Listener -inherit [message #485274]

Tue, 07 December 2010 03:50

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

I just found out that the LISTENER I've creating with a password was with "-inherit" settings. Twice I succeeded in doing this, but it seems that it's not working when I tested it. Thus, I opted to get rid of it's listener.bak file and set the password again. Now I just can't stop it because of this error message: "TNS-01169: The listener has not recognized the password". I've tried every passwords I made, and tried resetting it, but I'm not successful either, it's the same error message.

My last option would be to restart the db Server (since the original listener.ora is already intact), but if you have any ideas to extend to me, it's highly appreciated!

Thank you.

Report message to a moderator

Re: resetting password for Listener -inherit [message #485293 is a reply to message #485274]

Tue, 07 December 2010 05:26

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Next time, please post what you have done instead of explaining it.
The proper way to do it in lsnrctl prompt is,

set current_listener thisListener
set password newPassword
stop

Report message to a moderator

Re: resetting password for Listener -inherit [message #485398 is a reply to message #485293]

Tue, 07 December 2010 20:51

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

I did what you said, but still it's not working...

LSNRCTL for Solaris: Version 9.0.1.0.0 - Production on 08-DEC-2010 10:26:56

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> set current_listener listener
Current Listener is listener
LSNRCTL> set password dbu$er_1
The command completed successfully
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-01169: The listener has not recognized the password
LSNRCTL>

Report message to a moderator

Re: resetting password for Listener -inherit [message #485400 is a reply to message #485398]

Tue, 07 December 2010 20:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

01169, 00000, "The listener has not recognized the password"
// *Cause: The listener has the password security mechanism enabled and
// requires the correct password to execute any command other than VERSION.
// The user attempted to issue one of the privileged administrative commands,
// but could not be successfully authenticated with the password provided.
// *Action: If an authorized user is attempting the command, then use the
// SET PASSWORD command at the LSNRCTL prompt with the listener password.
// If you do not know the password, then you are trying to execute
// an inappropriate command.

FWIW - in 10+ years I never set the listener password;
since I was the only person who could log onto the DB Server.

[Updated on: Tue, 07 December 2010 20:59]

Report message to a moderator

Re: resetting password for Listener -inherit [message #485403 is a reply to message #485400]

Tue, 07 December 2010 21:32

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Good for you, but this is in compliance after our IT Security Group completed the VA (vulnerability assessement) of all our servers.

Thanks for sharing the info.

Report message to a moderator

Re: resetting password for Listener -inherit [message #485459 is a reply to message #485403]

Wed, 08 December 2010 05:16

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try this and when prompted, act accordingly.

set current_listener yourListener
change_password
set password
save config
stop

Report message to a moderator

Re: resetting password for Listener -inherit [message #485569 is a reply to message #485459]

Wed, 08 December 2010 18:35

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

$ pwd
/u01/app/oracle/product/9.0.1/db_1/network/admin
$ lsnrctl

LSNRCTL for Solaris: Version 9.0.1.0.0 - Production on 09-DEC-2010 08:09:10

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> set current_listener listener
Current Listener is listener
LSNRCTL> change_password
Old password:
New password:
Reenter new password:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-01169: The listener has not recognized the password
LSNRCTL>

The main issue here is that I forgot the current password I used.

Thanks for your time.

Report message to a moderator

Re: resetting password for Listener -inherit [message #485572 is a reply to message #485569]

Wed, 08 December 2010 19:13

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Metalink note 92604.1 seems to talk about this situation (forgotten password).
See if it helps. Else I am really out of idea.
Either something is really wrong or we are missing something very basic.

Report message to a moderator

Previous Topic:	inbound_connection_timeout
Next Topic:	ORA-12154 TNS: could not resolve service name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 21:21:39 CST 2024