|
（1）檢查監(jiān)聽日志狀態(tài) C:\Users\Administrator>lsnrctl status ... LISTENER 的 STATUS ------------------------ 別名 LISTENER 版本 TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Produ ction 啟動日期 26-10月-2017 13:03:25 正常運(yùn)行時間 0 天 0 小時 2 分 19 秒 跟蹤級別 off 安全性 ON: Local OS Authentication SNMP OFF 監(jiān)聽程序參數(shù)文件 D:\app\Administrator\product\11.2.0\dbhome_1\network\a dmin\listener.ora 監(jiān)聽程序日志文件 D:\app\Administrator\diag\tnslsnr\WIN-MIRBE4NEBAU\listener\alert\log.xml ... 實例 "orcl", 狀態(tài) READY, 包含此服務(wù)的 1 個處理程序... 服務(wù) "orclXDB" 包含 1 個實例,。 實例 "orcl", 狀態(tài) READY, 包含此服務(wù)的 1 個處理程序... 命令執(zhí)行成功 （2）設(shè)置log_status off LSNRCTL> set log_status off 正在連接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-MIRBE4NEBAU)(PORT=1521) )) TNS-12508: TNS: 監(jiān)聽程序無法解析給定的 COMMAND （3）檢查listener.ora： # listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. INBOUND_CONNECT_TIMEOUT_LISTENER = 0 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-MIRBE4NEBAU)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = D:\app\Administrator Admin_Restrictions_LISTENER = ON ---包含此行 （4）修改listener.ora中的Admin_Restrictions_LISTENER = OFF 然后執(zhí)行l(wèi)snrctl reload，提示設(shè)置成功 LSNRCTL> set log_status off 正在連接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-MIRBE4NEBAU)(PORT=1521) )) TNS-12508: TNS: 監(jiān)聽程序無法解析給定的 COMMAND LSNRCTL> reload 正在連接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-MIRBE4NEBAU)(PORT=1521) )) 命令執(zhí)行成功 LSNRCTL> set log_status off 正在連接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-MIRBE4NEBAU)(PORT=1521) )) LISTENER 參數(shù) "log_status" 設(shè)為 OFF 命令執(zhí)行成功 LSNRCTL> （5）刪除listener.log成功 參考MOS文章： TNS-12508 When Issuing Any SET Command For The Listener (文檔 ID 238312.1) |
|
|
