Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Checking for Invalid Database Objects - Oracle Upgrade

Hi All,

We upgrading our oracle database from

Hi All,

We are planning to upgrade oracle version 10.2.0.2.0 to Oracle patch set 10.2.0.5

As part of post upgrade steps I executed script utlu102i.sql to check for invalid database objects.

SQL> @utlu102i.sql

Oracle Database 10.2 Upgrade Information Utility 07-13-2011 11:20:26

.

**********************************************************************

Database:

**********************************************************************

--> name: D01

--> version: 10.2.0.2.0

--> compatible: 10.2.0

--> blocksize: 8192

.

**********************************************************************

Tablespaces: [make adjustments in the current environment]

**********************************************************************

--> SYSTEM tablespace is adequate for the upgrade.

.... minimum required size: 1100 MB

--> PSAPTEMP tablespace is adequate for the upgrade.

.... minimum required size: 58 MB

--> SYSAUX tablespace is adequate for the upgrade.

.... minimum required size: 479 MB

--> PSAPUNDO tablespace is adequate for the upgrade.

.... minimum required size: 3798 MB

.

**********************************************************************

Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

-- No update parameter changes are required.

.

**********************************************************************

Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

-- No renamed parameters found. No changes are required.

.

**********************************************************************

Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

-- No obsolete parameters found. No changes are required

.

**********************************************************************

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 contains INVALID objects prior to upgrade.

.... USER PUBLIC has 34 INVALID objects.

.... USER SYS has 4 INVALID objects.

.... USER SAPWEBUSR has 2 INVALID objects.

.... USER SAPR3 has 530 INVALID objects.

.

PL/SQL procedure successfully completed.

SQL> SPOOL OFF

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

Now I dont understand what we are supposed to do about these invalid objects.?

I checked SAP Note : 819830 , which then refers to sap note 1122956 to deal with Invalid Objects.

I checked SAP note 1122956 - ORA-24006: cannot create QUEUE

Which advises to execute script ORACLE_HOME/rdbms/admin/catproc

I ran this script and our put did not generated any errors.

So is that mean I dont need to do anything else with regards to these Invalid database objects?

Former Member
Not what you were looking for? View more on this topic or Ask a question