Thursday, October 11, 2018

ADOPValidations EBS 12.2

ADOPValidations_detailed.log reported a warning message for one of the critical error "Cross Reference"

        [WARNING]: Found invalid cross references in FS config files.

cross reference is nothing but having incorrect values in the context file of EBS 12.2

for example : run file system context file having path of patch file system 


$ grep -i fs2 /prod/inst/fs1/inst/apps/PROD_node1/appl/admin/PROD_node1.xml

$ grep -i fs1 /prod/inst/fs2/inst/apps/PROD_node1/appl/admin/PROD_node1.xml /prod/applmgr/fs1

here on the patch file system there is a cross reference which can be very costly mistake if you ignore it. so consider having all validations reviewed.

how to fix it then ....

just update the context file and upload it to the database

$ADJVAPRG action=upload contextfile= logfile=/tmp/patchctxupload.log

then run ADOP operations...

Golden Gate moving from Classic to Integrated

Golden Gate moving from Classic to Integrated was an option taken in one of our project to have better performance. A lot of effort was put to convert all the extract and replicate to Integrated mode and some optimization parameters were used but still there were not a significant performance improvement.

Then I took a different route to examine the AWR and ASH for the replicate processes. Wow our friend INDEXES. Since we were dealing with build load , some of the unwanted indexes were dropped and Golgen Gate was super fast. Both Integrated and Classic was having better performance. Post the build load we rebuild the indexes.

Better consult a Dr.DBA always.

Popular Posts