Step by Step - How to turn on Password Protection for Oracle Database Listener Control (LSNRCTL) Command Line Utility



Step 1:- open administrator cmd
Step 2:- C:\lsnrctl
Step 3:- lsnrctl> change_password
Step 4:- lsnrctl> old password : (keep this blank)
Step 5:- lsnrctl> new password : (set your password here)
Step 6:- lsnrctl> retype new password : (retype your password here)
Step 7:- lsnrctl> save_config 


Step 8:- lsnrctl> exit

Step 9:- Open listener.ora file from ORACLE_HOME\NETWORK\ADMIN\
Step 10:- Add this line - LOCAL_OS_AUTHENTICATION_LISTENER = OFF


step 11:- lsnrctl> stop
step 12:- lsnrctl> start <-- this is required to reload the listener.ora file
step 13:- lsnrctl> exit


Step 14:- from administrator cmd open lsnrctl
Step 15:- lsnrctl>stop
The above command will give an error like
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=B-3)(PORT=1521)))
TNS-01169: The listener has not recognized the password
Step 16:- LSNRCTL>set password unisoft <--- your password set above.
Step 17:- lsnrctl>stop <--- now the command works.

Comments

  1. How To Password Protect a Folder on Windows 10/8 - No Additional Software Required

    In this video, we will see how to Create Password Locked Folder In Windows 10/8. So we will see How to Lock Folders in Windows 10 without Software.

    People always ask this question How do I password protect my files and folders in Windows? Today's video will finish all their questions and they will learn them completely.

    Apurbo IT Services tips or secrets series may help you.

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Architecture - Explained In Detailed - Administration I

Step by Step - How to resolve redo log file corruption using ALTER DATABASE CLEAR UNARCHIVED LOGFILE command

Oracle Database SQL - Practise - Question - Scott Schema Examples