10.2 Upgrade Information Utility
in [Oracle]
|
Prev: rman restore procedure
Next: Error
From: News on 16 Dec 2005 05:38 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 ? ********************************************************************** Miscellaneous Warnings ********************************************************************** ..... USER SYSTEM has 6 INVALID objects. 2. how to know which objects are invalid and how to correct problem ?
From: Sybrand Bakker on 16 Dec 2005 06:03 On 16 Dec 2005 02:38:32 -0800, "News" <Contact_404(a)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
From: News on 19 Dec 2005 03:57 Sybrand Bakker a écrit : > 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 I have done this but still have problems with these packages that prevents me from upgrading from 9.2.0.4 to 10gr2 OWNER OBJECT_NAME OBJECT_TYPE -------------------------------------------------------------------------------------------------- SYSTEM DBMS_DDL PACKAGE BODY SYSTEM DBMS_DDL_INTERNAL PACKAGE BODY SYSTEM DBMS_PCLXUTIL PACKAGE BODY SYSTEM DBMS_TRANSACTION PACKAGE BODY SYSTEM DBMS_TRANSACTION_INTERNAL_SYS PACKAGE BODY SYSTEM DBMS_UTILITY PACKAGE BODY
From: DA Morgan on 19 Dec 2005 12:11 News wrote: > Sybrand Bakker a ?crit : > > >>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 > > > I have done this but still have problems with these packages that > prevents me from upgrading from 9.2.0.4 to 10gr2 > > > OWNER OBJECT_NAME OBJECT_TYPE > -------------------------------------------------------------------------------------------------- > SYSTEM DBMS_DDL PACKAGE BODY > SYSTEM DBMS_DDL_INTERNAL PACKAGE BODY > SYSTEM DBMS_PCLXUTIL PACKAGE BODY > SYSTEM DBMS_TRANSACTION PACKAGE BODY > SYSTEM DBMS_TRANSACTION_INTERNAL_SYS PACKAGE BODY > SYSTEM DBMS_UTILITY PACKAGE BODY Log on as SYS SQL> / as sysdba try recompiling a single one of these objects SQL> alter package dbms_ddl compile; When the error occurs do the following SQL> show error Take the entire screen and copy it and post it here. Though I would think a smarter thing to do would be to open an iTAR at http://metalink.oracle.com. -- Daniel A. Morgan http://www.psoug.org damorgan(a)x.washington.edu (replace x with u to respond)
From: bdbafh on 19 Dec 2005 13:44
Those packages do not belong in the system schema. Methinks that you executed something at some point connected as system, when you should have connected as "sys as sysdba". I believe that you will find that such objects ALSO exist in the SYS schema, except that over there, they are valid. drop the invalid ones that are wrongly owned by the user system. -bdbafh |