DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Forgot Password For Listener

  1. #1
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103

    Angry Forgot Password For Listener

    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........

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi
    normally the password is oracle
    i am not shure but is the password documented in sqlnet.ora?
    Orca


    lsnrctl> set password oracle


    Orca

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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 :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  6. #6
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103
    Thanx for your support. I'll try them and if not successful I'll post again.

  7. #7
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103
    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.

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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 :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  9. #9
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103
    Hai Julian.
    I don't find any enrty in the listener.ora file. I mean either encrypted or clear text entry for password.

  10. #10
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width