:

RSSORA 600

ORA-00600: internal error code, arguments: opirfs.1

The Problem I came in this morning to find some issues on our Oracle Data Guard configured physical standby databases; we had an error: ORA-00600: internal error code, arguments: [opirfs.1], [],  [], [], [], [], [], []~ The archived redo logs continued to be applied and there were no noticeable issues after this error but I was […]

Continue Reading

ORA-00600: internal error code, arguments: [kzaxins:sqtxt]

We had a scheduled job which ran each day to delete the archive logs which we no longer required. We noticed that the same job errored intermittently with the following error message: ORA-00600: internal error code, arguments: [kzaxins:sqtxt], [], [], [], [], [], [], [] I don’t think it is specific to the command we […]

Continue Reading

ORA-00600: internal error code, arguments: ktsladdfcb-bsz

The Problem I was playing around with the securefile feature in Oracle 11g, which is used with LOB segments. I was trying to create a tablespace with the smallest extent size possible because I wanted to see the affect of using compression quickly and I thought the easiest way was to create a small extent […]

Continue Reading

ORA-00600: internal error code, arguments: [ksu_register_tac-1]

The Problem When running an alter table command to add a constraint in parallel, the error below was received: ALTER TABLE policy ADD CONSTRAINT p_risk_key_fk FOREIGN KEY (product_risk_key) REFERENCES product_details(product_details_key); ORA-00600: internal error code, arguments: [ksu_register_tac-1], [], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [skgmrf_release+2236] [PC:0x5631150] [ADDR:0x3ED0] [UNABLE_TO_WRITE] [] The […]

Continue Reading

ORA-00600 Internal Error Code, arguments [3020], [9]

The Problem We are running Windows Server 2003, Sp2 on both the primary  and standby DB servers, using Oracle 11.2.0.2. We are using a data guard  physical standby DB, also. We have a large tablespace due to a migration that we had completed as a one-off to load the data into the new database. I attempted […]

Continue Reading

ORA-00600 Internal Error Code Arguments: kcratr_scan_lastbwr

The Problem I had refreshed one of our dev databases but the database we were refreshing it from was still open at the time when the disks were flushed at the SAN level and there must have been transactions still in process. One of the steps is to enable archivelog mode and it failed with […]

Continue Reading

ORA-00600 internal error code, arguments: [1403]

I’m running an Oracle database version 9.2.0.8 and we have Data Guard configured which replicates our production DB to a physical  standby. Then, when we want to refresh a development database we clone, at the SAN level, from the physical standby to one of our DEV environments. That’s what we did and I was re-configuring the database to start […]

Continue Reading

ORA-00600, arguments: [3020]

Platform: Windows Server 2003, SP2 Oracle: 11.0.2.0, patchset 10 The Problem From our PROD DB servers we have two data guard DBs up and running as physical standby DBs; one very nearby and another one across the water in another country. These standby DBs were running along very happily, shipping logs from the primary DB […]

Continue Reading

00600: internal error code, arguments: [rworupo.1]

The Problem I am running Oracle version 10.2.0.4, patchset 3 which is the base release patchset for 10.2.0.4 on Windows. We received an Oracle Ora-00600 error message just the other day which is always cause for concern. The error message we received was: 00600: internal error code, arguments: [rworupo.1], [10], [7], [], [], [], [], […]

Continue Reading

ORA-00600: [32695], [hash aggregation can’t be done]

The Problem You are running a SQL query and come across the following error message: ORA-00600: internal error code, arguments: [32695], [hash aggregation can’t be done], [], [], [], [], [], [] The Cause You may be hitting Bug 6471770 or Bug 5893340. You can check these out on Metalink for more detail. It does […]

Continue Reading