Linux – Move Complete ORACLE from one system to another

linuxoracle

enter image description here

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server].

Entire ORACLE HOME ( bin , control files, data files everything on oracle) is on 2nd Disk (which is not a OS disk)

Since OLD server had reached end of life (from HP) a new HP machine with upgraded RAM (OLD system had 16 GIG where as new system as 64 GIG).

Now Since All oracle Dependencies (RPM, libraries, environmental variables, JAVA, Users and groups) are already made on new server.

So Now Question is ..

Can I remove Disk [Oracle HDD] from OLD server and insert it on NEW server and just start Oracle (sqlplus "/ as sysdba" or dbstart and lnsctrl).

Can it will give any challenge.
(I have cold backups, export backup, & RMAN backup too).

I just want to give a try on above case.

Will this work ??

Best Answer

  • Check OS users and groups: oracle, oinstall, dba.
  • Check the contents of /etc/oratab and /etc/oraInst.loc files to verify if they point to an expected location.
  • Check if these files are placed under the same paths:
    • init.ora, orapwd and similar
    • listener.ora, tnsnames and similar
    • control files
    • data files
    • redo log files
    • Oracle scripts such as oraenv (optionally - only if you use them), which are often placed in /usr/local/bin
  • Check if you retain the same IP.
  • Check if you retain the same DNS name.

And that's it, you are good to go.

Related Question