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
|
|
|
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.
|
|
|
|
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
|
|
|
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: 68675 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
|
|
|
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
|
|
|
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
|
|
|
|
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
|
|
|
|
|
|
|
|
|
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: 68675 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
|
|
|
|