Oracle Database Migration using Oracle SQL Developer I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer


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



Question is what is best way to do this ?

I surfed &amp; 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 ?
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.