Upgrading Oracle Application database to 11.2.0.3 with EBS R12(12.1.1)

Application version : 12.1.1 Database Current Version : 11.1.0.7 Database Name : TEST Operating System : Red Hat Enterprise Linux 5 (64 bit)

Before upgrading the database to 11.2.0.3 there are certain steps to be completed Apply the below patches

To apply the patches enable the system to be in “Maintenance Mode”

  1. Login to the application server and source the environment file.(APPSSID_HOST.env) OR (APPSSID_HOST.cmd) invoke the ad utility “adadmin” Users required for authentication : SYSTEM & APPS. Select Option 5 — Change Maintenance Mode Select Option 1 — Enable Maintenance Mode
  2. Go to the patch directory where you have downloaded the above patches and apply after following the README carefully. Ensure to complete all the steps for pre & post steps if any.

Prepare the new 11gr2 Oracle Home for upgrade

  1. Download Patch# 10404530(Part 1, 2 and 5) 11gr2(11.2.0.3) software from http://metalink.oracle.com
  2. Install Oracle Database Software into a new location
  3. Install Oracle Database 11g Products from the  11g Examples CD (mandatory)
  4. Create nls/data/9idata directory
  5. Apply additional 11.2.0.3 RDBMS patches

To apply the RDBMS patches shutdown the oracle database and listener.

export PATH=$PATH:$ORACLE_HOME/OPatch

Go to the patch directory and unzip the patches

 cd 4247037 opatch apply

Create listener and initialization file for the database Listener.ora

 
SID_LIST_TEST =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
TEST= (DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = testdbs.ods.com)(PORT = 1530))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1530))
 )
)

Initialization File (initTEST.ora)

test.__db_cache_size=1979711488
test.__java_pool_size=16777216
test.__large_pool_size=16777216
test.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment
test.__pga_aggregate_target=872415232
test.__sga_target=2583691264
test.__shared_io_pool_size=0
test.__shared_pool_size=536870912
test.__streams_pool_size=0
*.audit_file_dest=/u01/oracle/test/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/oracle/oradata/test/control01.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='test'
*.diagnostic_dest='/u01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.local_listener='LISTENER_TEST'
*.open_cursors=300
*.pga_aggregate_target=857735168
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=2575302656
*.undo_tablespace='APPS_UNDOTS1'

On the source database i.e 11.1.0.7 run pre-upgrade script (utlu112i.sql)

  1. Copy this file from the newly installed 11gr2 Oracle software (ORACLE_HOME/rdbms/admin/utlu112i.sql) to any temporary location
  2. Source the 11gR1 database environment file
  3. Login to the database
  4. Execute utlu112i.sql
  5. Complete the steps recommended in step 4(Output by utlu112i.sql)
  6. Shutdown the database and listener

On the target database i.e 11.2.0.3

    1. Source the new environment file (ORACLE_HOME,ORACLE_SID,PATH,TNS_ADMIN)
    2. Start the database in upgrade mode
    3. Run catupgrd.sql from $ORACLE_HOME/rdbms/admin
 sqlplus / as sysdba startup upgrade spool /u01/upgrade.log @catupgrd.sql

Post Upgrade steps

  1. Start the database in normal mode
  2. Run utlrp.sql (Compile invalid objects)
  3. Run catuppst.sql (Migrate baseline objects to 11gr2)
 sqlplus / as sysdba startup @?/rdbms/admin/utlrp.sql @?/rdbms/admin/catuppst.sql
  • Run adgrants.sql

Copy adgranst.sql from application tier to the database and run as sys user Copy $APPL_TOP/admin/adgrants.sql

 sqlplus "/ as sysdba" @adgrants.sql APPLSYS
    • Grant create procedure privilege on CTXSYS

Copy $AD_TOP/patch/115/sql/adctxprv.sql to the database server node.

 sqlplus apps/[APPS password] @adctxprv.sql [SYSTEM password] CTXSYS
    • Grant create procedure privilege on CTXSYS
 sqlplus "/ as sysdba" exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');
    • Validate Workflow ruleset

On the application server node, use SQL*Plus to connect to the database as APPS and run the $FND_TOP/patch/115/sql/wfaqupfix.sql script using the following command:

sqlplus [APPS user]/[APPS password] @wfaqupfix.sql apps apps
    • Deregister the current database server
 sqlplus apps/apps exec fnd_conc_clone.setup_clean;
      • Implement and run AutoConfig

Go to the Application tier and run admkappsutil.zip

 cd $AD_TOP/bin perl admkappsutil.zip
      Copy appsutil.zip to RDBMS Oracle HOME
 cd %ORACLE_HOME% cd appsutil/bin perl adbldxml.pl
      This will generate a context file for database tier. Run adconfig.sh to populate the entry in FND_NODES.
 cd %ORACLE_HOME%/appsutil/bin adconfig.sh contextfile=
  • Re-create custom database links
  • Re-create grants and synonyms
  • Disable Maitenance Mode
  • Start the application services
Share →
0 comments
Skip to toolbar