Thursday 5 August 2010

Upgrading Release 12.1 Database from 10.2.0.4.0 to 11.2.0.1.0

Very recently I have upgraded one of my R12 database instance from 10.2.0.4.0 to 11.2.0.1.0

Current DB instance home /u01/ajidb/10.2.0
Application version 12.1.1
OS version : OEL 4.6

I have followed these steps to do that

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

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_BASE
ORACLE_HOME=$ORACLE_BASE/db/tech_st/11.2.0;
export ORACLE_HOME

LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/odbc/lib;
export LIBPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib;
export LD_LIBRARY_PATH

PATH=$ORACLE_HOME/bin:$PATH
PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0;
export PERL5LIB
PERL5LIB=$PERL5LIB:$ORACLE_HOME/perl/lib/site_perl/5.10.0;
export PERL5LIB



Install Oracle Database 11g Products from the 11g Examples CD


On the database server node, as the owner of the Oracle RDBMS file system and database instance, perform the tasks in section 3, "Download Oracle Database Examples" in the Oracle Database Examples CD Installation Guide


Create nls/data/9idata directoryOn the database server node, as the owner of the Oracle RDBMS file system and database instance, run the $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory.

Run the Oracle Net Configuration Assistant before running DBUA


When running dbua, set the _disable_fast_validate parameter using the following command: dbua -initParam "_disable_fast_validate=TRUE"


Modify initialization parameters 396009.1, Database Initialization Parameter Settings for Oracle Applications Release 12
Ensure the parameter "_disable_fast_validate=TRUE" is in the initialization file

Apply additional 11.2.0.1 RDBMS patches
Apply the following patches:



  1. 8328200
  2. 9218789
  3. 9318214
  4. 9657344
  5. 9719541
  6. 9756939

4.     Shut down Applications server processes and database listenerIf the SYS.ENABLED$INDEXES table exists, use SQL*Plus to connect to the database as SYSDBA and running the following command to drop it:SQL> drop table sys.enabled$indexes


Perform post-install instructions


After the Database Upgrade:


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 schema name]


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.

[appsR12@visr12 sql]$ cd $AD_TOP/bin
[appsR12@visr12 bin]$ perl admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /u01/oracle/AJI/inst/apps/AJI_visr12/admin/log/MakeAppsUtil_08031011.log
output located at /u01/oracle/AJI/inst/apps/AJI_visr12/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
[appsR12@visr12 bin]$

Login as Oracle user

[oracle@visr12 11.2.0]$ cp /u01/oracle/AJI/inst/apps/AJI_visr12/admin/out/appsutil.zip $ORACLE_HOME
[oracle@visr12 11.2.0]$ unzip -o appsutil.zip
[oracle@visr12 bin]$ cd $ORACLE_HOME/appsutil/bin
[oracle@visr12 bin]$ perl adbldxml.pl jtop=/usr/java/jdk1.6.0_16

TNS_ADMIN=/u01/oracle/AJI/db/tech_st/11.2.0/network/admin;export TNS_ADMIN

[oracle@visr12 bin]$perl adbldxml.pl jtop=/usr/java/jdk1.6.0_16
Starting context file generation for db tier..
Using JVM from /usr/java/jdk1.6.0_16/bin/java to execute java programs..
APPS Password: apps
The log file for this adbldxml session is located at:
/u01/oracle/AJI/db/tech_st/11.2.0/appsutil/log/adbldxml_08031017.log
The log file for this adbldxml session is located at:
/u01/oracle/AJI/db/tech_st/11.2.0/appsutil/log/adbldxml_08031017.log

Enter the value for Display Variable: :1.0

The context file has been created at:
/u01/oracle/AJI/db/tech_st/11.2.0/appsutil/AJI_visr12.xml

[oracle@visr12 bin]$ perl adconfig.sh contextfile=/u01/oracle/AJI/db/tech_st/11.2.                   0/appsutil/AJI_visr12.xml appspass=apps

After creating the XML context file, ensure the variable s_jretop points to a proper JRE directory

      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 grants and synonyms
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".

Cheers!!!
SocialTwist Tell-a-Friend

Related Posts by Categories



No comments: