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

Move the $ORACLE_HOME

unzip -0 appsutil.zip file

7) What is adident utility?

Adident utility is used for find the file version

Syntax:  adident Header <filename>

8) How to find oracle apps version?

Select release_name from fnd_product_groups;

9) What is (.dbc) file?

Dbc file contain database connection information. DBC file is used by oracle applications to connect to database. Its location is $FND_SECURE.

10) How to find opatch version?

$ORACLE_HOME/OPatch/opatch version

OPatch -lsinventory

11) ADpatch Option ?

$adpatch options=noautoconfig

$adpatch options=nocompiledb

$adpatch options=nocopyportion

$adpatch options=nocompilejsp

$adpatch options=nogenerateportion

$adpatch options=hotpatch

$adpatch options=nolink

$adpatch options=nogenform

12) Post Clone Steps in R12 ?

Run cmclean.sql

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

    COMMIT;

    EXIT;

It will delete all old data from the table.

Run AutoConfig on all tiers

Change application and database user password


Coman questions:

What Are all the day-to-day activities in previous projects?
What is Your Prod database size?
Did you have experience in any monitoring tools? like OEM,Zenos,etc..
Did you solve any P1 ticket and explain