Home » RDBMS Server » Server Administration » Need advice to Migrate 11g to 12c using datapump (12c)
Need advice to Migrate 11g to 12c using datapump [message #675613] Wed, 10 April 2019 04:20 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Need advice to Migrate 11g to 12c using datapump [message #675616 is a reply to message #675613] Wed, 10 April 2019 05:05 Go to previous messageGo to next message
John Watson
Messages: 8086
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?
Re: Need advice to Migrate 11g to 12c using datapump [message #675618 is a reply to message #675616] Wed, 10 April 2019 05:38 Go to previous messageGo to next message
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.

Re: Need advice to Migrate 11g to 12c using datapump [message #675619 is a reply to message #675618] Wed, 10 April 2019 05:41 Go to previous messageGo to next message
John Watson
Messages: 8086
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.
Re: Need advice to Migrate 11g to 12c using datapump [message #675620 is a reply to message #675619] Wed, 10 April 2019 05:46 Go to previous messageGo to next message
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 498 times)
Re: Need advice to Migrate 11g to 12c using datapump [message #675621 is a reply to message #675620] Wed, 10 April 2019 05:48 Go to previous messageGo to next message
John Watson
Messages: 8086
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.
Re: Need advice to Migrate 11g to 12c using datapump [message #675622 is a reply to message #675621] Wed, 10 April 2019 05:51 Go to previous messageGo to next message
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.
Re: Need advice to Migrate 11g to 12c using datapump [message #675623 is a reply to message #675620] Wed, 10 April 2019 05:51 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Need advice to Migrate 11g to 12c using datapump [message #675624 is a reply to message #675622] Wed, 10 April 2019 05:53 Go to previous message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
prabhaher wrote on Wed, 10 April 2019 12:51
Thanks Mr.John. I will try to import in PDB. Hope I will not get the same error again.
You won't for sure.

Re: Need advice to Migrate 11g to 12c using datapump [message #675625 is a reply to message #675623] Wed, 10 April 2019 05:53 Go to previous message
prabhaher
Messages: 11
Registered: December 2009
Location: Muscat
Junior Member
Thanks Mr.Michel for the clarification.
Previous Topic: drop sub partition on table
Next Topic: automatic restart of teh instance
Goto Forum:
  


Current Time: Mon Dec 16 03:59:25 CST 2019