linux 中oracle 的ORA-03113,ORA-24324,ORA-01041錯誤,可能需要改ip

mengzhaoliang發表於2008-03-17
linux 中oracle 的ORA-03113,ORA-24324,ORA-01041錯誤,可能需要改ip

如圖:
[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 17 10:58:43 2008

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

Connected to an idle instance.

SQL> startup
ORA-03113: end-of-file on communication channel
SQL> startup nomount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist


用root使用者改/etc/hosts檔案中的ip地址即可。
[oracle@localhost ~]$ vi /etc/hosts
[oracle@localhost ~]$ su - root
口令:
[root@localhost ~]# vi /etc/hosts
[root@localhost ~]# service network restart
正在關閉介面 eth0:                                        [確定]
關閉環回介面:                                             [確定]
彈出環回介面:                                             [確定]
彈出介面 eth0:                                            [確定]


再重啟:
[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 17 11:02:19 2008

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  268435456 bytes
Fixed Size                  1218868 bytes
Variable Size              88082124 bytes
Database Buffers          171966464 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12778571/viewspace-207446/,如需轉載,請註明出處,否則將追究法律責任。

相關文章