配置solaris10 oracle10g的監聽器密碼
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 設定 Oracle 監聽器密碼(LISTENER)Oracle密碼
- 新增監聽密碼密碼
- 監聽設定密碼密碼
- oracle 監聽器配置Oracle
- 為監聽設定密碼密碼
- 伺服器端監聽器配置伺服器
- ORACLE listener監聽設定密碼Oracle密碼
- 為監聽設定密碼防止遠端關閉監聽密碼
- 2.5.2. 監聽程式(listener)配置——2.5.2.3. 手工編輯監聽器配置檔案
- Oracle10g在Solaris10上的安裝配置(轉)Oracle
- Spring框架(一):配置&注入&監聽器Spring框架
- Oracle 監聽器日誌配置與管理Oracle
- 如何配置多個監聽器不同埠
- ASM有自己的引數、密碼、alert、監聽檔案ASM密碼
- 【spring原始碼】十二、監聽器Spring原始碼
- 監聽配置詳解
- ORACLE10G 監聽僵死問題的解決Oracle
- javaWeb中的監聽器JavaWeb
- passive 的事件監聽器事件
- 同時配置動態監聽與靜態監聽
- Oracle 監聽配置詳解Oracle
- Oracle 動態監聽配置Oracle
- 2 Day DBA-檢視監聽器配置-練習:使用Database Control檢視監聽器資訊Database
- Web中的監聽器【Listener】Web
- Oracle 11g/12c 監聽器白名單的配置Oracle
- SpringBoot事件監聽器原始碼分析Spring Boot事件原始碼
- JS事件監聽器JS事件
- listener監聽監控指令碼指令碼
- ORACLE資料庫安全漏洞之監聽密碼設定Oracle資料庫密碼
- 監聽器和過濾器過濾器
- oracle 監聽配置多個埠Oracle
- Android Service 服務的應用之電話監聽器以及簡訊監聽器Android
- 如何更改oracle監聽器的埠Oracle
- 事件和事件監聽器事件
- 如何移除事件監聽器事件
- 遠端控制監聽器
- 27、監聽器學習
- oracle 監聽器學習Oracle