Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Oracle Data Pump: "PLS-00201: identifier 'RC' must be declared"

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    In trying to use the Oracle data pump to import some data (exported with data pump -- not as part of Upgrade Express but just to move the data to a different server) , I am receiving an "identifier 'RC' must be declared" error:

    Starting impdp_oracle_library_a
    Mon Apr 20 12:06:06 CDT 2009

    create_ora_user_b LAW60

    SQL*Plus: Release 10.2.0.4.0 - Production on Mon Apr 20 12:06:07 2009

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

    Enter user-name:
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    aleph_admin@A112_A18> EXIT
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64b
    it Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL*Plus: Release 10.2.0.4.0 - Production on Mon Apr 20 12:06:07 2009

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

    Enter user-name:
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    aleph_admin@A112_A18>
    User dropped.


    User created.


    Grant succeeded.

    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64b
    it Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    Directory LAW60_DIR already created

    Call completed.

    BEGIN rc('/bin/chmod +r /exlibris/aleph/u18_1/law60/files/dpdir/LAW6001.dmp.gz');
    END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'RC' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored


    BEGIN aleph_admin.call_os_cmd('/bin/gunzip /exlibris/aleph/u18_1/law60/files/dpd
    ir/LAW6001.dmp.gz'); END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'ALEPH_ADMIN.CALL_OS_CMD' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    Note: Prior to this, I did

    s+ ALEPH_ADMIN
    grant JAVA_ADMIN to aleph_admin WITH ADMIN OPTION;

    and the "select COMP_NAME,STATUS from dba_registry;" shows "JServer JAVA Virtual Machine" as valid.

    Resolution:
    The problem is that a key setup script had not been run on the database. To fix it, use the following commands:

    $ cd $aleph_proc
    $ sqlplus $ALEPH_ADMIN
    > @oracle_expdp_current_lib.sql

    This will create the necessary procedures and java utilities that are used by the impdb scripts. A call to run this SQL script is included in the *expdp* scripts and in the v.20 version of oracle_impdp_current_library_a, but is not included in the import scripts for previous versions.

    • Article last edited: 10/8/2013