Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10.2 Upgrade Information Utility

Re: 10.2 Upgrade Information Utility

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 16 Dec 2005 12:03:38 +0100
Message-ID: <mi75q1lfto22n99a8em0k04i32su3drhvc@4ax.com>


On 16 Dec 2005 02:38:32 -0800, "News" <Contact_404_at_hotmail.com> wrote:

>Oracle Database 10.2 Upgrade Information Utility 'utlu102i.sql'
>displayed
>
>Database:
>
>**********************************************************************
>
>--> version: 9.2.0.4.0
>
>--> compatible: 9.2.0.0.0
>
>
>Tablespaces: [make adjustments in the current environment]
>
>**********************************************************************
>
>WARNING: --> TEMP tablespace is not large enough for the upgrade.
>
>.... currently allocated size: 0 MB
>
>.... minimum required size: 58 MB
>
>.... increase current size by: MB
>
>.... tablespace is NOT AUTOEXTEND ENABLED.
>
>
>
>1. TEMP tablespace is 32 GB. How much do I need to increase it ?

Read the last line carefully.

Alter database datafile|tempfile '<filename>' autoextend on next ...M max ... M

>
>**********************************************************************
>
>Miscellaneous Warnings
>
>**********************************************************************
>
>.... USER SYSTEM has 6 INVALID objects.
>
>
>2. how to know which objects are invalid and how to correct problem ?

just run @?/rdbms/admin/utlrp from sqlplus connect as SYS. If you still have invalid objects
select owner, object_name, object_type
from dba_objects
where status = 'INVALID'

issue the appropiate ALTER <object_type> <owner>.<object_name> compile command to rectify this.
Pretty basic stuff for a DBA

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Dec 16 2005 - 05:03:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US