一.问题描述:
[oracle@fsdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Mon Jul 12 12:47:33 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected.
SQL> alter user sys identified by "xxxxxxxx";
alter user sys identified by "xxxxxxxx"
ERROR at line 1:
ORA-01012: not logged on
SQL> select username,status,count(1) from v$session group by username,status;
select username,status,count(1) from v$session group by username,status
*
ERROR at line 1:
ORA-01012: not logged on
SQL> exit
Disconnected
[oracle@fsdb ~]$ ps -ef|grep ora
root 4087 4059 0 2009 ? 00:13:55 hald-addon-storage: polling /dev/hda
oracle 4608 1 0 2009 ? 00:05:51 ora_pmon_FSDBLINU
oracle 4610 1 0 2009 ? 00:00:13 ora_psp0_FSDBLINU
oracle 4612 1 0 2009 ? 00:00:00 ora_mman_FSDBLINU
oracle 4614 1 0 2009 ? 00:02:18 ora_dbw0_FSDBLINU
oracle 4616 1 0 2009 ? 00:02:48 ora_dbw1_FSDBLINU
oracle 4618 1 0 2009 ? 00:09:13 ora_lgwr_FSDBLINU
oracle 4620 1 0 2009 ? 00:00:41 ora_ckpt_FSDBLINU
oracle 4622 1 0 2009 ? 00:14:04 ora_smon_FSDBLINU
oracle 4624 1 0 2009 ? 00:00:00 ora_reco_FSDBLINU
oracle 4626 1 0 2009 ? 00:05:42 ora_cjq0_FSDBLINU
oracle 4628 1 0 2009 ? 00:19:46 ora_mmon_FSDBLINU
oracle 4630 1 0 2009 ? 00:33:50 ora_mmnl_FSDBLINU
oracle 4632 1 0 2009 ? 00:00:00 ora_d000_FSDBLINU
oracle 4634 1 0 2009 ? 00:00:00 ora_s000_FSDBLINU
oracle 4668 1 0 2009 ? 00:00:29 ora_arc0_FSDBLINU
oracle 4670 1 0 2009 ? 00:00:29 ora_arc1_FSDBLINU
oracle 4672 1 0 2009 ? 00:00:00 ora_qmnc_FSDBLINU
oracle 4687 1 0 2009 ? 00:00:00 ora_q000_FSDBLINU
oracle 4692 1 0 2009 ? 00:00:57 ora_q001_FSDBLINU
oracle 5888 1 0 Jul11 ? 00:00:08 oracleFSDBLINU (LOCAL=NO)
oracle 5903 1 0 Jul11 ? 00:00:00 oracleFSDBLINU (LOCAL=NO)
oracle 5905 1 0 Jul11 ? 00:00:00 oracleFSDBLINU (LOCAL=NO)
oracle 8261 1 0 Jul11 ? 00:00:00 oracleFSDBLINU (LOCAL=NO)
oracle 9434 1 0 00:46 ? 00:00:07 ora_j000_FSDBLINU
oracle 18976 1 0 Jun28 ? 00:00:01 oracleFSDBLINU (LOCAL=NO)
oracle 18980 1 0 Jun28 ? 00:00:00 oracleFSDBLINU (LOCAL=NO)
oracle 18983 1 0 Jun28 ? 00:00:00 oracleFSDBLINU (LOCAL=NO)
oracle 28253 1 0 Jul07 ? 00:00:03 /oracle/product/10.2.0/db/bin/tnslsnr LISTENER -inherit
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
SQL> exit
二.问题分析:
查看alert_$ORACLE_SID.log文件,报:"ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []"的错误
在metalink上查询该ora-600的错误,初步判断是hostname的问题,刚才os的确是修改了hostname,由原来的'linux5'修改为'XXDB'.修改的方式步骤也没有问题,具体步骤如下:
- #hostname XXDB
- #vi /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=XXDB
修改完成hostname后,忘记去修改/etc/hosts中主机的名称与IP地址的对应关系
#more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
…...
110.160.132.218 linux5
…...
三. 问题解决:
将/etc/hosts文件的内容修改为正确的对应关系
#vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
…...
110.160.132.218 XXDB
…...
重新启动数据库后,问题得到解决