R12.2 Apps DBA. Powered by Blogger.

Oracle Database 12c upgrade from 11.2.0.2 is supported

No comments :

Obtaining the Software 12.1.0.2.0 from the patchset  21419221 "Patchset  21419221
Once Download done, check the following:-
Verify that the files you downloaded are the same size as the corresponding files on Oracle Technology Network.
Also verify the checksums are the same as noted on Oracle Technology Network using a command similar to the following:
cksum filename.zip"
Direct upgrade from 11.2.0.2 is supported
Oracle E-business suite 11.5.10 CU2 patches " Patch 3460000 - 11.5.10 E-Business Suite Consolidated Update 2- Applied
    Patch 10350522 - Prerequisite patch for 16289505- Not Applied
    Patch 12539637 - Prerequisite patch for 16289505- Not Applied
    Patch 20621314 - Prerequisite patch for 16289505- Not Applied
    Patch 9535311 - TXK AUTOCONFIG AND TEMPLATES ROLLUP PATCH U  - Already Applied
    Patch 16289505 - 12c Release 1 interoperability patch for 11.5.10 - Not Applied  ( Requires 11i TXK RUP-U,9535311 which is already applied)"
ATG Rollup Patch  7 (Application Tier) Apply Patch 6241631- Applied
Developer 6i (Patch set 19) Already in Patchset 19
Pre Upgrade Steps:-
Creating 12.1.0 Oracle Home Make Directories for new 12c Oracle RDBMS Home
Install 12c RDBMS Software Stage the software before upgrade
Install 12c Examples CD "Once the Installation is done, make sure you source the 12c Oracle Home.
The ORACLE_HOME environment variable points to the new 12.1.0 Oracle home.
The PATH environment variable includes $ORACLE_HOME/bin and the directory where the new perl executable is located (usually $ORACLE_HOME/perl/bin).
The LD_LIBRARY_PATH environment variable includes $ORACLE_HOME/lib.
The PERL5LIB environment variable points to the directories where the new perl libraries are located (usually $ORACLE_HOME/perl/lib/[perl version]
and $ORACLE_HOME/perl/lib/site_perl/[perl version])"
Create /nls/data/9idata directory
Apply additional 12.1.0.2 RDBMS patches "Patch 19393542- Pre-req of EBS CPU Patch
Patch 19627012
Patch 20204035
 Patch 20903906 "
Database Upgrade Steps:-
Shut down Applications server processes and database listener
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;"
"Verify the JRE version in Oracle Home
To upgrade to 12cR1 minimum version of JRE required is version 6. Please make sure that Installed version of JRE in an existing Oracle Home.
If the Installed version is lower than required then please upgrade it." "/ora/bovprod/home/product/11.2.0/jdk1.7.0_79
/ora/prodx/home/product/11202/jdk1.7.0_79"
Remove the MGDSYS schema "If upgrading from database version prior to 12c than drop MGDSYS schema from the existing database. Execute script ""catnomgdidcode.sql ""
from an existing Oracle home.
"
Run pre upgrade tool "Pre Upgrade tool will lists all changes need to be performed before starting the upgrade process.
Copy pre upgrade scripts from 12cR1Oracle home to any other directory.
"
Check for INVALID database components and objects in the Source database "set pagesize500
set linesize 100
select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name;
select substr(object_name,1,40) object_name,substr(owner,1,15) owner,object_type from dba_objects where status='INVALID' order by owner,object_type;
select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type order by owner,object_type ;" "$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus ""/ as sysdba""
SQL> @utlrp.sql"
Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12cR1 database . (Doc ID 1585343.1)
 Optimizer Statistics "$ sqlplus ""/as sysdba""
sql> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS" Note 560336.1 Script to Check Schemas with Stale Statistics
Perform Full Database backup
Upgrade Database
Upgrade Database Use DBUA for upgrading database
Post Upgrade Steps
Install patch post Installation steps for all RDBMS patches (opatches) "Perform post Installation steps for all Installed patches prior to upgrade.
If DATAPATCH is required to run then it can be run but only once.
"
Start Listener from 12cR1 Home "Start the new database listener (conditional)
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 with the lsnrctl executable (UNIX/Linux)
"
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"
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');"
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 restart the database in restricted mode, run adstats.sql, and restart the database in normal 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;
"
Implement and run AutoConfig
Re-create OPATCH_INST_DIR directory "Use SQL*Plus to connect to the database as SYSDBA and run the following command to re-create the OPATCH_INST_DIR directory:
SQL> create or replace directory OPATCH_INST_DIR as '[ORACLE_HOME]/OPatch';
"
Re-create custom database links (conditional)
Re-create grants and synonyms
Run AutoConfig on Application Tier
Restart Applications server processes (conditional)
Database PSU Patching Oct CPU 2015 Check the Doc mailed by Sudipta
Reference
Interoperability Notes EBS 11i with RDBMS 12cR1 (Doc ID 1524399.1)
Complete Checklist for Upgrading to Oracle Database 12c Release 1 using DBUA (Doc ID 1516557.1)
Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12cR1 database (Doc ID 1585343.1)

No comments :

Post a Comment

Note: only a member of this blog may post a comment.