How to Upgrade to Oracle Database from in Oracle Applications 12.1.1

We are upgrading Oracle apps database to from Our Oracle apps version was 12.1.1. Here are the steps we have done for that ->
Step 1
When upgrading directly from a 10.2 or 10.1 release or updating to, check the current version of the Oracle time zone definitions with the following command:
SELECT version FROM v$timezone_file;

our query reports version 4, so, no action is required.


Step 2

Run this query to know the invalid objects before db upgrade. Save the output in one csv file. You can compare this file with the invaid objects after db upgrade.

select object_name, owner, object_type from all_objects where status like 'INVALID';


Step 3

Shutdown the apps and database with listener.


Step 4

After proper modification on the response file[update all mandatory fields if value is not specified], ran  the following command to apply the patch.

<> /db_upgrade_11_1_0_7_patch/Disk1/runInstaller -silent -responseFile <>/db_upgrade_11_1_0_7_patch/Disk1/response/my_response.rsp

It will take approx. 10-15 mins.

Step 5

The following configuration scripts need to be executed as the "root" user.
#Root script to run
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts

Step 6

1. SQL> startup upgrade
Set the system to spool results to a log file for later analysis:
SQL> SPOOL upgrade_info.log
Run the Pre-Upgrade Information Tool:
SQL> @?/rdbms/admin/utlu111i.sql
Turn off the spooling of script results to the log file:

Step 7

Do the original upgrade.

SQL> spool upgrade_11_1_0_7.log
SQL> @?/rdbms/admin/catupgrd.sql


Step 8

Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> @?/rdbms/admin/utlrp.sql


Step 9

Check the version using following commands.

select * from v$version

The ideal output should be as follows ->
Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE      Production
TNS for Solaris: Version - Production
NLSRTL Version - Production


Documents I followed ->
1. Patch Set - Solaris (SPARC) 64bit README [ID 800551.1]
2. ALERT: Oracle 11g Release 1 (11.1) Support Status and Alerts [ID 454507.1]

No comments :