We had this error after a what it seems a successfull rman active duplication to another server.
error 600 happened during Queue table repartitioning
2023-11-16T14:58:39.860612+00:00
Errors in file /u02/app/oracle/diag/rdbms/testdb/TESTDB/trace/TESTDB_q00c_353424.trc:
ORA-00600: internal error code, arguments: [kzakm_open_file:1], [], [], [], [], [], [], [], [], [], [], []
ORA-17507: I/O request size 512 is not a multiple of logical block size.
2023-11-16T14:58:39.866103+00:00
DB mounts ok, but when we try to open, alert log gets flooded with these errors (and db is not usable).
After scratching my head thinking there was some issue with the disks, (as fdisk -l was listing different values), we noticed wallet was not open! It turns out wallet was not imported correctly, so retried the same:
EXPORT WALLET ON SOURCE:
SQL> administer key management create keystore '/tmp/MIGRATION/TESTDB/tde' identified by "xxxxxxxxxxxx";
keystore altered.
SQL> administer key management merge keystore '+DATA/SOURCEDB/tde'
identified by "xxxxxxxxxxxx"
into existing keystore '/tmp/MIGRATION/TESTDB/tde'
identified by "Qox8wt6tk5=c;a`FG`D~" with backup;
keystore altered.
SQL>
IMPORT KEYS ON TARGET:
SQL> administer key management create keystore identified by "xxxxxxxxxxxx";
keystore altered.
SQL> administer key management merge keystore '/tmp/MIGRATION/TESTDB/tde' identified by "xxxxxxxxxxxx"
into existing keystore '+DATA/TESTDB/tde' identified by "xxxxxxxxxxxx" with backup;
keystore altered.
SQL> administer key management create auto_login keystore
from keystore '+DATA/TESTDB/tde'
identified by "xxxxxxxxxxxx";
keystore altered.
After this, DB opens without issue and errors gone, phew!
Comments