DataBase Upgrade from 11g(11.1.0.7) to 12c(12.1.0.2) on R12 (12.1.3) Application Envirnment

12c Upgrade from 11.1.0.7 on R12.1.3:

Interoperability Notes Oracle EBS Release 12.0 or 12.1 with Oracle Database 12c Release 1 (12.1.0.1) (Doc ID 1930134.1)—old note

Latest note:

Interoperability Notes

Oracle E-Business Suite Release 12.0 or 12.1

with Oracle Database 12c Release 1 (12.1.0)

February 2016

Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)

Section 1: Upgrading an R12 Database to Oracle Database 12c Release 1 (12.1.0)

Follow the instructions in this section if you plan to upgrade the database server and instance to the latest version of Oracle Database 12c Release 1 (12.1.0).

Before the Database Installation:

1.     Verify software versions

The following software component versions must exist in your environment.

oracle E-Business Suite

12.0.6 or 12.1.3

Application

If you are on E-Business Suite Release 12.0, apply Patch 6728000 - Oracle E-Business Suite 12.0.6 Patch 16289505 - 12c Release 1 interoperability patch for Release 12.0.6 If you are on E-Business Suite Release 12.1, apply Patch 8796558 Patch 9239090 - Oracle E-Business Suite 12.1.3 Patch 12923944 Patch 13473483 Patch 16289505 - 12c Release 1 interoperability patch for Release 12.1 Patch 18843706 - apply only if you have applied a Recommended Patch Collection (RPC) patch

2.Apply patch 6400501 (conditional)

If you are on a UNIX/Linux platform, apply the 10.1.0.5 version of Patch 6400501 to the iAS 10.1.2 Applications tier Oracle home.

Note: For Linux x86-64 environments, download the Linux 32-bit version of the patch as the Applications tier Oracle home is 32-bit.

[tbdevmgr@tblnxapdev /apps/tbdevmgr/tech_st/10.1.2/OPatch/6400501]$ opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc Inventory is good and does not have any dangling patches. Updating inventory... Verifying patch... Backing up comps.xml ... OPatch succeeded.

Install the 12.1.0 software:

Log in to the database server node as the owner of the Oracle RDBMS file system and database instance. Ensure that environment settings, such as ORACLE_HOME, are set for the new Oracle home you are about to create, and not for any existing Oracle homes on the database server node. Perform all the steps in Chapter 6, "Installing Oracle Database" of the Oracle Database Installation Guide 12c Release 1 (12.1) for your platform.

In the install windows, select the options to install the database software only. Select any languages other than American English that are used by your Applications database instance. Choose the Enterprise Edition installation type

Install example CD as well.

In

After install CD completed ,You have to follow the below steps to complete the Upgrade.

Create nls/data/9idata directory

On the database server node, as the owner of the Oracle RDBMS file system and database instance, run the following command to create the $ORACLE_HOME/nls/data/9idata directory.

tbdevora@tblnxdbdev TBDEV> /patch/raghus/12cupgrade_R12.1.3patches/new12sw]$ cd

[tbdevora@tblnxdbdev TBDEV> /oracle/tbdev/orahome]$ perl $ORACLE_HOME/nls/data/old/cr9idata.pl

Directory /oracle/tbdev/orabin/11.1.0/nls/data/9idata already exist. Overwriting...

Copying files to /oracle/tbdev/orabin/11.1.0/nls/data/9idata...

Copy finished.

Please reset environment variable ORA_NLS10 to /oracle/tbdev/orabin/11.1.0/nls/data/9idata!

[tbdevora@tblnxdbdev TBDEV> /oracle/tbdev/orahome]$ export ORACLE_HOME=/oracle/tbdev/orabin/12c

[tbdevora@tblnxdbdev TBDEV> /oracle/tbdev/orahome]$ 11g to 12c 

[tbdevora@tblnxdbdev TBDEV> /oracle/tbdev/orahome]$ export PATH=$ORACLE_HOME/bin:$PATH

[tbdevora@tblnxdbdev TBDEV> /oracle/tbdev/orahome]$ perl $ORACLE_HOME/nls/data/old/cr9idata.pl

Creating directory /oracle/tbdev/orabin/12c/nls/data/9idata ...

Copying files to /oracle/tbdev/orabin/12c/nls/data/9idata...

Copy finished.

Please reset environment variable ORA_NLS10 to /oracle/tbdev/orabin/12c/nls/data/9idata!

[tbdevora@tblnxdbdev TBDEV> /oracle/tbdev/orahome]$ export ORA_NLS10=/oracle/tbdev/orabin/12c/nls/data/9idata

[tbdevora@tblnxdbdev TBDEV> /oracle/tbdev/orahome]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[tbdevora@tblnxdbdev TBDEV> /oracle/tbdev/orahome]$

[tbdevora@tblnxdbdev TBDEV> /oracle/tbdev/orahome]$

[tbdevora@tblnxdbdev TBDEV> /patch/raghus/12cupgrade_R12.1.3patches]$ cd 19382851/

[tbdevora@tblnxdbdev TBDEV> /patch/raghus/12cupgrade_R12.1.3patches/19382851]$ ls

etc  files  README.html  README.txt

[tbdevora@tblnxdbdev TBDEV> /patch/raghus/12cupgrade_R12.1.3patches/19382851]$ vi README.txt

[tbdevora@tblnxdbdev TBDEV> /patch/raghus/12cupgrade_R12.1.3patches/19382851]$ opatch apply

Oracle Interim Patch Installer version 12.1.0.1.3

Copyright (c) 2016, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/tbdev/orabin/12c

Central Inventory : /oracle/tbdev/orabin/oraInventory

   from           : /oracle/tbdev/orabin/12c/oraInst.loc

