ORA-00600: internal error code, arguments: [keltnf
Fri Nov 26 10:16:49 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29374.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:50 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29376.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:51 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29378.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:51 2010
Errors in file /db/oracle10g/admin/test/bdump/test_j000_29380.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/bdump/test_j000_29380.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29383.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Process J000 died, see its trace file
Fri Nov 26 10:16:52 2010
kkjcre1p: unable to spawn jobq slave process
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/bdump/test_cjq0_31140.trc:
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/bdump/test_j000_29385.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29387.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/bdump/test_j000_29385.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Process J000 died, see its trace file
Fri Nov 26 10:16:53 2010
kkjcre1p: unable to spawn jobq slave process
Fri Nov 26 10:16:53 2010
Errors in file /db/oracle10g/admin/test/bdump/test_cjq0_31140.trc:
oracle日志中有很多这样的错误。一看是ORA-00600,以为是出现坏块了。吓了一跳!
原因:修改过主机名,但是/etc/hosts没有做响应修改。
catalog备份数据库
Fri Nov 26 10:16:49 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29374.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:50 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29376.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:51 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29378.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:51 2010
Errors in file /db/oracle10g/admin/test/bdump/test_j000_29380.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/bdump/test_j000_29380.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29383.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Process J000 died, see its trace file
Fri Nov 26 10:16:52 2010
kkjcre1p: unable to spawn jobq slave process
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/bdump/test_cjq0_31140.trc:
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/bdump/test_j000_29385.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/udump/test_ora_29387.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Fri Nov 26 10:16:52 2010
Errors in file /db/oracle10g/admin/test/bdump/test_j000_29385.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Process J000 died, see its trace file
Fri Nov 26 10:16:53 2010
kkjcre1p: unable to spawn jobq slave process
Fri Nov 26 10:16:53 2010
Errors in file /db/oracle10g/admin/test/bdump/test_cjq0_31140.trc:
oracle日志中有很多这样的错误。一看是ORA-00600,以为是出现坏块了。吓了一跳!
原因:修改过主机名,但是/etc/hosts没有做响应修改。
解决:将/etc/hosts的主机名修改成和/etc/sysconfig/network里的主机名一样就可以。注意,监听里的主机名也要一样。
ORA-16038的解决
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
ORA-31613 Master process DM00 failed during startup
ORA-24324 ORA-01041 ORA-03113
ORA-27125: unable to create shared memory segment
ORA-00245: control file backup operation failed
ORA-00245: control file backup operation failed
更多参考:
the specified nodes are not clusterable
根据rowid删除表中重复的行
Agent process exited abnormally during initialization
一次字符乱码的解决过程
rman实验(一)
rman实验(二)
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
linux下完全删除oracle
INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory
centos4.8_64上安装oracle10201建库报ORA-12547
EM乱码解决
ORA-31613 Master process DM00 failed during startup
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
ORA-24324 ORA-01041 ORA-03113
centos5.3升级oracle
pdksh-5.2.14-36.el5.i386.rpm
使用rman进行数据库迁移
oracle10.2.0.1升级到10.2.0.4报错
Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)
改oracle的name和dbid
修改oracle实例名
Solaris8上迁移oracle8i---上
Solaris8上迁移oracle8i---下
未备份归档日志导致数据丢失的实验
使用NBU进行数据库迁移
catalog备份数据库
RMAN FORMAT字符串格式化
Error: can not register my instance state - -1
not all alterations performed
The ASM instance configured on the local node is a single-instance ASM
/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared
Initializing the Oracle ASMLib driver: [FAILED]
ORA-00245: control file backup operation failed
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent
模拟恢复参数文件
Interface eth0 checked failed
import server uses ZHS16GBK character set (possible charset conversion)