Modern Oracle DBA

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://<