Upgrade PRODSRVR on PENRITH from 11.2.0.1 to 11.2.0.3 on Windows XP

Contents

  1. 1 Overview
  2. 2 Procedure
    1. 2.1 Welcome Screen
    2. 2.2 Select Database - Attempt #1
    3. 2.3 Clean Up Actions
      1. 2.3.1 Invalid Objects
      2. 2.3.2 Empty Recycle Bin
      3. 2.3.3 Configure Network ACLs
      4. 2.3.4 Collect Dicionary Statistics
      5. 2.3.5 Review Event Parameters
    4. 2.4 Select Database - Attempt #2
    5. 2.5 Step 1 of 5: Upgrade Options
    6. 2.6 Step 2 of 5: Move Database Files
    7. 2.7 Step 3 of 5: Recovery and Diagnostic Locations
    8. 2.8 Step 4 of 4: Summary

Overview

After having installed the 11.2.0.3.0 RDBMS Personal Edition as described in Install Oracle RDBMS 11.2.0.3.0 Without Grid Infrastructure on Windows XP , I upgraded the PRODSRVR database on PENRITH from 11.2.0.1.0 to 11.2.0.3.0 using the Database Upgrade Assistant.

Procedure

Ran the DBUA from the new 11.2.0.3.0 Oracle Home.

Welcome Screen

The following screen appeared:

DBUA Welcome Screen

Clicked Next .

Select Database - Attempt #1

The following screen appeared:

Select Database

Left the selection as PRODSRVR .

Clicked Next . The following screen appeared:

Which was followed by:

Clicked No .

Clean Up Actions

The following clean up actions were performed:

  • Invalid Objects
  • Empty Recycle Bin
  • Configure Network ACLs
  • Collect Dicionary Statistics
  • Review Event Parameters

Invalid Objects

Ran the following command under SQL*Plus to fix the invalid objects: 

@?/rdbms/admin/utlrp

The report said that:

OBJECTS WITH ERRORS 0
ERRORS DURING RECOMPILATION 0

Empty Recycle Bin

Ran the following command under SQL*Plus to empty the recycle bin: 

purge dba_recyclebin;

The response was: 

DBA Recyclebin purged.

Configure Network ACLs

I followed the procedure in Managing and Updating Access Control Lists and Network Utility Packages of the Oracle® Database Upgrade Guide 11g Release 2 (11.2) .

Since I do not use the network utility packages in the PRODSRVR database, I did not proceed any further.

Collect Dicionary Statistics

I followed the procedure in Collecting Statistics for System Component Schemas of the Oracle® Database Upgrade Guide 11g Release 2 (11.2) .

Review Event Parameters

This warning is bogus as there are no EVENT parameters set.

Select Database - Attempt #2

I wnt back to DBUA which was still open at the following screen:

Left the selection as PRODSRVR .

Clicked Next . The following screen appeared:

Which was followed by:

I clicked Yes to ignore these problems.

Step 1 of 5: Upgrade Options

The following screen appeared, and I selected the following options:

  • Recompile invalid object
  • Upgrade Timezone Version
  • Backup Database

Clicked Next . The following screen appeared:

Which was followed by:

I clicked Yes to ignore this advice.

Step 2 of 5: Move Database Files

The following screen appeared:

I left the selection as Do Not Move Database Files , and clicked Next .

Step 3 of 5: Recovery and Diagnostic Locations

The following screen appeared:

I clicked Next .

Step 4 of 4: Summary

The following screen appeared:

I clicked Finish , and the following screen appeared:

Which was followed by:

There was no DBConsole service running: 

C:\Documents and Settings\Douglas>net start|find /i "oracle"
   OracleMTSRecoveryService
   OracleOraDb11g_home1ConfigurationManager
   OracleOraDb11g_home2TNSListener
   OracleRemExecService
   OracleServicePRODSRVR

I clicked Continue .

After a while, I get the following error message:

I clicked OK , and the following screen appeared:

I clicked OK , and the following screen appeared:

I clicked Close , and and everything was done.