Forgot Password For Listener - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Forgot Password For Listener

  1. #11
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Originally posted by julian
    I get your point but I rather administer 9iR2 than 7.3.4 :-)
    YEs more complex but MUTCH MORE interesting
    ORca

  2. #12
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.
    So, you cannot stop the listener, right? Do you get a message something like that the listener has not recognized the password?

    Do you have a backup file of the listener in the same directory. If yes, it is likely that someone has set an encrypted password and has either removed the encrypted lines or has not been able to save_config it due to OS rights. Bugger!

    Just delete the blooody listener and recreate it. Kill -9 the process first.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #13
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103
    LISTENER =

    (DESCRIPTION_LIST =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = IPC) (KEY = EXPROC0))

    (PROTOCOL_STACK =

    (PRESENTATION = TTC)

    (SESSION = NS)

    )

    )

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = sunserver) (PORT = 1521))

    (PROTOCOL_STACK =

    (PRESENTATION = TTC)

    (SESSION = NS)

    )

    )

    )



    SID_LIST_LISTENER =

    (SID_LIST =

    (SID_DESC =

    (SID_NAME = PLSExtProc)

    (ORACLE_HOME = /data1/oracle)

    (PROGRAM = extproc)

    )

    (SID_DESC =

    (GLOBAL_DBNAME = ggin1)

    (ORACLE_HOME = /data1/oracle)

    (SID_NAME = ggin1)

    )

    (SID_DESC =

    (GLOBAL_DBNAME = cm)

    (ORACLE_HOME = /data1/oracle)

    (SID_NAME = cm)

    )

    )


    This is the content in my listener.ora file. The listener that is being used is the default one. It has the name as "LISTENER" itself.
    There is no password encryption or something like that in the file.
    But I'm not able to RELOAD or issue any commands at the listener prompt(lsnrctl>). Please help me. I tried without giving password and it's failing giving the following message.

    LSNRCTL> reload listener
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXPROC0))(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS)))
    TNS-01169: The listener has not recognized the password

    Please help me........

  4. #14
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Do the following:

    1. LSNRCTL

    2. change_password

    For all password type ENTER
    Type 2 times the new password

    3. set password

    give the new password

    4. save_config

    5. stop

    6. exit the LSNRCTL

    7. LSNRCTL

    8. start

    What is the ouput of ps -ef|grep tns ?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  5. #15
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103
    I have done all that you said Julian. But nothing is working. I mean for all the actions or commands I'm doing it just gives the error
    TNS-01169: The listener has not recognized the password. I'm confused.

    One more thing you told me to remove the Listener entry. Does it mean that I should delete the entry for my current listener in th listener.ora file and kill the listener and retype the entry for it in the listener.ora file and start it fresh. OR Delete the listener.ora file completely and create new file?

    If I kill the listener and restart will it restart successfully? OR will it ask for password again for restarting also?

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

    Talking

    Hey I succeeded after a continuous fight. I just killed the listener and restarted the listener. It worked.

    Thanx for you all who supported me.

  7. #17
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by tvrdileep
    Hey I succeeded after a continuous fight. I just killed the listener and restarted the listener. It worked.

    Thanx for you all who supported me.
    Well, you don't need a password to start the listener, even if you have one. Are you now able to stop it?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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