Oracle Apps DBA Interview Questions Part-2

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 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?

Click hear

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

Refer

Oracle Apps DBA Interview questionsà Click hear