Datapump doesn't run because of LCR errors

From: <fraund_at_uiuc.edu>
Date: 10 Jan 2006 16:52:26 -0800
Message-ID: <1136940746.667979.205240@g44g2000cwa.googlegroups.com>

Hello,

I am having problems finding similar errors on the web. I am interested in using Datapump (Oracle 10g) for nightly backup with a simple database. I was trying out a Datapump example and got errors which I traced to LCR$_DDL_RECORD and LCR$_ROW_RECORD missing definitions (PLS-00201 and PLS-00304) which affect the whole streams class. I've read about constructors for these in Oracle documentation, but I'm unsure of how to proceed.

Has anyone encountered this problem/type of problem before or can you guide me to a posted example/solution? What would cause it and what do I need to do to repair it? Following is a log of work on this issue. Thanks much in advance for help,

Philipp

$ expdp (login/password) DUMPFILE=export_dir:testdump.dmp LOGFILE=export_dir:testdump.explog

Export: Release 10.1.0.3.0 - Production on Sunday, 11 December, 2005 21:59

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

ORA-39004: invalid state
ORA-39091: unable to determine logical standby and streams status
ORA-04063: package body "SYS.DBMS_STREAMS_DATAPUMP" has errors
ORA-06508: PL/SQL: could not find program unit being called

SQL> EXEC UTL_RECOMP.recomp_serial();

PL/SQL procedure successfully completed.

SQL> COLUMN object_name FORMAT A30
SELECT owner,

       object_type,
       object_name,
       status

FROM dba_objects
WHERE status = 'INVALID'
ORDER BY owner, object_type, object_name;SQL> 2 3 4 5 6  7

PUBLIC                         SYNONYM             DBMS_STREAMS
          INVALID
SYS                            PACKAGE             DBMS_REPCAT_RGT_UTL
          INVALID
SYS                            PACKAGE             DBMS_STREAMS
          INVALID
SYS                            PACKAGE BODY        DBMSOBJGWRAPPER
          INVALID
SYS                            PACKAGE BODY        DBMS_CDC_IPUBLISH
          INVALID
SYS                            PACKAGE BODY        DBMS_IAS_INST
          INVALID
SYS                            PACKAGE BODY        DBMS_IAS_INST_UTL
          INVALID
SYS                            PACKAGE BODY
DBMS_IAS_INST_UTL_EXP          INVALID
SYS                            PACKAGE BODY        DBMS_IAS_MT_INST
          INVALID
SYS                            PACKAGE BODY        DBMS_IAS_TEMPLATE
          INVALID
SYS                            PACKAGE BODY
DBMS_IAS_TEMPLATE_INTERNAL     INVALID
SYS                            PACKAGE BODY
DBMS_IAS_TEMPLATE_UTL          INVALID
SYS                            PACKAGE BODY        DBMS_LOGREP_IMP
          INVALID
SYS                            PACKAGE BODY        DBMS_OFFLINE_OG
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT
          INVALID
SYS                            PACKAGE BODY
DBMS_REPCAT_ADD_MASTER         INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_CONF
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_FLA_MAS
          INVALID
SYS                            PACKAGE BODY
DBMS_REPCAT_INSTANTIATE        INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_MAS
          INVALID
SYS                            PACKAGE BODY
DBMS_REPCAT_MIG_INTERNAL       INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_RGT
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_RGT_ALT
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_RGT_CHK
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_RGT_CUST
          INVALID
SYS                            PACKAGE BODY
DBMS_REPCAT_RGT_CUST2          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_RGT_UTL
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_RPC
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_RQ
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_UTL2
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_UTL3
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_UTL4
          INVALID
SYS                            PACKAGE BODY        DBMS_REPCAT_VALIDATE
          INVALID
SYS                            PACKAGE BODY        DBMS_STREAMS
          INVALID
SYS                            PACKAGE BODY
DBMS_STREAMS_DATAPUMP          INVALID
SYS                            PACKAGE BODY        DBMS_STREAMS_TBS_INT
          INVALID
SYS                            PACKAGE BODY
DBMS_STREAMS_TBS_INT_INVOK     INVALID
SYS                            TYPE BODY           LCR$_DDL_RECORD
          INVALID
SYS                            TYPE BODY           LCR$_ROW_RECORD
          INVALID

SQL> alter package DBMS_STREAMS_DATAPUMP compile body;

Warning: Package Body altered with compilation errors.

SQL> sho err
Errors for PACKAGE BODY DBMS_STREAMS_DATAPUMP:

113/5 PL/SQL: Statement ignored
113/5 PLS-00905: object SYS.DBMS_STREAMS is invalid

SQL> alter package DBMS_STREAMS compile;

Warning: Package altered with compilation errors.

SQL> sho err
Errors for PACKAGE DBMS_STREAMS:

20/3     PL/SQL: Declaration ignored
20/66    PLS-00201: identifier 'SYS.LCR$_ROW_RECORD' must be declared
23/3     PL/SQL: Declaration ignored
24/12    PLS-00201: identifier 'SYS.LCR$_DDL_RECORD' must be declared

SQL> alter type LCR$_DDL_RECORD compile body;

Warning: Type Body altered with compilation errors.

SQL> sho err
Errors for TYPE BODY LCR$_DDL_RECORD:

0/0      PL/SQL: Compilation unit analysis terminated
1/11     PLS-00201: identifier 'LCR$_DDL_RECORD' must be declared
1/11     PLS-00304: cannot compile body of 'LCR$_DDL_RECORD' without
its
         specification

Received on Tue Jan 10 2006 - 18:52:26 CST