OraFAQ Forum: Backup & Recovery » ORA-06508, ORA-06512 errors in Logical Backup

Home » RDBMS Server » Backup & Recovery » ORA-06508, ORA-06512 errors in Logical Backup (Oracle 10.2.0.1.0, Windows 2003 Server R2 Enterprize Edition)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-06508, ORA-06512 errors in Logical Backup [message #511421]

Mon, 13 June 2011 00:28

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Dear All,

I am exporting schemas. Whenever I export a schema, the logical backup (dmp file) is created with errors. The following Error is thrown. I need to know what step should I have to take to correct it. Can any one help me in this regard? I Thank well in advance.

EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_UTL"
ORA-06512: at "SYS.DBMS_REPCAT_EXP", line 87
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_EXP.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.

Thanks & Regards,
Artiste

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #511422 is a reply to message #511421]

Mon, 13 June 2011 00:35

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Hi All,

I want a clarification...

If I re-run Catalog.Sql, CatProc.SQL & PubBld.Sql, will it solve the problem?

Also I want to know that whether it is allowed (is it safe) to re-run the above 3 packages for the second time (after the database is created successfully)?

Thanks & Regards,

Artiste.

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #511441 is a reply to message #511422]

Mon, 13 June 2011 02:09

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Try to do it with catrep.sql.
You could also try to execute utlrp.sql and post the result.
Both as SYSDBA.

Regards
Michel

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #511484 is a reply to message #511441]

Mon, 13 June 2011 05:42

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Hi Michel,

Thanks for your response.

I tried executing Catrep.sql as Sysdba and tried exporting the schema, still the same error came.

Then I tried executing utlrp.sql as Sysdba and tried exporting the schema, still the same error came.

I am posting the log file here as requested.

Thanks a lot.

Regards,
Artiste

Attachment: UtlRp_Sql_Result.txt
(Size: 3.68KB, Downloaded 1740 times)

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #511487 is a reply to message #511484]

Mon, 13 June 2011 06:03

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I can't download files, please put it inside the post (without forgetting to format it, see How to use [code] tags and make your code easier to read.

Also post:

col object_name format a30
select owner, object_name, object_type, status 
from dba_objects where status != 'VALID'
order by 1, 2, 3
/

Regards
Michel

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #511813 is a reply to message #511487]

Wed, 15 June 2011 04:22

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Hi Michel,

Thanks for the guidance. As requested, the following is the result set from dba_Objects for Invalid Objects.

OWNER                          OBJECT_NAME                    OBJECT_TYPE         STATUS  
------------------------------ ------------------------------ ------------------- ------- 
PUBLIC                         DBA_HIST_ACTIVE_SESS_HISTORY   SYNONYM             INVALID 
PUBLIC                         DBA_HIST_DB_CACHE_ADVICE       SYNONYM             INVALID 
PUBLIC                         DBA_HIST_FILESTATXS            SYNONYM             INVALID 
PUBLIC                         DBA_HIST_LATCH                 SYNONYM             INVALID 
PUBLIC                         DBA_HIST_LATCH_MISSES_SUMMARY  SYNONYM             INVALID 
PUBLIC                         DBA_HIST_OSSTAT                SYNONYM             INVALID 
PUBLIC                         DBA_HIST_PARAMETER             SYNONYM             INVALID 
PUBLIC                         DBA_HIST_ROWCACHE_SUMMARY      SYNONYM             INVALID 
PUBLIC                         DBA_HIST_SEG_STAT              SYNONYM             INVALID 
PUBLIC                         DBA_HIST_SERVICE_STAT          SYNONYM             INVALID 
PUBLIC                         DBA_HIST_SERVICE_WAIT_CLASS    SYNONYM             INVALID 
PUBLIC                         DBA_HIST_SGASTAT               SYNONYM             INVALID 
PUBLIC                         DBA_HIST_SQLBIND               SYNONYM             INVALID 
PUBLIC                         DBA_HIST_SQLSTAT               SYNONYM             INVALID 
PUBLIC                         DBA_HIST_SYSSTAT               SYNONYM             INVALID 
PUBLIC                         DBA_HIST_SYSTEM_EVENT          SYNONYM             INVALID 
PUBLIC                         DBA_HIST_SYS_TIME_MODEL        SYNONYM             INVALID 
PUBLIC                         DBA_HIST_TABLESPACE_STAT       SYNONYM             INVALID 
PUBLIC                         DBA_HIST_WAITSTAT              SYNONYM             INVALID 
PUBLIC                         DBMS_DEFER                     SYNONYM             INVALID 
PUBLIC                         DBMS_DEFER_QUERY               SYNONYM             INVALID 
PUBLIC                         DEFCALL                        SYNONYM             INVALID 
SYS                            DBMS_ASYNCRPC_PUSH             PACKAGE BODY        INVALID 
SYS                            DBMS_DEFER                     PACKAGE             INVALID 
SYS                            DBMS_DEFER                     PACKAGE BODY        INVALID 
SYS                            DBMS_DEFERGEN_WRAP             PACKAGE BODY        INVALID 
SYS                            DBMS_DEFER_ENQ_UTL             PACKAGE             INVALID 
SYS                            DBMS_DEFER_ENQ_UTL             PACKAGE BODY        INVALID 
SYS                            DBMS_DEFER_INTERNAL_QUERY      PACKAGE BODY        INVALID 
SYS                            DBMS_DEFER_INTERNAL_SYS        PACKAGE BODY        INVALID 
SYS                            DBMS_DEFER_QUERY               PACKAGE             INVALID 
SYS                            DBMS_DEFER_QUERY               PACKAGE BODY        INVALID 
SYS                            DBMS_DEFER_QUERY_UTL           PACKAGE             INVALID 
SYS                            DBMS_DEFER_QUERY_UTL           PACKAGE BODY        INVALID 
SYS                            DBMS_DEFER_REPCAT              PACKAGE BODY        INVALID 
SYS                            DBMS_DEFER_SYS                 PACKAGE BODY        INVALID 
SYS                            DBMS_DEFER_SYS_PART1           PACKAGE BODY        INVALID 
SYS                            DBMS_REPCAT_UTL                PACKAGE BODY        INVALID 
SYS                            DBMS_REPCAT_UTL4               PACKAGE BODY        INVALID 
SYS                            DEFCALL                        VIEW                INVALID 
SYS                            LT                             PACKAGE             INVALID 
SYS                            LTADM                          PACKAGE             INVALID 
SYS                            LTDDL                          PACKAGE BODY        INVALID 
SYS                            LTRIC                          PACKAGE BODY        INVALID 
SYS                            OWM_REPUTIL                    PACKAGE BODY        INVALID 
SYS                            UD_TRIGS                       PACKAGE BODY        INVALID 
SYS                            WM_DDL_UTIL                    PACKAGE BODY        INVALID

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #511815 is a reply to message #511813]

Wed, 15 June 2011 04:25

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Hi Michel,

As requested I am pasting the result of the UTLRP.sql


SYS AS SYSDBA on 13-JUN-11.....> @D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\UtlRp.sql;

TIMESTAMP                                                                       
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2011-06-13 16:01:51                                   

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>	  number should decrease with time.
DOC>	     SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>	  should increase with time.
DOC>	     SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>	     SELECT job_name FROM dba_scheduler_jobs
DOC>		WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>	     SELECT job_name FROM dba_scheduler_running_jobs
DOC>		WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP                                                                       
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2011-06-13 16:03:23                                   


PL/SQL procedure successfully completed.

DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS                                                             
-------------------                                                             
                 99                                                             

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION                                                     
---------------------------                                                     
                          0                                                     


PL/SQL procedure successfully completed.

SYS AS SYSDBA on 13-JUN-11.....> spool off;

Thanks & Regds,
Artiste

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #511822 is a reply to message #511815]

Wed, 15 June 2011 04:35

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As far as I know the 7 last ones should be in WMSYS schema not SYS one.
Try to find in DBA_ERRORS if there is any useful information about these invalid package to know why they are invalid.

Regards
Michel

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #512135 is a reply to message #511822]

Fri, 17 June 2011 02:44

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Hi Michel,

sorry for the delayed reply. Thanks for your continued guidance. I am posting the result of DBA_ERRORS. Please copy this & paste it in a Notepad to get a neat formatted result.


OWNER	NAME				TYPE		SEQUENCE	LINE	POSITION	TEXT										    ATTRIBUTE	MESSAGE_NUMBER
______  _____________________________   ______________  ___________     _____   __________      _________________________________________________________________________________   _________   ______________
 
SYS	DBMS_ASYNCRPC_PUSH		PACKAGE BODY	5		683	10		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_ASYNCRPC_PUSH		PACKAGE BODY	6		676	3		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_ASYNCRPC_PUSH		PACKAGE BODY	3		673	39		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_ASYNCRPC_PUSH		PACKAGE BODY	7		700	39		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_ASYNCRPC_PUSH		PACKAGE BODY	8		700	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_ASYNCRPC_PUSH		PACKAGE BODY	1		521	39		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_ASYNCRPC_PUSH		PACKAGE BODY	2		521	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_ASYNCRPC_PUSH		PACKAGE BODY	4		673	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE		13		31	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		12		30	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE		11		30	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		10		29	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE		9		29	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		8		28	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE		7		28	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		6		27	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE		5		27	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		3		26	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		2		25	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE		1		25	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		14		31	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE		15		32	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		16		32	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE		17		33	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		18		33	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE		19		34	41		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER			PACKAGE		20		34	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER			PACKAGE BODY	2		1	14		PLS-00304: cannot compile body of 'DBMS_DEFER' without its specification		ERROR	304
SYS	DBMS_DEFER			PACKAGE BODY	1		1	14		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER			PACKAGE BODY	3		0	0		PL/SQL: Compilation unit analysis terminated						ERROR	0
SYS	DBMS_DEFER			PACKAGE		4		26	22		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFERGEN_WRAP		PACKAGE BODY	1		235	36		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFERGEN_WRAP		PACKAGE BODY	2		234	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_ENQ_UTL		PACKAGE		3		43	45		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_ENQ_UTL		PACKAGE BODY	3		0	0		PL/SQL: Compilation unit analysis terminated						ERROR	0
SYS	DBMS_DEFER_ENQ_UTL		PACKAGE		4		35	3		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER_ENQ_UTL		PACKAGE BODY	2		1	14		PLS-00304: cannot compile body of 'DBMS_DEFER_ENQ_UTL' without its specification	ERROR	304
SYS	DBMS_DEFER_ENQ_UTL		PACKAGE		2		22	3		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER_ENQ_UTL		PACKAGE		1		29	45		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_ENQ_UTL		PACKAGE BODY	1		1	14		PLS-00905: object SYS.DBMS_DEFER_ENQ_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	5		23	26		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	4		22	26		PL/SQL: Item ignored									ERROR	0
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	3		22	26		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	2		21	26		PL/SQL: Item ignored									ERROR	0
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	6		23	26		PL/SQL: Item ignored									ERROR	0
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	7		31	19		PLS-00320: the declaration of the type of this expression is incomplete or malformed	ERROR	320
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	8		28	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	9		42	47		PLS-00320: the declaration of the type of this expression is incomplete or malformed	ERROR	320
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	10		42	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	11		48	47		PLS-00320: the declaration of the type of this expression is incomplete or malformed	ERROR	320
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	13		54	39		PLS-00320: the declaration of the type of this expression is incomplete or malformed	ERROR	320
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	14		54	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	1		21	26		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_QUERY	PACKAGE BODY	12		48	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	20		586	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	19		586	5		PLS-00905: object SYS.DBMS_DEFER_ENQ_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	18		536	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	17		536	5		PLS-00905: object SYS.DBMS_DEFER_ENQ_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	16		486	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	15		486	5		PLS-00905: object SYS.DBMS_DEFER_ENQ_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	14		436	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	13		436	5		PLS-00905: object SYS.DBMS_DEFER_ENQ_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	12		371	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	11		371	35		PLS-00905: object SYS.DBMS_DEFER_ENQ_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	10		367	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	9		367	5		PLS-00320: the declaration of the type of this expression is incomplete or malformed	ERROR	320
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	8		353	10		PL/SQL: Item ignored									ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	7		353	10		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	6		313	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	5		313	5		PLS-00905: object SYS.DBMS_DEFER_ENQ_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	4		95	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE	BODY	3		95	39		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	2		66	10		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_INTERNAL_SYS		PACKAGE BODY	1		66	25		PLS-00905: object SYS.DBMS_DEFER_ENQ_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_QUERY		PACKAGE BODY	2		1	14		PLS-00304: cannot compile body of 'DBMS_DEFER_QUERY' without its specification		ERROR	304
SYS	DBMS_DEFER_QUERY		PACKAGE BODY	3		0	0		PL/SQL: Compilation unit analysis terminated						ERROR	0
SYS	DBMS_DEFER_QUERY		PACKAGE BODY	1		1	14		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_QUERY		PACKAGE		2		522	3		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER_QUERY		PACKAGE		1		526	19		PLS-00904: insufficient privilege to access object SYSTEM.REPCAT$_OBJECT_NULL_VECTOR	ERROR	904
SYS	DBMS_DEFER_QUERY_UTL		PACKAGE		1		280	19		PLS-00904: insufficient privilege to access object SYSTEM.REPCAT$_OBJECT_NULL_VECTOR	ERROR	904
SYS	DBMS_DEFER_QUERY_UTL		PACKAGE		2		279	3		PL/SQL: Declaration ignored								ERROR	0
SYS	DBMS_DEFER_QUERY_UTL		PACKAGE BODY	3		0	0		PL/SQL: Compilation unit analysis terminated						ERROR	0
SYS	DBMS_DEFER_QUERY_UTL		PACKAGE BODY	2		1	14		PLS-00304: cannot compile body of 'DBMS_DEFER_QUERY_UTL' without its specification	ERROR	304
SYS	DBMS_DEFER_QUERY_UTL		PACKAGE BODY	1		1	14		PLS-00905: object SYS.DBMS_DEFER_QUERY_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	5		783	45		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	9		817	10		PLS-00905: object SYS.DBMS_DEFER_QUERY_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	8		795	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	3		293	41		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	10		817	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	4		293	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	6		783	11		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	7		795	41		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	1		40	10		PLS-00905: object SYS.DBMS_DEFER_QUERY_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_REPCAT		PACKAGE BODY	2		40	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	1		294	17		PLS-00905: object SYS.DBMS_DEFER_QUERY_UTL is invalid					ERROR	905
SYS	DBMS_DEFER_SYS			PACKAGE BODY	2		294	14		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	3		516	20		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_SYS			PACKAGE BODY	4		516	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	5		524	16		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_SYS			PACKAGE BODY	6		524	9		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	7		526	17		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_SYS			PACKAGE BODY	20		1445	9		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	19		1453	25		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS			PACKAGE BODY	18		1379	10		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	17		1379	44		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS			PACKAGE BODY	16		1353	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	15		1353	41		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS			PACKAGE BODY	14		1075	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	13		1089	12		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS			PACKAGE BODY	12		1065	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	11		1065	41		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS			PACKAGE BODY	10		528	9		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	8		526	9		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS			PACKAGE BODY	9		528	20		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	8		146	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	9		183	20		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	10		183	11		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	11		185	21		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	12		185	11		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	13		187	25		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	14		187	11		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	15		299	52		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	16		299	9		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	17		308	52		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	18		308	9		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	19		316	52		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	20		316	9		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	1		58	29		PL/SQL: ORA-04063: view "SYS.DEFCALL" has errors					ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	2		54	5		PL/SQL: SQL Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	3		144	14		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	4		144	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	7		146	15		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	6		145	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_DEFER_SYS_PART1		PACKAGE BODY	5		145	15		PLS-00905: object SYS.DBMS_DEFER_QUERY is invalid					ERROR	905
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	7		3066	7		PLS-00905: object SYS.DBMS_DEFER_QUERY_UTL is invalid					ERROR	905
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	6		3064	5		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	5		3064	15		PLS-00905: object SYS.DBMS_DEFER_QUERY_UTL is invalid					ERROR	905
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	4		3050	11		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	3		3050	11		PLS-00905: object SYS.DBMS_DEFER_QUERY_UTL is invalid					ERROR	905
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	2		3048	9		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	1		3048	9		PLS-00905: object SYS.DBMS_DEFER_QUERY_UTL is invalid					ERROR	905
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	10		3068	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	9		3068	7		PLS-00905: object SYS.DBMS_DEFER_QUERY_UTL is invalid					ERROR	905
SYS	DBMS_REPCAT_UTL			PACKAGE BODY	8		3066	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_REPCAT_UTL4		PACKAGE BODY	2		940	7		PL/SQL: Statement ignored								ERROR	0
SYS	DBMS_REPCAT_UTL4		PACKAGE BODY	1		940	41		PLS-00905: object SYS.DBMS_DEFER is invalid						ERROR	905
SYS	DEFCALL				VIEW		1		0	0		"ORA-06575: Package or function DBMS_DEFER_QUERY_UTL is in an invalid state"		ERROR	0
SYS	LT				PACKAGE		2		1033	37		PL/SQL: Declaration ignored								ERROR	0
SYS	LT				PACKAGE		1		1033	52		PLS-00904: insufficient privilege to access object WMSYS.TRIGOPTIONSTYPE		ERROR	904
SYS	LTADM				PACKAGE		3		109	41		PLS-00904: insufficient privilege to access object WMSYS.OPER_LOCKVALUES_ARRAY_TYPE	ERROR	904
SYS	LTADM				PACKAGE		4		109	26		PL/SQL: Declaration ignored								ERROR	0
SYS	LTADM				PACKAGE		6		182	29		PL/SQL: Declaration ignored								ERROR	0
SYS	LTADM				PACKAGE		7		907	17		PLS-00904: insufficient privilege to access object WMSYS.WM$CONFLICT_PAYLOAD_TYPE	ERROR	904
SYS	LTADM				PACKAGE		8		904	3		PL/SQL: Declaration ignored								ERROR	0
SYS	LTADM				PACKAGE		9		908	39		PLS-00904: insufficient privilege to access object WMSYS.WM$CONFLICT_PAYLOAD_TYPE	ERROR	904
SYS	LTADM				PACKAGE		10		908	3		PL/SQL: Declaration ignored								ERROR	0
SYS	LTADM				PACKAGE		2		85	23		PL/SQL:	Declaration ignored								ERROR	0
SYS	LTADM				PACKAGE		1		85	29		PLS-00904: insufficient privilege to access object WMSYS.INTTOSTR_ARRAY_TYPE		ERROR	904
SYS	LTADM				PACKAGE		5		182	44		PLS-00904: insufficient privilege to access object WMSYS.OPER_LOCKVALUES_ARRAY_TYPE	ERROR	904
SYS	LTDDL				PACKAGE BODY	5		116	34		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTDDL				PACKAGE BODY	11		159	8		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	LTDDL				PACKAGE BODY	10		134	8		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	9		134	36		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTDDL				PACKAGE BODY	8		132	8		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	7		132	36		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTDDL				PACKAGE BODY	6		116	6		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	12		159	4		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	13		169	8		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	LTDDL				PACKAGE BODY	14		169	4		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	15		235	8		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	LTDDL				PACKAGE BODY	16		235	4		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	17		240	8		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	LTDDL				PACKAGE BODY	18		240	4		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	19		337	8		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	LTDDL				PACKAGE BODY	20		337	4		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	1		100	35		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTDDL				PACKAGE BODY	2		100	7		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	4		104	4		PL/SQL: Statement ignored								ERROR	0
SYS	LTDDL				PACKAGE BODY	3		104	8		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	LTRIC				PACKAGE BODY	20		2158	10		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	1		317	40		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTRIC				PACKAGE BODY	18		1836	16		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	17		1836	44		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTRIC				PACKAGE BODY	16		1835	16		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	15		0	0		PLS-00907: cannot load library unit SYS.LTADM (referenced by SYS.LTDDL)			ERROR	907
SYS	LTRIC				PACKAGE BODY	14		1828	13		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	13		1828	41		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTRIC				PACKAGE BODY	12		1827	13		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	11		0	0		PLS-00907: cannot load library unit SYS.LTADM (referenced by SYS.LTDDL)			ERROR	907
SYS	LTRIC				PACKAGE BODY	10		1819	19		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	9		1819	47		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTRIC				PACKAGE BODY	8		1793	13		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	7		1793	36		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	LTRIC				PACKAGE BODY	6		1557	9		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	5		1557	18		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTRIC				PACKAGE BODY	4		584	8		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	3		584	36		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	LTRIC				PACKAGE BODY	2		317	12		PL/SQL: Statement ignored								ERROR	0
SYS	LTRIC				PACKAGE BODY	19		2158	19		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	3		55	48		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	4		55	3		PL/SQL: Item ignored									ERROR	0
SYS	OWM_REPUTIL			PACKAGE BODY	1		33	53		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	20		469	19		PL/SQL: Item ignored									ERROR	0
SYS	OWM_REPUTIL			PACKAGE BODY	19		469	23		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	18		346	10		PL/SQL: Statement ignored								ERROR	0
SYS	OWM_REPUTIL			PACKAGE BODY	17		346	38		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	16		218	8		PL/SQL: Statement ignored								ERROR	0
SYS	OWM_REPUTIL			PACKAGE BODY	15		218	36		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	14		212	8		PL/SQL:	Statement ignored								ERROR	0
SYS	OWM_REPUTIL			PACKAGE BODY	13		212	36		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	12		205	8		PL/SQL: Statement ignored								ERROR	0
SYS	OWM_REPUTIL			PACKAGE BODY	11		205	36		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	10		96	3		PL/SQL: Item ignored									ERROR	0
SYS	OWM_REPUTIL			PACKAGE BODY	9		97	19		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	8		77	3		PL/SQL: Item ignored									ERROR	0
SYS	OWM_REPUTIL			PACKAGE BODY	7		82	35		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	6		64	3		PL/SQL: Item ignored									ERROR	0
SYS	OWM_REPUTIL			PACKAGE BODY	5		69	54		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	OWM_REPUTIL			PACKAGE BODY	2		29	3		PL/SQL: Item ignored									ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	20		761	8		PL/SQL: Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	1		501	11		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	UD_TRIGS			PACKAGE BODY	18		754	8		PL/SQL: Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	17		754	12		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	UD_TRIGS			PACKAGE BODY	16		747	5		PL/SQL: Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	15		747	9		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	UD_TRIGS			PACKAGE BODY	14		552	15		PL/SQL: Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	13		552	19		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	UD_TRIGS			PACKAGE BODY	12		551	15		PL/SQL: Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	11		0	0		PLS-00907: cannot load library unit SYS.LTADM (referenced by SYS.LTDDL)			ERROR	907
SYS	UD_TRIGS			PACKAGE BODY	10		540	7		PL/SQL:	Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	9		540	11		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	UD_TRIGS			PACKAGE BODY	8		527	9		PL/SQL: Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	7		527	13		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	UD_TRIGS			PACKAGE BODY	6		516	9		PL/SQL: Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	5		516	13		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	UD_TRIGS			PACKAGE BODY	4		510	9		PL/SQL: Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	3		510	13		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	UD_TRIGS			PACKAGE BODY	2		501	7		PL/SQL:	Statement ignored								ERROR	0
SYS	UD_TRIGS			PACKAGE BODY	19		761	12		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	8		366	10		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	9		391	35		PLS-00905: object SYS.LT is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	6		339	6		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	5		339	13		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	4		312	6		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	3		312	10		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	2		114	5		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	1		114	9		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	20		517	5		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	19		517	9		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	18		474	5		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	17		474	9		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	16		471	5		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	15		471	9		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	14		467	7		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	13		467	11		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	12		460	5		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	11		460	9		PLS-00905: object SYS.LTADM is invalid							ERROR	905
SYS	WM_DDL_UTIL			PACKAGE BODY	10		391	7		PL/SQL: Statement ignored								ERROR	0
SYS	WM_DDL_UTIL			PACKAGE BODY	7		366	38		PLS-00905: object SYS.LT is invalid							ERROR	905

Regards,,
Artiste

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #512140 is a reply to message #512135]

Fri, 17 June 2011 03:00

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It seems that the errors come from the wrong schema for the object I mentioned in my previous post.

Regards
Michel

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #512148 is a reply to message #512140]

Fri, 17 June 2011 03:42

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Hi Michel,

Thanks for the reply. Can you please tell me what step should i need to take next?

Thanks & Regds,
Artiste

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #512152 is a reply to message #512148]

Fri, 17 June 2011 04:23

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is a bit risky.
What kind of database is this? (production, test, training...)
Have you important data in there? Have you any client data?

Regards
Michel

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #512162 is a reply to message #512152]

Fri, 17 June 2011 04:59

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Hi Michel,

Thanks for the response. It is production database and clients' data is there.

If you can guide me, then we can plan for a downtime on this sunday and do the necessary steps to rectify it.

Thanks & Regds,
Artiste

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #512163 is a reply to message #512162]

Fri, 17 June 2011 05:09

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is the size of the database (sum of customer tablespaces)?

Regards
Michel

[Updated on: Fri, 17 June 2011 05:10]

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #512287 is a reply to message #512163]

Fri, 17 June 2011 23:15

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Hi Michel,

Thanks for the reply. The size of the database is around 70GB and the size of the Customer's data is around 15GB.

Thanks & Regards,
Artiste

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #512293 is a reply to message #512287]

Sat, 18 June 2011 02:02

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I advise you to export the customer schemas, using DataPump, drop the databasae, recreate it and import the customer schema.
If the first export returns errors then exclude them from the export and retry, and so on till it works.
This is the safe way.

The other one, not safe, is to execute, as SYS, %ORACLE_HOME%\rdbms\admin\owminst.plb.
If there are too much errors, retry executing first owmremov.sql, then owminst.plb.
After that, drop the object in SYS schema that are also in WMSYS and execute utlrp.sql.
I repeat this is not a safe way.

Both must be done without any other connection that yours
=> shutdown immediate, startup restrict.

Regards
Michel

[Updated on: Sat, 18 June 2011 02:03]

Report message to a moderator

Re: ORA-06508, ORA-06512 errors in Logical Backup [message #512627 is a reply to message #512293]

Tue, 21 June 2011 04:24

artisteprasanna
Messages: 15
Registered: July 2010

Junior Member

Dear Michel,

Sorry for giving you a late response. I will do the same as you have guided. I will take a Shutdown and then try it and then I will update you. Thanks a lot for your excellent guidance.

Thanks & Regds,
Artiste

Report message to a moderator

Previous Topic:	RMAN Not seeing backupsets
Next Topic:	Trying to restore RMAN backup in new server, got error RMAN-06172

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 02:46:54 CDT 2024