Today, the rac database query database encountered the ORA-00600 kcbz_check_objd_typ_3 error, and the disk queue process is very high, the system pressure is very highAfter the alter system flush buffer_cache statement is executed, the error disappears;
After a data recovery, encountered the ORA-00600 kcbz_check_objd_t
The ORA-00600 kcratr_nab_less_than_odr Solution
Today, due to abnormal power outages at the customer site, Oracle database cannot be started again. Let's go up remotely.
1. The database can only be mounted and cannot be started.
SQL> select status from v $ instance;STATUS------------MOUNTEDSQL> ALTER DATABASE OPEN;ALTER DATABASE OPEN*ERROR at line 1:The ORA-01589
Fixed after ORA-00600 [ktspNextL1: 4] _ bug5649098_11.1.0.7
Fixed after ORA-00600 [ktspNextL1: 4] _ bug5649098_11.1.0.7
I checked alert log and found the following error: View alert log:
Fri Aug 2 07:13:33 2013
Errors in file/u01/Oracle/admin/eptdb/bdump/eptdb1_j002_961_4.trc:ORA-
-01110
Use alter database open resetlogs;
Report:
SQL> alterdatabaseopenresetlogs;
Alterdatabaseopenresetlogs
*
ERRORatline 1:
ORA-01194: file 1 needs more recoverytobe consistent
ORA-01110:
By setting hidden Parameters
_ Allow_resetlogs_upload uption = TRUE
Open the database.
The database starts reporting ORA-00600
errors such as the following:Mon Mar 31 18:45:59 2014Errors in File/oracle/app/oracle/diag/rdbms/zscims/zscims2/trace/zscims2_ora_11403518.trc (incident=28382):ORA-00600: Internal error code, number of references: [Kqlnrc_1], [0x7000003f55c3b60], [], [], [], [], [], [], [], [], [], []Incident details in:/oracle/app/oracle/diag/rdbms/zscims/zscims2/incident/incdir_28382/zscims2_ora_11403518_ I28382.trcUse Ad
Database inspection this morning, found the alert Log in the following error: Warning: ORA-00600: Internal error code, parameters: [kqlnrc_1], [0x15E465678], [], [], [], [], [], [] MonJun1810: 11: 31CST2012Er
This morning, I performed database inspection and found the following error in the alert Log: Errors in file/home/Oracle/admin/exmxsbusi/udump/exmxsbusi2_ora_27477.trc:
Database ORA-00600 of a provincial telecommunications industry company [15160]
Systems: HP-UX B .11.31
RAC: YES
Database Version: 10.2.0.4
1. Background
: 39dbrac database Node 2, found a lot of ORA-600 errors in the alert Log, the analysis is the table test_wait statistical information error caused, re-analyze the statistical information of the table, eliminate
When I arrived at the company, I received a friend's message saying that one node of RAC had crashed. Because he re-built an index at last night and ran for more than two hours before it was over, then he manually canceled it. At, one of the nodes encountered a problem.
The DB environment is: AIX 6.1 + Oracle 10.2.0.4, 2 nodes. Now a node is under great pressure. If you try to start a failed node, it can be started normally. Once you perform the DML operation, the node will be suspended.
Alert l
Sometimes a problem with an ora-00600:internal error code inside an Oracle database using MyEclipse! This is mainly due to Oracle's own bug problem! In particular, the 9.2.0.1 version may encounter this problem frequently. This problem can be resolved by the following methods: ora-00600:internal error code internal err
This error frequently occurs in Oracle data after an illegal shutdown:
Exp-00056:oracle Error 1033 appears
Ora-01033:oracle initialization or shutdown in progress
User:
Password:
This is obviously the database does not have the means to start, but the database service can be started, but the program cannot connect to the database.
The first choice to find the problem to see the database bdump directory alert file specific report what the error
ORA-00600 [kcratr_nab_less_than_odr]
[Note] recently, the entire IT system was a bit lucky. First, there was a power outage in the data center. Recently, another accident occurred. The hard disk of a virtual machine broke down, resulting in the failure of all applications and databases installed on the virtual machine. After some hard work, the virtual machine finally got up, but an error was reported durin
In the day-to-day maintenance of Oracle databases, we may often encounter some errors that we have never seen before, even inexplicable errors. Many times, even through Metalink, Baidu, even Google can not search the relevant content. This is not, yesterday the company southern colleagues to help restore a customer database; it is said to be an archive database, there is no backup, restart the instance after the database can not open.I also heard this thing for the first time, looked at the Orac
label: style HTTP color Io OS ar strong data sp
接上一个,REDO报错搞定后OPEN数据库时又报错ORA-00600: internal error code, arguments: [2662]。
原因是_ALLOW_RESETLOGS_CORRUPTION后resetlogs打开数据库,我们可能会因为SCN不一致而遭遇到ORA-00600 2662号错误( current scn 小于undo block scn)。
现象及解决--这个没拍照參考EYGLE的样例吧
Sun Dec 11 18:02:25 2005Errors in file /opt/oracle/admin/c
The article summarizes the ORA-00600 kclchkblk_4 error recovery methods, there is a need to learn friends can refer.
Recently the customer encountered a ORA-600 kclchkblk_4 error while restoring the database, which has official explanations and solutions on MOS.
The following error message is displayed:
The Code is as follows:
Copy code
Er
This error often occurs in an Oracle database after an illegal shutdown:
Exp-00056:oracle Error 1033 appears
ora-01033:oracle initialization or shutdown in progress
User:
Password:
This is obviously the database does not have the means to start, but the database service can be started, and the program cannot connect to the database.
The first choice to find the problem to see the database bdump directory alert file specific report what
Oracle version: 10.2.0.2 and has been deployed with mongouard. Recently, the log of oraclealert in the master database found that ora600 errors are generated almost every day in the last half month.
Oracle version: 10.2.0.2 with data guard. Recently, the oracle alert Log in the master database found that the ora 600 error is generated almost every day in the last half month.
Oracle version: 10.2.0.2 with data guardOperating System: linux rhat 5.6
The following are the most recent errors encountered in user data recovery:
2012-03-08 13:56:04.178
Ksedmp:internal or fatal error
Ora-00600:internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []
-----Pl/sql Call Stack-----
Object Line Object
Handle Number Name
57CCE5A18 418 Package The body SYS. Dbms_ha_alerts_prvt
57CCE5A18 552 Package The body SYS. Dbms_ha_alerts_prvt
Symptom:An error is reported in the alert Log when the Oracle database is started:SUCCESS: diskgroup DATADG was mountedErrors in file/oracle/app/11gR1/diag/rdbms/rac/rac2/trace/rac2_mmon_1_6.trc (incident = 240612 ):ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [17510], [], [], [], [], [], [], [], [], [], [], []ORA-17510: Attempt t
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.