Oracle Data Pump: "PLS-00201: identifier 'RC' must be declared"
- 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