Forgot Password For Listener

[Orca777]

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

[julian]

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.

[tvrdileep]

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

[julian]

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 ?

[tvrdileep]

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?

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

[julian]

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?