Oracle Apps DBA Interview Questions and Answers

Question: Hi, How are you?

Answer: Hello, I'm doing well. How are you? [This may different, depends person to person]

Question: 1. Can you please briefly introduce about your experiences.

Answer : [Best Answer in 10-20 lines, how to start is the main steps.]

Question: 2. How you scale yourself for APPS DBA and Core DBA.

Answer : [As per your skill and knowledge but always keep above 60% -- as per our expert and advice]

Question: 3. Suppose we are applying the patch and got failed due to some tablespace full, how you will take care?

Question: 4. what are the types of patching?

Answer: There are main 4 different types of patches

One-off patch

Mini pack Patch

Family pack patch

Maintenance pack patch

NLS Patch – For Languages patches like English, French, Japanese etc…

Note (Quick-Reference):

few one off patch = mini pack ,

few mini pack / family bundeled = family pack

all family pack fixed = Maintenance pack

Question: 5. Have you applied HRMS patches?

Question: 6. why we enable maintenance mode?

Question: 7. what are the Patching options in R12.1.3?

Question: 8. why we use ADCTRL?

Question: 9. how frequently CPU patches we apply?

Question: 10. What are the steps to apply the APPS Patches?

Question: 11. Can we enable maintenance mode if our Application is running?

Answer: Yes

Question: 12. What are the High level Cloning Steps?

Question: 13. What does Adpreclone on APPS Tier?

Question: 14. How Autoconfig works and why we run?

Question: 15. If customers are complaining that a program is running for Long

time, what you need to take actions?

Question: 16. Why and when we need to run GSS?

Question: 17. Suppose customers are complaining that only one module (example - GL) forms are opening slowly, what we need to check and troubleshoot for this?

Question: 18. Suppose CRM is down then what will happen and what to do?

Question: 19. If CRM is down then who will work for CRM? Which Concurrent Manager will act like CRM?

Question: 20. If status of a program is in Pending and Standby, what it means and what you will do?

Question: 21. Have you worked on PCP? Do you know setup for PCP?

Question: 22. Have you done SSO setup?

Question: 23. What are the parameters asked during applying apps patch? 

Question: 24. If the concurrent program is running for long time, can we enable trace and how?

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

 

How to recreate context file in Database side?

 

$ORACLE_HOME/appsutil/bin

Use adbidxml.pl scipt

 

How to find out invalid objects in the database?

 

select count(*) from dba_objects where status =’INVALID’

 

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

 

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

 

 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

 

 What is adident utility?

 

Adident utility is used for find the file version

Syntax:  adident Header <filename>

 

How to find oracle apps version?

 

Select release_name from fnd_product_groups;

 

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.

 

How to find opatch version?

 

$ORACLE_HOME/OPatch/opatch version

OPatch -lsinventory

 

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

 

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.

Did you solve any P1 ticket and explain

 

 

How to change the apps password in R12.2?

·       

       Down the application services

 

  FNDCPASS APPS/[apps_pass] 0 Y SYSTEM/[system_pass] ORACLE APPLSYSPUB [new_passs]

    

     Start the adadminsrvctl.sh services

     

     Login weblogic services

  

      Go to datasourceàconnection poolsàEnter the new password

 

   Run Autoconfig

 

   Start the application services.

 

How to change the weblogic Admin password in R12.2?

·             Before change the password take the backup of boot.proprties files

    Go to weblogic console DomainàSecurityàAdvanceàChange the Node manger password

   Go to security Realms àmyrealmàUser and groupsà Weblogic(Change the weblogic password)

  Finally we need to manually change the boot.propertices password and start all services

 

Explain the Cloning steps?

·          Prepare the source system

 ·         Copy the apps and DB tier node

 ·         Configure the target db node

 ·         Change the init.ora parameter file (db_file_name_convert,Log_file_name convert)

 ·         Startup nomount pfile=init.ora;

 ·         Run the RMAN restoration script

 ·         Configure the target Apps tier node.(adcfgclone.sh appsTier dual_fs)

 

If we apply the patch in downtime mode how it will sink in run file system to patch file system?

 

After applied the patch in downtime mode need to run adop phase=fs_clone it will sink the patch in run file system to patch file system.

 

