ORA-00600: internal error code, arguments: [ksvworkmsgalloc: bad reaper] open resetlog fail

Ran into the error above when moving (restoring from a backup) a 12c database (data files, control files, redo logs) from an Oracle Linux 6 server to a new Oracle Linux 8 server and trying to do a 19c upgrade with the following command:

alter database open resetlogs upgrade;

The problem was the path of a redo log group was not correct. The path doesn’t exist on the new Oracle Linux 8 server. We can check redo log group information with the following commands:

select * from v$log;
select * from v$logfile;

Then we can rename redo log file and clear the group.

alter database rename file '/dbase/oradata/redo/redo1.log' to '/dbase/redo/redo1.log';
alter database clear logfile group 1;
alter database clear unarchived logfile group 1;

Redo logs will be created at the correct place with the commands above.

Reference:

Open Resetlogs Fail with ORA-00600[ksvworkmsgalloc: bad reaper] (Doc ID 2728106.1)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s