3 Replies Latest reply: Aug 3, 2013 5:20 PM by 9a143e0c-b8b4-413a-bd4f-89d69ef87199 RSS

    Upgrade from 12.1.1 to 12.1.3 with DMZ configured

    1008156

      Hi All

       

      Required patches for Upgrade

      • 9239089
      • 9239090
      • 9239095
      • 9817770
      • 9966055

      Step 1: shut down all the application services and database.

      Step 2: Take a cold backup of both file systems (APPS Tier and DB Tier)

      Step 3: Start the database listener and keep database in open state.

      Step 4: Ensure the binutils -2.17.50.6-6.0.1.el5 .

      If it is higher than above version downgrade it to avoid the error of                relink module “MSSCPP”.

      Step 5: Increase the size of table space APPS_TS_TX_DATA, SYSAUX and enable

      auto extend on to the added datafile      

      Step 6: To check the datafile location and file ID query the below SQL statement

      SQL>select file_name, tablespace_name from dba_data_files where               tablespace_name='APPS_TS_TX_DATA' order by file_name;

      Step 7: To increase the table space size, query the below SQL statement.

      SQL>ALTER TABLESPACE APPS_TS_TX_DATA add datafile '/u01/oracle/TESTEBS/db/apps_st/data/a_txn_data_05.dbf' size 3G autoextend on;

      Step 8: unzip the necessary patches and give the permissions to application user

                   to access the patches.

      Step 9: Apply R12.AD.B.DELTA.3 - Patch 9239089

      • Create $ORACLE_HOME/appsutil/admin on the database server.
      • Copy adgrants.sql (UNIX) from this patch directory 9239089 to $ORACLE_HOME/appsutil/admin.
      • Set the environment to point to ORACLE_HOME on the database server.
      • Use SQL*Plus to run the script- $ sqlplus "/ as sysdba"

      SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

      • Enable maintenance mode with adadmin, and set the environment to correct apps environment.
      • Apply 9239089 using adpatch tool
      • It prompts us the default location of the patch. We have to give the location of patch where its stored.
      • It prompts us driver file which was in the patch directory, we have to give it e.g.: u9239089.drv

      Step 10: Apply Oracle E-Business Suite Release 12.1.3 patch 9239090

      • It prompts us the default location of the patch, we have to give the location. Example [/d01/oracle/NewVis/apps/12.1.3/9239090]
      • It prompts us the driver file for the patch, we have to give the file.

      Example: [u9239090.drv] which was in the patch directory.

      Step 11: Apply the Online help file patch 9239095

      • It prompts us the driver file for the patch, we have to give the file.

      Example: [u9239095.drv] which was in the patch directory.

      Step 12: Apply the consolidated patch 9817770

      • It prompts us the driver file for the patch, we have to give the file.

      Example: [u9817770.drv] which was in the patch directory.

      Step 13: Apply the help patch 9966055

      • It prompts us the default location of the patch, we have to give the location. Example [/d01/oracle/NewVis/apps/12.1.3/9966055]
      • It prompts us the driver file for the patch, we have to give the file.

      Example: [u9966055.drv] which was in the patch directory.

      Step 14: Run Autoconfig

      • Source the application env file. Then run autoconfig in apps tier.
      • $ $ADMIN_SCRIPTS_HOME/adautocfg.sh
      • Now generate the appsutil.zip file.
      • $ perl /bin/admkappsutil.pl
      • Copy appsutil.zip file in DB_HOME. Unzip the appsutil.zip file.
      • After sourcing the database env file run autoconfig in database tier.

      Step 15: Run Pre-Clone

      • Now run preclone in db tier first, then in apps tier
      • perl adpreclone.pl dbTier
      • perl adpreclone.pl appsTier


      These are all the steps we used to follow in the normal environments


      Kindly let us the procedure to follow in the DMZ environments.

       

      Regards

      Niranjan