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
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
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
- 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>
- 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
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
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
0 Response to "implement listener password on Oracle 9i"
Post a Comment