OraFAQ Forum: Server Administration » Need advice to Migrate 11g to 12c using datapump

Home » RDBMS Server » Server Administration » Need advice to Migrate 11g to 12c using datapump (12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need advice to Migrate 11g to 12c using datapump [message #675613]

Wed, 10 April 2019 04:20

prabhaher
Messages: 11
Registered: December 2009
Location: Muscat

Junior Member

Dear all,

My current database version is 11.2.0.3. I want to migrate to 12C release 2 using datapump. I have already created the dump file using Expdp.

I created oracle database in 12c. when I imported in my CDB using Impdp I am got the block error ora-29339.

So for testing purpose I have created the tablespace in sql editor and tried to import only one schema in that tablespace. when I imported using Impdp I got error ORA-39083:Object type USER:"TESTUSER" failed to create with error:

When i googled i found, it can be solved using the query alter system set '_oracle_script'='true'

My question is how this script can be used in Impdp to create the users and import the data?

Please guide me.

Thanks in Advance

[Updated on: Wed, 10 April 2019 04:22]

Report message to a moderator

Re: Need advice to Migrate 11g to 12c using datapump [message #675614 is a reply to message #675613]

Wed, 10 April 2019 04:26

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

failed to create with error

With what error?

Quote:

it can be solved using the query

Don't do that!
Are you running an Oracle script? No, so don't do that.

Report message to a moderator

Re: Need advice to Migrate 11g to 12c using datapump [message #675616 is a reply to message #675613]

Wed, 10 April 2019 05:05

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

You have created a multitenant database, and are trying to import into the root container. You can't do that, which is why you are getting that message regarding _oracle_script. You have to import into a pluggable container. Have you created one?

Report message to a moderator

Re: Need advice to Migrate 11g to 12c using datapump [message #675618 is a reply to message #675616]

Wed, 10 April 2019 05:38

prabhaher
Messages: 11
Registered: December 2009
Location: Muscat

Junior Member

Yes I am importing in CDB. I created the tablespace via sqlplus and imported only one schema using IMPDP that time I got the error : Ora-39083.

shouldn't I import in CDB? I will create only one database in my dbserver.

Report message to a moderator

Re: Need advice to Migrate 11g to 12c using datapump [message #675619 is a reply to message #675618]

Wed, 10 April 2019 05:41

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Why don't you show the error that follows ORA-39083? What's the big secret about it? I've guessed what the problem may be, and if I am correct I've told you the answer: you have to import into a pluggable container, not the root container. If you don;t understand that, talk to your DBA.

Report message to a moderator

Re: Need advice to Migrate 11g to 12c using datapump [message #675620 is a reply to message #675619]

Wed, 10 April 2019 05:46

prabhaher
Messages: 11
Registered: December 2009
Location: Muscat

Junior Member

Dear Mr.John,

Thanks for immediate reply.

Please find the attached log file while importing schema called APPSYS.

Attachment: APPSYS.LOG
(Size: 685.96KB, Downloaded 2727 times)

Report message to a moderator

Re: Need advice to Migrate 11g to 12c using datapump [message #675621 is a reply to message #675620]

Wed, 10 April 2019 05:48

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

So you are hitting

ORA-65096: invalid common user or role name

That is exactly what I said. I've told you what to do about it. Twice.

Report message to a moderator

Re: Need advice to Migrate 11g to 12c using datapump [message #675622 is a reply to message #675621]

Wed, 10 April 2019 05:51

prabhaher
Messages: 11
Registered: December 2009
Location: Muscat

Junior Member

Thanks Mr.John. I will try to import in PDB. Hope I will not get the same error again.

Report message to a moderator

Re: Need advice to Migrate 11g to 12c using datapump [message #675623 is a reply to message #675620]

Wed, 10 April 2019 05:51

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The actual error is:

Quote:

ORA-39083: Object type USER:"APPSYS" failed to create with error:
ORA-65096: invalid common user or role name

This is what John told you: you have to import in a PDB not in the root container.
You do NOT use the root container for anything that is not Oracle or database and instance management.
All your application data and codes should be in a PDB.

[Updated on: Wed, 10 April 2019 05:52]

Report message to a moderator