OPatch version    : 12.1.0.1.3

OUI version       : 12.1.0.2.0

Log file location : /oracle/tbdev/orabin/12c/cfgtoollogs/opatch/19382851_May_18_2016_14_03_49/apply2016-05-18_14-03-49PM_1.log

Applying interim patch '19382851' to OH '/oracle/tbdev/orabin/12c'

Verifying environment and performing prerequisite checks...

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/oracle/tbdev/orabin/12c')

Is the local system ready for patching? [y|n]

Y

User Responded with: Y

Backing up files...

Patching component oracle.rdbms, 12.1.0.2.0...

Verifying the update...

Patch 19382851 successfully applied

Log file location: /oracle/tbdev/orabin/12c/cfgtoollogs/opatch/19382851_May_18_2016_14_03_49/apply2016-05-18_14-03-49PM_1.log

OPatch succeeded.

Shut down Applications server processes and database listener

On each application tier server node, shut down all server processes or services. On the database tier server node, shut down the Oracle Net or Net8 database listener in the old Oracle home.

Note: The Applications will be unavailable to users until all remaining tasks in this section are completed.

Attention: Make sure that you do not have the LOCAL_LISTENER initialization parameter set to ensure that the database does not inadvertently point to a non-existent listener during upgrade.

Drop SYS.ENABLED$INDEXES (conditional)

If 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;

Remove the MGDSYS schema (conditional)

If you are upgrading from an RDBMS version prior to 12c, on the old database server node, use SQL*Plus to connect to the database as SYSDBA and run the $ORACLE_HOME/md/admin/catnomgdidcode.sql script. This drops the MGDSYS schema.

$ sqlplus “/ as sysdba” @?/md/admin/catnomgdidcode.sql

Prepare to upgrade:

SQL> @preupgrd.sql

Run DBUA from 12c ORACLE_HOME/bin:

Unset ORA_NLS10 and ORA_TZFILE to complete DBUA with out any error.else you may see the error like "ORA-01804 "failure to initialize timezone information".

DB Upgrade is completed.But You have to do some additional steps for ready the instance with your application.

Compile The Invalids:

sql> exec utl_recomp.recomp_parallel(25);

Run adgrants.sql

Copy $APPL_TOP/admin/adgrants.sql (adgrants_nt.sql for Windows) from the administration server node to the database server node. Use SQL*Plus to connect to the database as SYSDBA and run the script using the following command:

$ sqlplus “/ as sysdba” @adgrants.sql (or adgrants_nt.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. Use SQL*Plus to connect to the database as APPS and run the script using the following command:

$ 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]

Gather statistics for SYS schema

Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node. Note that adstats.sql has to be run in restricted mode. Use SQL*Plus to connect to the database as SYSDBA and use the following commands to run adstats.sql in restricted mode:

$ sqlplus "/ as sysdba"
SQL> alter system enable restricted session;
SQL> @adstats.sql 
$ sqlplus "/ as sysdba"
SQL> alter system disable restricted session;
SQL> exit;


Deregister the current database server (conditional)

If you plan to change the database port, host, SID, or database name parameter on the database server, you must also update AutoConfig on the database tier and deregister the current database server node.

Use SQL*Plus to connect to the database as APPS and run the following command:

$ sqlplus apps/[APPS password]
SQL> exec fnd_conc_clone.setup_clean;

Create appsutil.zip on application server node ,and copy that to new ORACLE_HOME which is 12c.
Unzip on the new ORACLE_HOME location.
Go to the ORACLE_HOME/bin
run perl adbldxml.pl for create the Context File for this new 12c DB Thena fter run autoconfig.






Create the new MGDSYS schema (conditional)


If you upgraded from an RDBMS version prior to 12c, use SQL*Plus to connect to the database as SYSDBA and run the $ORACLE_HOME/rdbms/admin/catmgd.sql script. This creates the new MGDSYS schema.

$ sqlplus "/ as sysdba" @?/rdbms/admin/catmgd.sql




Apply post-upgrade WMS patch (conditional)

If you upgraded from an RDBMS version prior to 12c, apply Patch 14356466 for E-Business Suite Release 12.0 or Patch 18039691 for E-Business Suite Release 12.1


Create Demantra privileges (conditional)

If you are using Demantra, perform the steps in document 730883.1 on My Oracle Support.


Re-create custom database links (conditional)

If the Oracle Net listener in the 12.1.0 Oracle home is defined differently than the one used by the old Oracle home, you must re-create any custom self-referential database links that exist in the Applications database instance. To check for the existence of database links, use SQL*Plus on the database server node to connect to the Applications database instance as APPS and run the following query:

$ sqlplus apps/[apps password]
SQL> select db_link from all_db_links;


The EDW_APPS_TO_WH and APPS_TO_APPS database links, if they exist, should have been updated with the new port number by AutoConfig in the previous step.If you have custom self-referential database links in the database instance, use the following commands to drop and re-create them:


$ sqlplus apps/[apps password]
SQL> drop database link [custom database link];
SQL> create database link [custom database link] connect to
     [user] identified by [password] using
     '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[hostname])
     (PORT=[port number]))(CONNECT_DATA=(SID=[ORACLE_SID])))';


where [custom database link], [user], [password], [hostname], [port number], and [ORACLE_SID] reflect the new Oracle Net listener for the database instance.

Enable Database Vault (conditional)

If you disabled Database Vault, enable it by performing step 7 of Part 2 of document 1091083.1 on My Oracle Support.


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 12.1 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
Batch Size = 10000
Fix dangling users = Yes
Add missing user/role assignments = Yes
Update WHO columns in WF tables = No

Click "OK" and "Submit".




RUN AUTO CONFIG ON Both Application Tier node.Your Application is ready with 12c DB.

Thanks
Srini