Recently Oracle had certified R12 database 11.2.0.2, the first patchset for the 11gR2 Database. I have successfully completed the installation. Have a look at it
Application Version : E-Business Suite Release 12.1.1
Database Version : 10.2.0.4
OS : Enterprise Linux AS Release 4.6
Current DB Home /u01/ajidb/10.2.0
New Home /u01/oracle/AJI/db/tech_st/11.2.0
I have followed these steps to achieve this.
Apply the following patches
1. 11g Release 2 interoperability patch for Release 12.1 (9062910)
2. 12.1 TXK Delta 3 patch (8919489)
3. 9868229
4. 10024524
AutoConfig Latest version with 9852070 and 9738085
Source the Application Tier environemnt file
. /u01/oracle/AJI/apps/apps_st/appl/APPSAJI_visr12.env
Enable maintenance mode
[appsR12@visr12 ~]$ adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=4
export PATCH_TOP=~/upgradeR12db_11.2.0.2/
Apply 11g Release 2 interoperability patch for Release 12.1 (9062910)
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9062910.log patchtop=$PATCH_TOP/9062910 driver=u9062910.drv workers=4
apply Patch 12.1 TXK Delta 3 patch (8919489)
Step :1
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u8919489.log patchtop=$PATCH_TOP/8919489 driver=u8919489.drv workers=4
Step: 2
1.1. On the Application Tier (as the APPLMGR user):
1.1.1. Source the environment file.
1.1.2. Create the appsutil.zip file by executing:
$ADPERLPRG $AD_TOP/bin/admkappsutil.pl
This will create appsutil.zip under $INST_TOP/admin/out
1.2. On the Database Tier (as the ORACLE user):
1.2.1. Copy or FTP the appsutil.zip file to the [RDBMS ORACLE_HOME]
1.2.2. cd [RDBMS ORACLE_HOME]
1.2.3. unzip -o appsutil.zip
1.2.4. Run AutoConfig by executing:
[RDBMS_ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]/adautocfg.sh
apply Patch 9868229
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9868229.log patchtop=$PATCH_TOP/9868229 driver=u9868229.drv workers=4
apply Patch 10024524
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u10024524.log patchtop=$PATCH_TOP/10024524 driver=u10024524.drv workers=4
Apply Latest veriosn AutoConfig 9852070 and 9738085
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9738085.log patchtop=$PATCH_TOP/9738085 driver=u9738085.drv workers=4
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9852070.log patchtop=$PATCH_TOP/9852070 driver=u9852070.drv workers=4
1.1. On the Application Tier (as the APPLMGR user):
1.1.1. Source the environment file.
1.1.2. Create the appsutil.zip file by executing:
$ADPERLPRG $AD_TOP/bin/admkappsutil.pl
This will create appsutil.zip under $INST_TOP/admin/out
1.2. On the Database Tier (as the ORACLE user):
1.2.1. Copy or FTP the appsutil.zip file to the [RDBMS ORACLE_HOME]
1.2.2. cd [RDBMS ORACLE_HOME]
1.2.3. unzip -o appsutil.zip
1.2.4. Run AutoConfig by executing:
[RDBMS_ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]/adautocfg.sh
Install the 11.2.0.2 software downloaded from http://updates.oracle.com/download/10098816.html
In the Installation Types window, select the option install the database software only.
The 11.2.0 Oracle home must be installed on the database server node in a different directory than the current Oracle home.
New Oracle Home /u01/oracle/AJI/db/tech_st/11.2.0
Also required to install Oracle Database 11g Products from the 11g Examples CD
Once installed base 11.2.0 software, need to set the following in .bash_profile of oracle user
ORACLE_SID=AJI;export ORACLE_SID
ORACLE_BASE=/u01/oracle/AJI;export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/db/tech_st/11.2.0;export ORACLE_HOME
LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/odbc/lib;export LIBPATHLD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin:$PATHPERL5LIB=$ORACLE_HOME/perl/lib/5.10.0;export PERL5LIBPERL5LIB=$PERL5LIB:$ORACLE_HOME/perl/lib/site_perl/5.10.0;export PERL5LIB
Create nls/data/9idata directory
perl $ORACLE_HOME/nls/data/old/cr9idata.pl
This will create create the $ORACLE_HOME/nls/data/9idata directory.
ORA_NLS10=/u01/oracle/AJI/db/tech_st/11.2.0/nls/data/9idata;export ORA_NLS10
Apply any other additional 11.2.0.2 RDBMS patches
Also required to Apply the following patches:
4247037
10149223
Now you can do the Database Upgrade from 10.2.0.4.0 to 11.2.0.2.0:
Shut down Applications server processes and database listener
I have used Database Upgrade Assistant (DBUA) to do the upgradation from 10.2.0.4 to 11.2.0.2. This will take some times to complete based on your hardware.
Now required to upgrade Oracle E-Business Suite has only one statistics table, APPLSYS.FND_STATTAB. Please execute the following
Connect to SQL*Plus as sysadmin user and run the following line:
EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS','FND_STATTAB');
Next step is that modify initialization parameters for R12.
I have followed the Note: 396009.1, Database Initialization Parameter Settings for Oracle Applications Release 12
Perform patch post-install instructions
Run only the catmgdidcode.sql and utlrp.sql scripts for the post install instructions in patch 9218789.
After the Database Upgrade:
Start the new database listener
If the Oracle Net listener for the database instance in the new Oracle home has not been started, you must start it now. Since AutoConfig has not yet been implemented, start the listener manually.
Set the TNS_ADMIN environment variable to the directory where you created your listener.ora and tnsnames.ora file
Run adgrants.sql
Copy $APPL_TOP/admin/adgrants.sql from the administration server node to the database server node.
$ sqlplus "/as sysdba" @adgrants.sql APPS
Grant create procedure privilege on CTXSYS
Copy $AD_TOP/patch/115/sql/adctxprv.sql from the administration server node to the database server node.
$ sqlplus apps/[APPS password] @adctxprv.sql [SYSTEM password] CTXSYS
Set CTXSYS parameter
Use SQL*Plus to connect to the database as SYSDBA and run the following command:
$ sqlplus "/ as sysdba"
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');
Validate Workflow ruleset
On the administration 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\
[APPLSYS user] [APPS user]
Implement and run AutoConfig
Implement and run AutoConfig in the new Oracle home on the database server node. If the database listener of the new Oracle home is defined differently than the old Oracle home, you must also run AutoConfig on each application tier server node to update the system with the new listener.
Gather statistics for SYS schema
Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node.
$ sqlplus "/ as sysdba"
SQL> alter system enable restricted session;
SQL> @adstats.sql
$ sqlplus "/ as sysdba"
SQL> alter system disable restricted session;
SQL> exit;
Re-create custom database links, if any.
Re-create grants and synonyms
Oracle Database 11g Release 2 (11.2) contains new functionality for grants and synonyms compared to previous database releases. As a result, you must re-create the grants and synonyms in the APPS schema. On the administration server node, as the owner of the Applications file system, run AD Administration and select the "Recreate grants and synonyms for APPS schema" task from the Maintain Applications Database Objects menu.
Restart Applications server processes
Restart all the Application tier server processes that you shut down previously. Remember that the Oracle Net listener for the database instance, as well as the database instance itself, need to be started in the 11.2 Oracle home. Users may return to the system.
Synchronize Workflow views
Log on to Oracle E-Business Suite with the "System Administrator" responsibility. Click Requests > Run > Single Request and the OK button. Enter the following parameters:
Request Name = Workflow Directory Services User/Role Validation
p_BatchSize = 10000
p_Check_Dangling = Yes
Add missing user/role assignments = Yes
Update WHO columns in WF tables = No
Click "OK" and "Submit".
Please refer Interoperability Notes EBS R12 with Database 11gR2 (1058763.1)
Cheers!!!
No comments:
Post a Comment