Impdp_problem

[Arsalan]

Hello Arslan,

Oracle 11.2.0.4
windows 2012 R
oracle golden gate have been configured schema level bidirectional

I want to export full database from Oracle database 11g R2  to Oracle 12c R2 pluggable

please  guide me how to export full Oracle 11g database and import to ORACLE 12C Pluggable database

Note: we have one schema that have all tables , and we have number of users that access schema objects
the others user must also export  and import in dumpfile

thanks a lot for always supported me

[ErmanArslansOracleBlog]

Hi Arsalan,

This is a standard expdp/impdp process.

If you want a full export, then you will use the FULL=Y argument. That is it.
If you want to export only a set of schemas, then you will use SCHEMAS argument.. For instance : SCHEMAS=hr,org...

This is an expdp/impdp -- datapump related information request.. You can find all the info you need in oracle documents and internet..

So, if you have a specific question, then come and ask again..

[Arsalan]

Hi  Arslan


1--  I run below script to take full expdp backup it successfuly completed


system/********@prod DIRECTORY=DUMPFILE dumpfile=Prod-12-04-2019.dmp logfile=prod-12-04-2019.log full=y


2-I copied dumpfile to oracle 12c pluggable database server

3-I Created same tablespaces in pluggable database as Source oracle 11g 11.2.0.4 have

login to ORACLE 12C PLUGGABLE DB


4-set oracle_sid=pdb1

sys/aone@pdb1 as sysdba

Connected.

I create directory p6_dir as 'c:\app\arsala\p6_dir'; on pluggable database

  grant read,write on directory p6_dir to system;

----Grant priviliges to SYSTEM USER TO IMPORT DUMPFILE

GRANT DBA,BECOME USER,CREATE ANY JOB,CREATE EXTERNAL JOB,DEQUEUE ANY QUEUE,ENQUEUE ANY QUEUE,EXECUTE ANY CLASS,EXECUTE ANY PROGRAM,MANAGE ANY QUEUE,
MANAGE SCHEDULER,SELECT ANY TRANSACTION,IMP_FULL_DATABASE TO SYSTEM;

then i run impdp command like below

impdp system/********@pdb1 DIRECTORY=p6_dir DUMPFILE=AFGPROD-08-26-2019.DMP logfile=SIGFINALE1.log FULL=Y

I found the error please find to log file for details

SIGFINALE1.log

please guide me

[ErmanArslansOracleBlog]

You are actually failing with -> ORA-20000: Incompatible version of Workspace Manager Install

Re-export using VERSION=12 argument. (expdp ........ VERSION=12 FULL=Y), then retry your import..

[Arsalan]

Hello Arslan,

I rerun expdp from oracle 11g 11.2.0.4
like
expdp system/******** directory=P dumpfile=SIGTAS2.dmp logfile=Final.log full=Y version=12

it was successfully completed but when i want to import to oracle pluggable database 12c it give again error

please check the log


Final.log


SIGTAS2.log



thanks sir

[Arsalan]

Hello Arslan bro,

I tried a lot to import dumpfile of oracle 11g to pluggable 12c i still have error i did not  found the problem yet.

i needs your more  supports .


Thanks a lot

[ErmanArslansOracleBlog]

Ignore my previous reply, (I already deleted it)

This error seems to be related with the version difference between your source and target. Probably your target system can not identify the values used in the source.. The values for the PROCACT_SYSTEM , which is based on resource manager objects..

Okay.. Your action plan is;

use exclude=PROCACT_SYSTEM for your export.

This action will exclude the resource manager objects from your exports objects related to your resource plans and groups.

So if you have resource plans and groups in your source env, create them in the targwt , after you finish your import.. If you don't have resource plans and groups in your source env, then don't do anything after your import.

[Arsalan]

Thanks a lot Arslan for always support

Currently the problem have solved.

if i face other error then i will share with you.