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.
Ran the DBUA from the new 11.2.0.3.0 Oracle Home.
The following screen appeared:
Clicked Next.
The following screen appeared:
Left the selection as PRODSRVR
.
Clicked Next. The following screen appeared:
Which was followed by:
Clicked No.
The following clean up actions were performed:
Invalid Objects
Ran the following command under SQL*Plus to fix the invalid objects:
@?/rdbms/admin/utlrp
The report said that:
OBJECTS WITH ERRORS
ERRORS DURING RECOMPILATION
0
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.
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.
The following screen appeared, and I selected the following options:
Clicked Next. The following screen appeared:
Which was followed by:
I clicked Yes to ignore this advice.
The following screen appeared:
I left the selection as Do Not Move Database Files, and clicked Next.
The following screen appeared:
I clicked Next.
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.