1: An error occurred while restarting the database today:
SQL> startup mount
ORA-03113: end-of-file on communication channel
Take a look at alert. log:
...
PMON started with pid = 2, OS id = 7359
PSP0 started with pid = 3, OS id = 7361
MMAN started with pid = 4, OS id = 7363
DBW0 started with pid = 5, OS id = 7365
LGWR started with pid = 6, OS id = 7381
Tue Feb 7 15:25:17 2012
Errors in file/u01/pp/Oracle/admin/ezhou/bdump/ezhou_ckpt_7383.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [], []
Tue Feb 7 15:25:18 2012
Errors in file/u01/pp/oracle/admin/ezhou/bdump/ezhou_ckpt_7383.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [], []
Tue Feb 7 15:25:18 2012
CKPT: terminating instance due to error 469.
Instance terminated by CKPT, pid = 7383
-------------
[Oracle @ aoracle bdump] $ vi/etc/hosts
# Do not remove the following line, or various programs
# That require network functionality will fail.
127.0.0.1 aoracle.domain.com aoracle localhost. localdomain localhost
: 1 localhost6. localdomain6 localhost6
#192.168.158.10 aoracle.domain.com aoracle
192.168.142.128 sheng
[Oracle @ aoracle bdump] $ hostname
Aoracle.domain.com
Cause:
The hostname of the server is not correctly configured. The host name obtained through the hostname command cannot be pinged. Oracle10g considers that the host cannot be reached, so an error is reported when the database is started.
Someone changed the host name yesterday and checked the hosts file on the local machine. It was found that the host name corresponding to the hosts file was not modified when the host name was changed, which caused this error.
Solution:
Add the hostname to the/etc/hosts file and restart the database.
Note:
Change the hostname in/etc/sysconfig/network and/etc/hosts to be the same, and do not comment out 127.0.0.0.1 in/etc/hosts.
If you forget to change the machine corresponding to 127.0.0.1 in/etc/hosts to the same in the network file, the error described above will occur.