Modern Oracle DBA

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) Different btw adop prepare fs_clone ? 17) How many user will connect particular oacore ? 18) If admin service down what will happen? 19) How to troubleshoot long running queries ? 20) What is check point ? 21) If reado log file delete how will rec

Find the invalid objects: 1. Find the number of invalid objects Select count(*) from dba_objects where status=’INVALID’; 2. Find the object name /type Select owner,object_type,status from dba_objects where status ='INVALID'; How to compile invalid objects 1 Compile the invalid objects in apps schema: Application Side: Login the application services In application side use ADadmin utlity and give below options adadminà option3 Compile/Reload Applications Database Entities menuà1: Compile APPS schema Compile entire schema SQL> EXEC UTL_RECOMP.recomp_serial('APPS'); PL/SQL procedure successfully completed. SQL> 2 Database Side: Login Database server Goto $ORACLE_HOME/rdbms/admin and run utlrp.sql SQL> @utlrp.sql 3 Manual Method : Alter package <owner>,<package_name> compile; Alter package <owner>,<package_name> compile body; Alter view <owner>,<view_name> compile; Alter materialized

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 ·         

The Inventory very important part of Oracle universal installer. The inventory keeps all information about oracle product like oracle_home and locations,etc. The inventory in the ORACLE_HOME(Local Inventory) The central inventory outside the oracle_home (Global inventory)   Location: cat oraInst.loc  inventory_loc=/u01/app/oraInventory inst_group=oinstall  Global Inventory Global Inventory directory outside of the oracle_home called local inventory Physical Location /var/opt/oraInst.loc, /etc/oraInst.loc (AIX,Linux) Global inventory gets update every time install/De-install/Clone the ORACLE_HOME   Corrections to Central Inventory Attach DB Oracle_Home to Central Inventory: ./runInstaller -silent -attachHome ORACLE_HOME="<OracleHome-Directory>“ ORACLE_HOME_NAME="<OracleHome-Name> “LOCAL_NODE="rac1"   Detach Oracle_Home from Central Inventory : ./runInstaller -silent -detachHome ORACLE_HOME="<OracleHome-Direc

There are different way to find the EBS URL Method 1 Login the R12.2 application server Source the Env File [oracle@san ~]$ grep login $CONTEXT_FILE          <login_page oa_var="s_login_page">http://dev1.apps.com:8001/OA_HTML/AppsLogin</login_page> [oracle@san~]$ Method 2: Connect sqlplus apps user SQL> SELECT home_url  FROM icx_parameters; HOME_URL -------------------------------------------------------------------------------- http://<Hostname>:8007/OA_HTML/AppsLogin How to find Weblogic URL and PORT number: Login the R12.2 application server Source the Env File [oracle@sanprod ~]$ grep s_wls_adminport $CONTEXT_FILE          <wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port"> 7002 </wls_adminport> [oracle@sanprod ~]$ Weblogic Port Number:7002  Weblogic URL:http://<

Normally we are getting email/tickets to DEV/PROD instance application,forms are opening slow. those are very frequent issue we expected from devlopment and functional team. Before troubleshooting first we need to understand the issue so collect the below basic information from Users. 1) Is it slow for all users OR specific users OR slow for specific site/locations? 2) Any specific operation being performed which is making application slow? 3) What part of application is slow: HTTP pages, Forms, All etc? 4) If forms, then are these seeded or custom? 5) If seeded forms ask any customization causing issue 6) Can screenshot or navigation be provide so that DBA can replicate? 7) Is it constantly slow or slow at specific time of the day? Scenario-1: If all forms are opening slowly in particular machine? 1. Need to Clear internet browser history and cache. Go to IE->Internet options->Delete browsing history.

fnd_conc_clone.setup_clean : fnd_conc_clone is the package name setup_clean is procedure name After clone we must need to run the fnd_conc_clone.setup_clean script It will be clear the below tables in target node information in to source node table fnd_concurrent_queue_size fnd_concurrent_queues_tl fnd_concurrent_queue_size fnd_concurrent_queues fnd_nodes Syntax: $sqlplus apps/<apps_password> SQL> exec fnd_conc_clone.setup_clean; PL/SQL procedure successfully completed. SQL> commit; Commit complete. Once the script was executed must run the autoconfig in DB and Middle-Tier   Cmclean.sql We use the cmclean.sql scrip clean the running and pending requests Down the concurrent manager and check if any concurrent program running/not(ps- ef |grep FNDLIBR, ps- ef |grep FNDOPP) Cmclean.sql script is not recommended by oracle. R12 will user cpadmin.sh and  concurrent manager recovery wizard. It will be clea