Home » RDBMS Server » Networking and Gateways » resetting password for Listener -inherit (Oracle 8i, 9.0.1.0, Solaris 10)
resetting password for Listener -inherit [message #485274] Tue, 07 December 2010 03:50 Go to next message
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.
Re: resetting password for Listener -inherit [message #485293 is a reply to message #485274] Tue, 07 December 2010 05:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 
Re: resetting password for Listener -inherit [message #485398 is a reply to message #485293] Tue, 07 December 2010 20:51 Go to previous messageGo to next message
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>
Re: resetting password for Listener -inherit [message #485400 is a reply to message #485398] Tue, 07 December 2010 20:58 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.

Re: resetting password for Listener -inherit [message #485459 is a reply to message #485403] Wed, 08 December 2010 05:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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
Re: resetting password for Listener -inherit [message #485569 is a reply to message #485459] Wed, 08 December 2010 18:35 Go to previous messageGo to next message
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.
Re: resetting password for Listener -inherit [message #485572 is a reply to message #485569] Wed, 08 December 2010 19:13 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: inbound_connection_timeout
Next Topic: ORA-12154 TNS: could not resolve service name
Goto Forum:
  


Current Time: Thu Mar 28 11:25:03 CDT 2024