Oracle Apps DBA Interview questions Part-1
1 1) How to recreate context file? $ cd $INST_TOP/appl/admin $ mv vision_apps.xml vision_apps.xml_bkp RUN : perl $COMMON_TOP/clone/bin/ adclonectx.pl retrieve 2) How to recreate context file in Database side? $ORACLE_HOME/appsutil/bin Use adbidxml.pl scipt 3) How to find out invalid objects in the database? select count(*) from dba_objects where status =’INVALID’ 4) How to compile invalid objects? Database side Cd $ORACLE_HOME/rdbms/admin/utlrp.sql $sqlplus sys as sysdba SQL > @utlrp.sql Application side: Using adadmin 5) If possible to rollback the autoconfig session? Yes, We have using following steps Shutdown the application services Restore the Autoconfig session cd $INST_TOP/admin/log/MMDDHHMM/restore.sh sh restore.sh Once done the activity start the application 6) How to create appsutil.zip file? $AD_TOP/bin Run $ perl admkappsutil.pl This will create appsutil.zip in $INST_TOP/admin/out