Monthly Archives: June 2008

How to change listener password?

We can change the password by executing the change_password & save_config commands from LSNRCTL> prompt. Make sure $ORACLE_HOME/network/admin/listener.ora exists. If not, save_config will generate NL-00051 error. $lsnrctl LSNRCTL> status Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ———————— Alias LISTENER Version … Continue reading

Posted in Oracle Connectivity | Tagged | 3 Comments