Troubleshooting

数据库在运行一段时间后crash,遭遇ORA-00600: internal error code, arguments: [SKGMFAIL], [2], [4], [4], [1]，重启后又可以正常运行。

ORA-02049是一个分布式事务等待超时的异常，当一个session 持有一个行级锁，另一个分布式事务比如通过dblink也想修改相同行的数据，就会产生 tx队列等待，当等待时间超过了系统参数distributed_lock_timeout的值时，就产生了这个错误，任何通过通过DBLINK的操作都是分布式事物。

vi 打开，增加-Djava.net.preferIPv4Stack=true，后如下

$self->logAndExec(“$self->{‘OH’}/jdk/bin/java -Xmx512M -DemLocOverride=$self->
{‘OH’} -Djava.net.preferIPv4Stack=true

今天网友问到在安装crs时,OUI出现了这个错误
“The specified shared raw partition /dev/raw/raw1 may not have correct permission”

Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [FAILED]
log:modprobe: FATAL: Module oracleasm not found.

[oracle@dev-db backup]$ exp icme3/icme3 file=icme3_20120409.dmp
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully

when compile package body,
ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []

oracle 不允许truncate 一个启用外键引用的父表，因为truncate 不会触发任何trigger和任何constraint验证，当然它也不会关心子表是不是真的为空或是不是没有参照。

sql>ALTER DATABASE OPEN;
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

这两天一个库因操作了基表的dictionary出错，测试一下正常的drop tablespace做了哪些操作

—- Error Stack Dump —–
ORA-00600: 内部错误代码, 参数: [kghrcdepth:ds], [0x7FFE37407008], [], [], [], [], [], [], [], [], [], []
—– SQL Statement (None) —–
Current SQL information unavailable – no cursor.

ORA-39083: Object type INDEX failed to create with error:
ORA-30032: the suspended (resumable) statement has timed out
ORA-01659: unable to allocate MINEXTENTS beyond 59 in tablespace ICMETBS
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB

今天搞了点数据文本文件，用SQLLDR加载时报：
SQL*Loader-951: Error calling once/load initialization
ORA-00942: 表或视图不存在

SQL> shutdown immediate
ORA-00604: 递归 SQL 层 1 出现错误
ORA-00600: 内部错误代码，参数: [kspgsp1], [101], [642], [1], [optimizer_mode], [], [], []

[oracle@anbob agent10g]$ bin/emctl upload agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
—————————————————————
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..

Oracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.Oracle Management Server is not functioning because of the following reason:Connection to the repository failed. Verify that the repository connection information provided is correct.

一个在windows下解压的oracle10 for linux安装文件，传到rhel 5安装遭遇 database/install/.oui: Permission denied 权限问题

when you try to access a table over the database link,mybe you get this error

The FETCH statement never raises a NO_DATA_FOUND exception as it is anticipated that it will eventually hit this condition ,Because the processing of the BULK COLLECT INTO clause is similar to a FETCH loop

anbob@ORCL> alter table testspace move tablespace anbob;
alter table testspace move tablespace anbob
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace ANBOB