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

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 Copy the apps and DB tier node Configure the target db node Change the init.ora paramet...

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

We need to check v$parameter table and find the coumn name in ISSUE_MODIFIABLE Static parameter The ISSUE_MODIFIABLE column value FALSE means parameters are static parameter Static parameter values change the value in spfile only so we need to restart the database otherwise it  will be reflect on next database bounce. Must we need to use scop=spfile EX: SQL>Alter system set sga_max_size=50m scope=spfile; Dynamic parameter: The ISSUE_MODIFIABLE column value Immediate means parameter are dynamic   parameter We can change the dynamic parameter in anytime no need to bounce for this changes This changes are applied in database memory and spfile We can use scope=memory and scope=both parameters EX: SQL> Alter system set log_archive_dest=’/u01/arch’ scope=both; Meaning of scope= memory|spfile|both Scope: Changes should be made in memory spfile and both areas Scope= Memory : Ch...

R12.2 having two file system fs1(Run), fs2(Patch) and fs_ne(log) R12 only having application file system R12.2 introduced online patching (adop) à Click hear R12 using adpatch à   Click hear R12.2  introduced weblogic server IAS_HOME(10.1.3)  replaced by FMW_HOME(OHS,WLS) weblogic server FNDCPASS UTLITY: R12 FNDCPASS have only two steps à clickhear R12.2 after completed FNCPASS utility need to change password in weblogic console  à click hear

In this post, I will cover some useful basic Environment variables.  Configuration files in R12.2   Important Environment files:-   Lactation :  cd /u01/apps/dev File Name : EBSapps.env This is the main environment file we can source RUN/PATCH edition using this file   Lactation : cd $APPL_TOP location below tow important environment files available    File Name : Apps<CONTEXT_NMAE>.env This file is known as the universal environment file. File Name: <CONTEXT_NAME>.env executable environment of APPL_TOP and oracle   Lactation: cd $INST_TOP/appl/admin File Name: adovars<ONTEXT_NMAE>.env Its contain JAVA HTML related environment variables    10.1.2 Env Files:   Lactation : cd $INST_TOP/ora/10.1.2 File Name:  <CONTEXT_NAME>.env Its contain all 10.1.2 related executable environment     Important Configuration Files:-   Lactation: cd $APPL_TOP/adm...