Oracle DBA Tips and Techniques

By Arjun Raja

Archive for March, 2013

IMPDP FAILS IN DATABASE WITHOUT OLAP – ‘DBMS_CUBE_EXP.SCHEMA_INFO_IMP_BEG’ must be declared

Posted by Arjun Raja on March 19, 2013

Export taken from database with OLAP – 11.1.0.7 database

While importing the exported dump into a 11.2.0.3 database – following warnings appear –

ORA-39083: Object type PROCACT_SCHEMA failed to create with error: ORA-06550: line 2, column 1:
PLS-00201: identifier ‘DBMS_CUBE_EXP.SCHEMA_INFO_IMP_BEG’ must be declared ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 1:
PLS-00201: identifier ‘DBMS_CUBE_EXP.SCHEMA_INFO_IMP_LOOP’ must be declared ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
ORA-06550: line 8, column 1:
PLS-00201: identifier ‘DBMS_CUBE_EXP.SCHEMA_INFO_IMP_END’ must be declared

The above are just warnings and can be ignored if OLAP is not required.

But if you prefer a clean import without all this clutter and provided OLAP is not required then

Export the data in the source 11g database with the following option added to the expdp command

VERSION=10.2

Example of parameter file for export –

directory=data_pump_dir
dumpfile=schemaowner.dmp
logfile=schemaowner.log
CONTENT=ALL
SCHEMAS=SCHEMAOWNER
VERSION=10.2

Warning -If VERSION=10.2 is used, the COMPRESSION=ALL cannot be used in the parameter file….Therefore the export dump size will be much larger.

The dump above can be imported into the 11.2.0.3 database which does not have OLAP – no warnings will be displayed.

Posted in Uncategorized | Leave a Comment »

emctl config agent addinternaltargets – to discover targets manually in Oracle 12c Cloud Control

Posted by Arjun Raja on March 18, 2013

If for any reason you lose an agent in the cloud console area and want to discover targets manually from the command line- login to the agent server and run the following from the agent home/bin

This is a replacement for the agentca -d command issued in Oracle 10g and 11g grid control.

cd $AGENT_HOME/bin

1. Stop and start the OMS:

./emctl stop oms

./emctl start oms

2. Secure the Management Agent:

./emctl secure agent

3. Add the targets:

./emctl config agent addinternaltargets

4. Upload the targets:

./emctl upload agent

Posted in EM Grid Control, Uncategorized | Leave a Comment »