How to Upgrade to Oracle Database 11.1.0.7 from 11.1.0.6 in Oracle Applications 12.1.1

We are upgrading Oracle apps database to 11.1.0.7 from 11.1.0.6. 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 11.1.0.6 to 
11.1.0.7, 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.
#!/bin/sh
#Root script to run
<>/db/tech_st/11.1.0/root.sh
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:
SQL> SPOOL OFF


-------------------------------------------------------------------
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 COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
select * from v$version

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

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


Documents I followed ->
1. 11.1.0.7 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:

Post a Comment