Forgot Password For Listener

[tvrdileep]

COLOR=darkblue]FORGOT PASSWORD FOR LISTENER [/COLOR]

Hai Buddies. I have a strange problem. I FORGOT the PASSWORD for the LISTENER that I set. So, I'm not able to control the LISTENER. I mean STOP it. The O/S is Solaris 6.0. The Oracle version is 8i. If I kill the listener process and restart it can I change the password successfully or what to do? Please Help me........

[Orca777]

Hi
normally the password is oracle
i am not shure but is the password documented in sqlnet.ora?
Orca


lsnrctl> set password oracle


Orca

[julian]

Originally posted by Orca777
Hi
normally the password is oracle
i am not shure but is the password documented in sqlnet.ora?
Orca


lsnrctl> set password oracle


Orca

Rubish :-) There is no more default password for the listener. Do you still live in Oracle 7's world?

Now, first are you using encryped password for the listener or not?

I use encrypted and I also forgot it once, then you must delete the listener and recreate it. That's how I did it. You can never stop it otherwise.

You of course can kill -9 the process and start it but you cannot stop it without the password.

That is why some other admin should know the listener's password or set it to be the same as the SYSTEM's password.

[Orca777]

Originally posted by julian
Rubish :-) There is no more default password for the listener. Do you still live in Oracle 7's world?

.

Oh, in the Version 7 the world was much easier!
Orca

[julian]

Originally posted by Orca777
Oh, in the Version 7 the world was much easier!
Orca

I get your point but I rather administer 9iR2 than 7.3.4 :-)

[tvrdileep]

Thanx for your support. I'll try them and if not successful I'll post again.

[tvrdileep]

Hai All.

How do I know that or How can I that whether my password is encrypted or not?

If all the possibilities fail and I have to re-install listener software, How to do it? Please help me. The O/S is solaris 6.o and the Oracle version is 8.1.6.0.0.

[julian]

Originally posted by tvrdileep
Hai All.

How do I know that or How can I that whether my password is encrypted or not?

If all the possibilities fail and I have to re-install listener software, How to do it? Please help me. The O/S is solaris 6.o and the Oracle version is 8.1.6.0.0.

Here is how:

Open the listener.ora file:

If you have the encrypted line something like:

#----ADDED BY TNSLSNR 12-FEB-2003 11:51:19---
PASSWORDS_lsngamma = 71B05DCA178C645C
#--------------------------------------------

then it is encrypted.

If it is cleatext password the entry is PASSWORDS_your_listener_name.

Clear :-)

[tvrdileep]

Hai Julian.
I don't find any enrty in the listener.ora file. I mean either encrypted or clear text entry for password.

[ggnanaraj]

Originally posted by tvrdileep
Hai Julian.
I don't find any enrty in the listener.ora file. I mean either encrypted or clear text entry for password.

Then I suppose, there is no password for the listener. Just give the listener name as you find it in listener.ora to start/stop/administer the listener.


eg., if the entry is as follows in listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sipw001)(PORT = 1524))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = sipw001)(PORT = 2481))
)
)

Listener name is bold in the quote.

HTH.