Modern Oracle DBA

Here I have collected the List of good Oracle Apps DBA interview Questions/Answers. How Many Oracle homes there in R12.2? Oracle 10.1.2 home and Oracle fusion middleware home oracle application is running on top of the FMW home. What is EBR? Edition based redefinition is R12.2 online patching new fecture. EBR has been introduced in 11g R12 database EBR is allows multiple version of plsql objects views and synonyms in single schema. EBR is enabled via database users and all EBS users including custon schemas. How Can We Improve ADOP Patch Performance in Oracle E-Business Suite? We need to tune below DB parameters  Set job_queue_processes = # of CPU’s Set parallel_max_servers = 2 X CPU’s(small server) 1 X CPU’s  While running adadmin What is batchsize parameter in EBS? It means number of rows to commit at one time to the Database.  What is multi ligual tables in ebs? EBS applications allow users to create their programs in a variety of languages.   Ex:- ...

1) How to restore the datafile asm to non-asm? 2) What happened alter database begin backup mode? 3) Why need to enable maintenance mode in adpatch? 4)Why we are using appsutil directory in under database home? 5)What is TWO_TASK parameter? 6)What is difference in adop prepare phase and fs_clone? 7)What is US directory in $AD_TOP? 8)How to troubleshoot long running concurrent program and sql query? 9)How to apply pre-request patch when patch running? 10)Explain weblogic patching steps? 11)Explain RMAN block change tracking?   12) Different btw fnd_ststs & dbms_ststus? 13) Different btw apps &applsys user? 14) Different btw rman validate & crosscheck?  15) What is high watermark in db? 16) How many user will connect particular oacore ? 17) How to troubleshoot long running queries ? 18) What is check point ? 19) If reado log file delete how will recover? 20) Different btw AWR,ASH,ADDM reports ? 21) After clone application URL i...

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 conten...

For in this post will see the scenario based interview questions and answers 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 paramet...

Before going to the interview prepare the below concepts. It will be easy to crack the interview. Application:- Upgradation Click hear Cloning Click hear Patching Clickhear Migration Log file location Concurrent Manager Clickhear Database:- Database Architecture  Clickhear Datagurad ASM,RAC Database Patching 11g,12c,19c New features OCI Instance creation PDB DB cloning and pdb instance creation   Performance Tuning:-  AWR ADDM ASH Sqltrp Concurrent manager and program slowness Find execution Plan change and pin best plan Cloning issues Basic day-to-day troubleshooting activity Finally search in google and study the current interview questions  à Click hear

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 $I...