Thursday, March 19, 2015

Oracle Change Data Capture (CDC) Apply encountered ORA-54013

This issue is raised on 11g when a function based index is created on the CDC's schema change set's change table.

Then a transaction against this table (Insert, update, delete) will not apply the change and will fail with ORA-54013: INSERT operation disallowed on virtual columns
recorder on the DBA_APPLY_ERROR table.

Work around is to drop the function based index from the change table, restart capture and apply process and then re-execute the failed transactions errors.

As sys execute : dbms_apply_adm.execute_all_errors;

REFERENCES: Oracle Support Doc ID 1555572.1

Thursday, March 5, 2015

Relink Oracle binaries


Among other reasons after upgrading or patching the O/S it is recommended by Oracle to relink the Oracle binaries.

This can be done manually as following:

1. Set environment variables

DISPLAY
TERM or ORACLE_TERM
ORACLE_HOME
PATH to include $ORACLE_HOME/bin
LD_LIBRARY_PATH $ORACLE_HOME/lib:/usr/lib


2. Perform the relink

As oracle user on the DB server execute:

-- All versions


$ORACLE_HOME/bin/relink all >> relink.log

 -- Additional for 11GR2 using the OUI

$ORACLE_HOME/oui/bin/runInstaller -relink -waitForCompletion -maketargetsxml  $ORACLE_HOME/inventory/make/makeorder.xml  -logLocation $ORACLE_HOME/install ORACLE_HOME=$ORACLE_HOME > $ORACLE_HOME/install/relink.log 2>&1


REFERENCES:

Oracle support Documents 1467060.1,883299.1