今天處理一個問題,listener無法啟動,一直報錯
- [grid@grida ~]$ lsnrctl status SCAN_LISTENER1
- LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-MAY-2012 09:14:24
- Copyright (c) 1991, 2009, Oracle. All rights reserved.
- TNS-01101: Message 1101 not found; No message file for product=network, facility=TNS [SCAN_LISTENER1]
- [grid@grida ~]$ lsnrctl status
- LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-MAY-2012 09:14:32
- Copyright (c) 1991, 2009, Oracle. All rights reserved.
- Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS
- TNS-12560: Message 12560 not found; No message file for product=network
, facility=TNS - TNS-00511: Message 511 not found; No message file for product=network, facility=TNS
- Linux Error: 111: Connection refused
查詢文檔,搜索TNS-12560,TNS-00511沒有任何實際意義,最后查詢No message file for product=network, facility=TNS ,
發現一些案例,基本問題集中在$ORACLE_HOME許可權不對和路徑錯誤,
最后與客戶確認,客戶有更改過$ORACLE_HOME,告知其還原該路徑的改動,還原后,問題解決.
本文出自 「小小狗窩」 博客,謝絕轉載!
[火星人 ] $ORACLE_HOME路徑更改導致的listener啟動失敗已經有868次圍觀