修改linux主機名稱後,oracle無法啟動

來源:互聯網
上載者:User

1.啟動資料庫報錯。

[oracle@servers ~]$ rlwrap sqlplus / as sysdba


SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 10月 6 17:14:35 2013


Copyright (c) 1982, 2005, Oracle. All rights reserved.


已串連到空閑常式。


SQL> startup

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

2.重啟監聽報錯。

[oracle@servers ~]$ lsnrctl start


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-10月-2013 17:13:33


Copyright (c) 1991, 2005, Oracle. All rights reserved.


啟動/u01/oracle/10g/bin/tnslsnr: 請稍候...


TNSLSNR for Linux: Version 10.2.0.1.0 - Production

系統參數檔案為/u01/oracle/10g/network/admin/listener.ora

寫入/u01/oracle/10g/network/log/listener.log的日誌資訊

監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

監聽該對象時出錯: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=servers)(PORT=1521)))

TNS-12545: 因目標主機或對象不存在, 串連失敗

TNS-12560: TNS: 協議適配器錯誤

TNS-00515: 因目標主機或對象不存在, 串連失敗

Linux Error: 11: Resource temporarily unavailable


監聽程式未能啟動。請參閱上面的錯誤訊息...


3.解決方案——修改相應檔案

/etc/hosts *修改成新的主機名稱

tnsnames.ora *修改成新的主機名稱

listener.ora *修改成新的主機名稱

本文出自 “大鏏” 部落格,請務必保留此出處http://qieshe.blog.51cto.com/2791087/1305279

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.