How to create new OA-Core server in R12.2?

 

Managed server creation/deletion should be done only through the adProvisionEBS.pl and txkSetAppsConf.pl scripts

 

How to clear chache in R12.2?

 

Go to functional admirationàCaching frameworkà Global configurationàclear cache.

 

How to increase in javaheap size in R12.2?

 

Need to change the below values

 

-XX:PermSize=128m -XX:MaxPermSize=384m -Xms1024m -Xmx2048m

 XX is MaxPermSize

 Xms is the minimum heap size

 Xmx is the maximum heap size

 Default values=512m

 

How to avoid the long running concurrent program?

·         Will create the custom concurrent program

 ·         This improves overall performance of the system.

 ·         Create a Specialized Manager to process the specific 'Long Running' requests.

 ·         Assign the Specialized Manager with a work shift with Off peak time.

 ·         Need to check database side any blocking and locking session

 ·         Generate the tkprof and analysis the trace files

 

Difference between local inventory and global inventory?

 

How to apply Opatch?

Download the patch and read the redmi.txt file

 

Shutdown the database and listener

 

Check patch applied/not

 

Apply the patch opatch apply

 

Opatch options:

 

Opatch ApplyàInstall the patch

Opatch lsinventoryà list of patch currently installed in the server

Opatch rollback –id <Patch_number>à Rollback the patch

Opatch version àshowing the current version of the patching utility

 

What is apps listener and why it used?

 

Apps listener is combination of FNDFS&FNDSM it’s running all apps node with listener alias name. It’s mainly used for listening the request for services like FNDFS&FNDSM

 

What is difference between Socket & Servlet Mode in Apps Forms?

 

When forms run SOCKET Mode these are dedicated connection between Client Machine & Form Server (Started by adfrmctl.sh).

 

When Forms run in servlet mode the forms requests are fulfilled by Jserv in Apache . There will be additional JVM for Forms Request in that case and you won't start form via adfrmctl.sh.

 

What is batch size in adpatch?

 

Batch size is how many table performed same time. If example I give batch size 1000 means 1000 tables will perform same time in patching activity.

 

What is (.lgi) file ?

 

Lgi files are created with patching along with patch log file (.log) it’s contain information related to patch

 

Patch will create two tables what are the content of the tables?

 

Fnd_install_processes and ad_differed_jobs will create during patching cycle. Both are temporary table.

Fnd_install_processes:

This table will store the worker information like what job assigned to which worker and it’s status.

ad_differed_jobs:

This table is used to store the information about failed worker job

 

Explin Concurrent Request Life Cycle?

 

Pending / Normal

This request is waiting for next available concurrent manager

Increase number “processes” of the Concurrent Manager

 

Pending / Standby

The Request is waiting at CRM due to Conflict Request which is already being run.

 

Running / Normal

This Request is running normal if If the request is taking longer time, enable Database Trace and tkprof and find out expensive DML

 

Completed / Error

Check the request log file and take action accordingly

 

Inactive / No Manager

Manager is not available that manager

 

Explain concurrent manager tables?

 

Fnd_concurrent_requests

Fnd_concurrent_programs

Fnd_concurrent_process

Fnd_concurrent_queues

 

What is AutoConfig?

 

AutoConfig is a configuration tool that automates the configuration of an Oracle E-Business Suite instance. The information required for configuring an Applications system is collected into an XML repository, called the Applications context file

 

If we run autoconfig which file will get effect how to find?

 

If we want to check we can run adchkcfg utlity it will generate HTML report will list of files and profile options  going to change the autoconfig

Adchkcfg.sh location:cd $AD_TOP/bin

 How can I roll back an AutoConfig session?

 All backup configuration files from each AutoConfig session are stored in:

On the application tier:

<INST_TOP>/admin/out/<MMDDhhmm>

On the database tier:

<RDBMS ORACLE_HOME>/appsutil/out/<CONTEXT_NAME>/<MMDDhhmm>

where: <MMDDhhmm> = (month, day, hour, and minute of the AutoConfig run)

You can run restore.sh (UNIX) or restore.cmd (Windows) to roll back an AutoConfig session.