配置solaris10 oracle10g的监听器密码

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 1.       su – oracle

2.       vi $ORACLE_HOME/network/admin/listener.ora

添加如下内容

LOCAL_OS_AUTHENTICATION_LISTENER=OFF  ---涂绿为监听器的名字

3.       bash-3.00$ lsnrctl     ---输入lsnrctl进入监听器

 

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 20-NOV-2009 10:30:46

 

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

 

Welcome to LSNRCTL, type "help" for information.

 

LSNRCTL> set current_listener LISTENER    --- LISTENER为配置的监听器的名字

Current Listener is LISTENER

LSNRCTL> change_password               ---为监听器配置密码

Old password:                            ---如以前没配置过密码,回车就可

New password:                           ---配置新密码

Reenter new password:                     --重新确认新密码

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))

Password changed for LISTENER

The command completed successfully

LSNRCTL> set password                   ---再次输入以上配置的新密码

Password:

The command completed successfully

LSNRCTL> save_config                    ---保存生效以上配置

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))

Saved LISTENER configuration parameters.

Listener Parameter File   /export/home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora

Old Parameter File   /export/home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.bak

The command completed successfully

LSNRCTL> status                       ----查看配置后监听器状态

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Solaris: Version 10.2.0.1.0 - Production

Start Date                20-NOV-2009 10:30:37

Uptime                    0 days 0 hr. 1 min. 36 sec

Trace Level               off

Security                  ON: Password             ---请注意,此时密码开启

SNMP                      OFF

Listener Parameter File   /export/home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /export/home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=240a)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "source" has 1 instance(s).

  Instance "source", status READY, has 1 handler(s) for this service...

Service "sourceXDB" has 1 instance(s).

  Instance "source", status READY, has 1 handler(s) for this service...

Service "source_XPT" has 1 instance(s).

  Instance "source", status READY, has 1 handler(s) for this service...

The command completed successfully

4.       下次再对监听器进行任何操作

bash-3.00$ lsnrctl

 

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 20-NOV-2009 10:33:58

 

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

 

Welcome to LSNRCTL, type "help" for information.

 

LSNRCTL> status  

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))

TNS-01169: The listener has not recognized the password   ---表明需要输入密码

LSNRCTL> set password                             ---输入密码就可,进行相关操作

Password:

The command completed successfully

请使用浏览器的分享功能分享到微信等