oracle 監聽重啟
1 看監聽狀態
Lsnrctl status
oracle@ria8:~> lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-12月-2010 11:43:00
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 22-12月-2010 11:20:46
Uptime 0 days 0 hr. 22 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/10.2/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.31.31)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@ria8:~>
2 ps -ef | grep -v grep |grep tnslsnr | awk '{print $2}
用此命令檢視監聽的PID
3 幹掉程式 kill -9 pid
4 清空日誌:
Cd /opt/oracle/product/10.2/db_1/network/log/
Echo “ “ > listener.log
5 重啟監聽:oracle使用者
Lsnrctl start
或者oracle 絕對路徑:/opt/oracle/product/10.2/db_1/bin(即ORACLE_HOME/bin)
看警告日誌在ORACLE_BASE/admin/SID/bdump來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23141985/viewspace-710029/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Sqlserver重啟alwayson監聽埠SQLServer
- Oracle啟動兩個監聽Oracle
- oracle監聽開啟trace fileOracle
- Oracle監聽日誌2g-監聽啟動報錯Oracle
- 配置作業系統重啟後,Oracle資料庫和監聽自動啟動作業系統Oracle資料庫
- Oracle監聽服務無法啟動Oracle
- Oracle 監聽Oracle
- hyperf 啟動、重啟、停止、檔案變化監聽命令包
- 自動重新啟動oracle監聽程式 for windowsOracleWindows
- Oracle監聽啟動後自動關閉Oracle
- Oracle監聽(1)Oracle
- ORACLE動態監聽與靜態監聽Oracle
- oracle靜態監聽和動態監聽Oracle
- 【oracle】動態監聽與靜態監聽Oracle
- 【Oracle】修改oracle監聽埠Oracle
- oracle 10g rac當監聽程式監聽對方vip時啟動監聽報錯TNS-12545Oracle 10g
- oracle靜態監聽Oracle
- JMS監聽Oracle AQOracle
- oracle 監聽器配置Oracle
- Oracle監聽的作用Oracle
- ORACLE監聽簡介Oracle
- oracle資料庫監聽啟動不了的原因分析Oracle資料庫
- 【listener】oracle靜態監聽和動態監聽 【轉載】Oracle
- oracle清理監聽日誌Oracle
- Oracle資料庫監聽Oracle資料庫
- oracle 多庫配監聽Oracle
- oracle的監聽問題Oracle
- Oracle 監聽配置詳解Oracle
- Oracle 動態監聽配置Oracle
- oracle 監聽器學習Oracle
- 6、oracle網路(監聽)Oracle
- 2.5.4. 測試Oracle net——2.5.4.1. 啟動監聽程式Oracle
- 如何讓oracle DB、監聽和oem開機啟動(dbstart)Oracle
- 啟動資料庫監聽資料庫
- 資料庫開啟監聽資料庫
- ORACLE啟動監聽器 The listener supports no services 問題解決方法Oracle
- oracle listener 監聽啟動不起來處理案例一則Oracle
- [重慶思莊每日技術分享]-ORACLE 19C資料庫啟動後,無監聽服務Oracle資料庫