Oracle eBusiness 12.1.3 to 12.2.5 upgrade - Part 1 (Finalizing Path and DB Upgrade)

We have to first be on 12.2 to move to any version ahead of it.

The supported paths till the time I did the upgrade were as below.

Direct upgrade for 11.5.10.2 to 12.2

Direct upgrade for 12.0 or 12.1 to 12.2.

The database supported were 11.2.0.4 or 12c.

The first step has been the database upgrade. The upgrade is simple database upgrade with DBUA so I am listing just the major steps to be taken care with EBS. 

Please go through Interoperability notes for exact steps for your environments.

1. Install the Database Binaries.

2. Update to latest OPatch

3. Follow the interoperability notes to apply additional DB patches. This will save time later.

4. Shutdown application.

5. Drop SYS.ENABLED$INDEXES 

SQL> drop table sys.enabled$indexes;

6. Remove the MGDSYS schema

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

7. Execute Dictionary stats.

SQL> EXECUTE dbms_stats.gather_dictionary_stats;

8. In case of RAC, Run Cluster Verify.

$ cd $ORACLE_HOME/bin

$ cluvfy stage  -pre dbinst -upgrade  

-src_dbhome  <11gHOME>

          -dest_dbhome <12cHOME> 

           -dest_version 12.1.0.2.0

9. Run pre upgrade Script.

$ sqlplus / sysdba

SQL> @preupgrd.sql;

Fix if there are any issue.

10. Upgrade DST in new home.

Check existing DST and default DST that comes with new Orale 12c home.

SQL> SELECT * FROM v$timezone_file;

 FILENAME                VERSION

-------------------- ----------

timezlrg_23.dat              23

Apply DST patch in new home,

Applying the DSTv23 update for the Oracle Database (Doc ID 1907093.1)

Sec. 2) Oracle RDBMS 12cR1 : Applying the RDBMS DSTv23 patch 19396455 on Oracle RDBMS 12cR1 ( 12.1.0.1 and 12.1.0.2) .

11. Purge Audit records

SQL> truncate table sys.aud$; 

SQL> truncate table sys.fga_log$;

12. Enterprise Manager Database Control

SQL> rdbms/admin/emremove.sql;

13. Copy the old tns_admin to new tns_admin, if you do not want to change anything in ports.

14. Make sure application has been shutdown.

15. Start the upgrade.

16. Run datapatch as post step of patches applied.

$ORACLE_HOME/OPatch/datapatch

17. Change init parameters following the interoperability notes.

18. Modify listeners to move to new Oracle Home.
srvctl stop listener -l <ListenerName>

srvctl modify listener -l <ListenerName> -o <12cHome>

srvctl start listener -l <ListenerName>

19. Copy script from $APPL_TOP/admin/adgrants.sql and run as sysdba

20. CTXSYS procedure

copy $AD_TOP/patch/115/sql/adctxprv.sql  to database server.

Run following from the database server where the file is placed.
$ sqlplus apps/$appspass @adctxprv.sql $SYSTEM_PASS CTXSYS


Then connect as sysdba and run following.
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');

21. Workflow Rule set Validation.Run $FND_TOP/patch/115/sql/wfaqupfix.sql from application server.

$ sqlplus [APPS user]/[APPS password] @wfaqupfix.sql [APPLSYS user] [APPS user]

22. Run adstats

$ sqlplus "/ as sysdba"

SQL> alter system enable restricted session;

SQL> @adstats.sql

$ sqlplus "/ as sysdba"

SQL> alter system disable restricted session;

SQL> exit;

23. Implement and Run autoconfig.

Create appsutil.zip using perl $AD_TOP/bin/admkappsutil.pl

Unzip that on Database Oracle Home.

24. Copy orai18n.jar

$ cp $ORACLE_HOME/jlib/orai18n.jar $ORACLE_HOME/jdk/jre/lib/ext/

After creating the XML context file, ensure the variable s_jretop points to $ORACLE_HOME/jdk/jre and is not altered to any other value.

25. Create MGDSYS schema.
$ sqlplus "/ as sysdba" @?/rdbms/admin/catmgd.sql

25. Start Application and Validate.

The DB upgrade completes here, there may be some patches for 12c and for pre 12.2 need to be applied on same application here.

Also follow relevant documents for database, OS, Platform/Storage and eBusiness versions for exact patches to be applied on DB.

Click on below link for Next Part.

Oracle eBusiness 12.1.3 to 12.2.5 upgrade - Part 2 (Upgrade to 12.2)