implement listener password on Oracle 9i



How to implement listener password on Oracle 9i

I have tried to manually add this line (PASSWORDS_LISTENER = (password)) in listener.ora on 9i, but when I tried to stop the listener, I got this error:

$ lsnrctl stop

LSNRCTL for Solaris: Version 9.2.0.3.0 - Production on 23-DEC-2003 19:27:50

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=207.240.8.12)(PORT=1521)))

TNS-01169: The listener has not recognized the password

So I tried the other way to set the password in listener.

1. sudo to oracle and issue lsnrctl at the $ prompt

$ lsnrctl

LSNRCTL for Solaris: Version 9.2.0.3.0 - Production on 23-DEC-2003 15:55:25

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

2. At LSNRCTL prompt, issue change_password (enter listener name if multiple listeners on the server)

LSNRCTL> change_password

Old password: (null if no previous password set)

New password: (new password)

Reenter new password: (new password)

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=207.240.8.15)(PORT=1521)))

Password changed for LISTENER

The command completed successfully

3. Set password

LSNRCTL> set password

Password:

The command completed successfully

  1. save the password

LSNRCTL> save_config

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=207.240.8.15)(PORT=1521)))

Saved LISTENER configuration parameters.

Listener Parameter File /home/oracle/product/9.2.0/network/admin/listener.ora

Old Parameter File /home/oracle/product/9.2.0/network/admin/listener.bak

The command completed successfully

LSNRCTL>

  1. record the password in ironclad since the password in listener.ora is encrypted.

$ more listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

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

(ADDRESS = (PROTOCOL = IPC)(HOST = 207.240.8.15)(KEY = REMIPC))

)

)

)

#----ADDED BY TNSLSNR 23-DEC-2003 15:57:07---

LOG_FILE_LISTENER = listener.log

PASSWORDS_LISTENER = 62E1E23777F5FCB4

#--------------------------------------------

$

If you want to stop the listener, you can do the following:

$ lsnrctl

LSNRCTL for Solaris: Version 9.2.0.3.0 - Production on 23-DEC-2003 15:55:25

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information

LSNRCTL> set password

Password:

The command completed successfully

LSNRCTL> stop

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=207.240.8.12)(PORT=1521)))

The command completed successfully

LSNRCTL> exit

$ ps -ef |grep tns

oracle 13444 13415 0 19:29:18 console 0:00 grep tns

0 Response to "implement listener password on Oracle 9i"

Post a Comment

Powered by Blogger