Most of the time in IT Audit, one issue always raise "No password is set for listener" .
Today I will show how to set password for listener.
There are 3 types in lsnrctl status for Security
1) ON: Local OS Authentication
2) ON: Password or Local OS Authentication
3) ON: Password
Will see below steps to configure password on listener.
LSNRCTL>status
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
check Security
LSNRCTL>change_password
LSNRCTL>save_config
in listener.ora you will get following things
#----ADDED BY TNSLSNR 14-OCT-2014 18:33:11---
PASSWORDS_LISTENER = 18463FBDF70465CE
#--------------------------------------------
LSNRCTL>status
Uptime 0 days 0 hr. 1 min. 31 sec
Trace Level off
Security ON: Password or Local OS Authentication
Now Security : password + OS authentication
Oracle 10g, operating system authentication for the listener has been implemented.
The listener checks to make sure you are part of the privileged dba group,
and if so it will grant you access to change the password, save configuration.
Remove OS authentication if required?
shutdown listener
put following in listener.ora
LOCAL_OS_AUTHENTICATION_LISTENER=OFF
LSNRCTL>status
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Password
now listener will work only through passsword
LSNRCTL>status (gives error)
TNS-01169: The listener has not recognized the password.
how to logging through listner
LSNRCTL>set password
LSNRCTL> status ( it will execute )
Today I will show how to set password for listener.
There are 3 types in lsnrctl status for Security
1) ON: Local OS Authentication
2) ON: Password or Local OS Authentication
3) ON: Password
Will see below steps to configure password on listener.
LSNRCTL>status
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
check Security
LSNRCTL>change_password
LSNRCTL>save_config
in listener.ora you will get following things
#----ADDED BY TNSLSNR 14-OCT-2014 18:33:11---
PASSWORDS_LISTENER = 18463FBDF70465CE
#--------------------------------------------
LSNRCTL>status
Uptime 0 days 0 hr. 1 min. 31 sec
Trace Level off
Security ON: Password or Local OS Authentication
Now Security : password + OS authentication
Oracle 10g, operating system authentication for the listener has been implemented.
The listener checks to make sure you are part of the privileged dba group,
and if so it will grant you access to change the password, save configuration.
Remove OS authentication if required?
shutdown listener
put following in listener.ora
LOCAL_OS_AUTHENTICATION_LISTENER=OFF
LSNRCTL>status
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Password
now listener will work only through passsword
LSNRCTL>status (gives error)
TNS-01169: The listener has not recognized the password.
how to logging through listner
LSNRCTL>set password
LSNRCTL> status ( it will execute )
No comments:
Post a Comment