配置solaris10 oracle10g的監聽器密碼

wisdomone1發表於2009-11-20
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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-620124/,如需轉載,請註明出處,否則將追究法律責任。

相關文章