Archive

Archive for the ‘Oracle Bug’ Category

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x4)

March 13, 2014 Leave a comment

On the standby dataguard  10.2.3 db, the  xxxxx_mrp0_xxx.trc showed the messages when executing “alter system archive log crrent”

MRP: Prodding archiver at standby for thread 1 seq 45077
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x4)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x4)
MRP: Prodding archiver at standby for thread 2 seq 31006
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x4)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x4)

According to oracle support, it is a bug.( LGWR unconditionally writes to trace file ). The workaround solution is to set log_archive_max_proesses to high count. ( I set it to 10). The warning disappeared after the change.

Categories: Oracle Bug

ORA-39083: Object type OBJECT_GRANT failed to create with error:

June 14, 2011 Leave a comment

I imported a schema from Oracle 11.2.0.1 database to Oracle 11.1.0.7 database.  I got the following errors

ERRORS

Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-00990: missing or invalid privilege
Failing sql is:
GRANT  ON “UNI_EDS3″.”PON_SEQID” TO “UNI_MLVPNX”

ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-00990: missing or invalid privilege
Failing sql is:
GRANT  ON “UNI_EDS3″.”PON_SEQID” TO “UNI_PON”

ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-00990: missing or invalid privilege
Failing sql is:
GRANT  ON “UNI_EDS3″.”COM_EXCH_MT_KEY” TO “UNI_MLVPNX”

After checking with support oracle, I got that it is bug. The details is referred to the Doc ID 1069105.11.  The solutions is applied the Patch 8856467. After patching the Oracle 11.2.0.1. it works

 

 

Categories: Oracle Bug