Interview Questions Usually asked by interviewer to APPSDBA .....

Oracle Application Server Interview Question

• Oracle Enterprise Manager.
• Oracle OC4J clustering file opmn.xml.
• SOA Suite High Availability.
• Active/Active and Active/Passive Installation steps not concept and Configuration.
• How can you do OID synchronization with Database?

Web Cache
• Invalidation
• Cache
• What is Site to Server Mapping?
• Where is the webcache config files and what are those?

OC4J
• What is Server.xml and where it is located?
• What is Opmn.xml and where it is located?
• Oc4j logs
• How to configure the data source?

Oracle Internet Directory (OID)
• OID administration Tool.
• Command line utilities. i.e ldapsearch ldapadd ldapdelete and etc.
• What is OIDDAS and how to access this?
• What is Entry Management in OID?
• Migration from OID to OID.
• I have 100 of users which want to be in OID. How would I proceed?

Single Sign On (SSO)
• SSO request flow.
• How do administration, register applications as partner in SSO?
• SSO log files and Config files.

Web Server or Apache Server (HTTP)
• Apache request flow in oracle application server.
• How information is stored in OID?
• User is not able to login to application and how do u rectify this?

OC4J Application Deployment
• If we deploy application how that reside in database.
• How you deploy application in OC4J instance?
• How you create OC4J instance from command line utility.

Oracle Applications E-Business Suite Interview Question
• Current Project role and responsibilities.
• Cloning – Difference between Cold and Hot Cloning.
• Parameters file (Pfile).
• How to Create control file in Hot Cloning?
• What are the changes require while creating control file?
• We need to run adcfgclone if we are doing Hot Cloning.
• If adpreclone is already run then need to be run again or not.
• Brief step of cloning.
• How to do a hot cloning. What are the steps.
• Adcfgclone
• What is Adsplice Utility? - ADSPLICE UTILITY in ORACLE application is utility to add a new product.
• What is adctrl utility?
• If Patch fails how could u clear the restart and what are tables need to drop? - FND_INSTALL_PROCESSES is a table that is created by RAPID INSTALL, ADPATCH and ADADMIN utilities. Normally the above utilities will remove this table after they complete.
• Backup the FND_INSTALL_PROCESSES and AD_DEFERED_JOBS.
• Cd $APPL_TOP/admin/ , mv restart restart_
• Patch not applied successfully, adpatch did not cleanup it’s restart files (*rf9)
cd $APPL_TOP/admin/$CONTEXT_NAME
mv restart restart_old
mkdir restart
• Have you faced any issue while patching.
• If we have requirement of changing domain, how could be proceed.
• How to use Admerge patch? – Create the source and destination directory.
• XML file and run autoconfig.

Oracle Real Application Cluster Interview Question

• Brief steps of RAC installation.
• What are the public, private and virtual ip’s?
• What are OCR and Voting Disk?
• What is Heartbeat in RAC?

Oracle Database Interview Question

• RMAN – What kind of backup RMAN is taking.
• What is difference between Normal Exp/Imp and Data pump Exp/Imp.
• What is redolog?
• If we do alter system switch logfile then what will happen if database is in Archive Log Mode?

General Interview Question

• Are you willing to travel in short notice period? you should not have travel constraint.
• Salary compensation?
• Are you willing to work in night shift's and sometimes in weekend's?

Extra Interview Question

• XML file in applications - $APPL_TOP/admin/_.xml context file.

posted by Jaswinder Singh @ 8:58 AM

0 Comments: