Posts

Showing posts from November, 2019

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

Difference between local inventory and global inventory in R12.2

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

How to find EBS URL in R12.2

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