Oracle Database Discussions

Hi All,

I am a newbie here, attempting to upgrade DB 10.2.0.5.0 to 11.2.0.3.0 which is running on Microsoft Windows (32-bit).

Below are the steps I had performed:

1: Install Oracle 11G Release 2

2: Check for invalid objects:
SQL> select unique OBJECT_NAME, OBJECT_TYPE, OWNER
from DBA_OBJECTS
where STATUS='INVALID';

If there are invalid objects, recompile invalid objects with utlrp.sql:
SQL> @?/rdbms/admin/utlrp.sql;

3: Check for duplicate objects:
SQL> select OBJECT_NAME, OBJECT_TYPE
from DBA_OBJECTS
where OBJECT_NAME||OBJECT_TYPE in
(select OBJECT_NAME||OBJECT_TYPE
from DBA_OBJECTS
where OWNER='SYS')
and OWNER='SYSTEM'
and OBJECT_NAME not in
('AQ$_SCHEDULES_PRIMARY', 'AQ$_SCHEDULES',
'DBMS_REPCAT_AUTH');

4: Check for invalid components:
SQL> select substr(COMP_ID, 1, 10) compid,
substr(COMP_NAME, 1, 24) compname, STATUS, VERSION
from DBA_REGISTRY
where STATUS<>'VALID';

5: Purge the recyclebin:
SQL> purge DBA_RECYCLEBIN;

6: Run the pre-upgrade script:
SQL> @?/rdbms/admin/PreUpgrade/utlu112i_5.sql;


Below is the result of the pre-upgrade script:

***********************************************************************
Tablespaces: [make adjustments in the current environment]
***********************************************************************
WARNING: --> SYSTEM tablespace is not large enough for the upgrade.
.... currently allocated size: 491 MB
.... minimum required size: 493 MB
.... increase current size by: 2 MB
.... tablespace is AUTOEXTEND ENABLED.
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 222 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 MB
.
***********************************************************************
Rollback Segments: [make adjustments immediately prior to upgrading]
***********************************************************************
--> R0 in tablespace SYSTEM is OFFLINE; AUTOEXTEND is OFF
.... currently allocated: 7168K
.... next extent size: 32K; max extents: 32765
--> R1 in tablespace RBS_1 is ONLINE; AUTOEXTEND is OFF
.... currently allocated: 8192K
.... next extent size: 4096K; max extents: 32765
--> R2 in tablespace RBS_2 is ONLINE; AUTOEXTEND is OFF
.... currently allocated: 8192K
.... next extent size: 4096K; max extents: 32765
--> R3 in tablespace RBS_3 is ONLINE; AUTOEXTEND is OFF
.... currently allocated: 8192K
.... next extent size: 4096K; max extents: 32765
--> R4 in tablespace RBS_4 is ONLINE; AUTOEXTEND is OFF
.... currently allocated: 8192K
.... next extent size: 4096K; max extents: 32765
WARNING: --> For the upgrade, use a large (minimum 70M) public rollback segment
WARNING: --> Take smaller public rollback segments OFFLINE
.
***********************************************************************
Flashback: OFF
***********************************************************************
***********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool was run on a lower version 32-bit database.
***********************************************************************
--> If Target Oracle is 32-Bit, refer here for Update Parameters:
WARNING: --> "shared_pool_size" needs to be increased o at least 236 MB
WARNING: --> "undo_management" is not defined and must have a value=MANUAL
.
--> If Target Oracle is 64-Bit, refer here for Update Parameters:
WARNING: --> "shared_pool_size" needs to be increased o at least 472 MB
WARNING: --> "undo_management" is not defined and must have a value=MANUAL
.
***********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]
***********************************************************************
-- No renamed parameters found. No changes are required.
.
***********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]

***********************************************************************
--> background_dump_test 11.1 DEPRECATED replaced by "diagnostic_dest"
--> user_dump_dest 11.1 DEPRECATED replaced by "diagnostic_dest"
.
***********************************************************************
Components: [The following database components will be upgraded or installed]
***********************************************************************
--> Oracle Catalog Views [Upgrade] VALID
--> Oracle Packages and Types [Upgrade] VALID
.
***********************************************************************
Miscellaneous Warnings
***********************************************************************
WARNING: --> Database is using a timezone file older than version 14.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 10.2.0.5.0 database timezone version
.... to the latest version which comes with the new release.
WARNING: --> Your recycle bin is turned on and currently contains no objects.
.... Because it is REQUIRED that the recycle bin be empty prior to upgrading
.... and your recycle bin is turned on, you may need to execute the command:
PURGE DBA_RECYCLEBIN
.... prior to executing your upgrade to confirm the recycle in is empty.
.


Currently, I am in a dilemma in solving the above mentioned warnings. Can anyone kindly guide me?

Thank you in advanced.

Edited by: Maxwell T on Nov 27, 2012 6:32 PM