Wednesday, May 20, 2009

Listener

How to Check If the Password is Set to Listener:

From the listener control prompt, issue the command STATUS. If the Security setting is shown as ON, then the password is set for the listener.


LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ANANDA)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
Start Date 05-JUL-2003 15:23:19
Uptime 0 days 6 hr. 24 min. 56 sec
Trace Level off
Security ON
SNMP OFF
Listener Parameter File d:\ora9\network\admin\listener.ora
Listener Log File d:\ora9\network\log\listener.log
Services Summary...
ANANDA has 1 service handler(s)
ANANDA has 2 service handler(s)
ANANDA has 2 service handler(s)
The command completed successfully
LSNRCTL>

Once password is set any administrative command apart from START, STATUS and HELP require password. It's the least security. Password is set by command change_password

LSNRCTL>change_password

Set password for administrative task

LSNRCTL> set password 607CB

No comments:

Post a Comment