I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer enter image description here

Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node

enter image description here

Question is what is best way to do this ?

I surfed & found that oracle SQL Developer can help check this Link

Does this will work ?? Or I have to fallow RMAN cloning option ?

What is best suitable way for doing this ?

  • 1
    I wouldn't use our Database Copy for this - that's more for ad hoc copies. If you want to migrate/consolidate entire instances, there are much more efficient ways. Apr 1, 2015 at 13:07
  • 1
    expdp and impdp are probably a lot more efficient than using SQL Developer for this. If you can create a DBLink you don't even need intermediate files for that
    – user1822
    Apr 1, 2015 at 13:07
  • 1
    Yep!! I am thinking exdp & impdp too. I am exploring all possible ways as db is not live & I am just running tests. @a_horse_with_no_name : I used DB links for vertical & horizontal fragmentation, who it can help in migrations ?
    – Ashish
    Apr 1, 2015 at 18:32

2 Answers 2


why do you need windows at all? you even do not need sql developer.

  • shutdown the source database
  • scp datafiles(.dbf .ctl)
  • scp files in ORACLE_HOME/dbs (like initSID.ora, spfileSID.ora, and also password file)
  • you should also create dirs for diagnostic_dest (where alert.log is placed)
  • amend /etc/oratab
  • set the right SID
  • start the database

PS: this assumes that the Oracle version (including fixpack) is exactly the same.

  • 1
    Let me try this!!, Any URL where i can get this [I am linux developer, little DBA migration skills]
    – Ashish
    Apr 1, 2015 at 13:11
  • 1
    I was even thinking of DataPump
    – Ashish
    Apr 1, 2015 at 13:12

As time goes on, this answer changes.

Current answer should involve a move to a Multi-Tenant setup. The latest version (19c, soon 20c) allows 3 Plugable Databases (PDB) without a license.

Licensing Information for 19c:

For all offerings, if you are not licensed for Oracle Multitenant, then you may have up to 3 user-created PDBs in a given container database at any time.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.