Migrating_oracle12-servers..

I want to migrate an oracle server 12.1.2.0 from with several production databases from machine A (RHEL 5.8) to new machine B (RHEL 7.4).


My questions:

1) Is RHEL 7.4 certified for oracle 12.1 and is it stable?
The IT group has built RHL 7.4 machines even though I requested RHEL 7.2

Oracle certification matrix lists RHEL 7 but I am not sure if that includes
all the minor release or not

2) Can I copy the oracle binaries and databases from machine A
to machine B or do I need to reinstall oracle software on new OS
for binaries to link properly?

3) Can I copy the database files from machine A to machine B instead of
creating a new database and reconfiguring, etc.
sam15Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
1)  A lot depends on the underlying hardware but if it is x86-64 it appears 12.1.0.2 is certified but you should use Oracle Support's Certification Matrix to confirm this for yourself.  Taking certification advice from strangers on a public website might get you into trouble someday.

2)  I've not run Oracle on Unix for many years but used to copy binaries around all the time.  As long as the Bit Versions of the software and hardware match, you should be good.

You need to make sure you get EVERYTHING for it to run on the new server.  Oracle puts necessary files in loctaions outside ORACLE_HOME so it can do what it does.  If you aren't very familiar with all these files, I would suggest a new install and post-installation steps.  That way you are 100% sure everything is where is should be.

3)  Same caveat above about my Unix skills being old:  You should be able to copy the data files assuming the database is shut down.  You need to get everything from all locations.  Personally, I would use RMAN Duplicate to make the move.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark GeerlingsDatabase AdministratorCommented:
1) I basically agree with slightwv.   We run Oracle12.1.0.2 on "Oracle Linux Server release 7.3" which I believe is supposed to be functionally identical to RHEL 7.3.  That is not RHEL 7.4, but it is very close.  We have not had a problem with this combination.

2) Yes, on Linux servers, it is possible to copy the Oracle binaries from one server to another.  But, if you use Oracle RAC, I would not recommend this.  For a single-node database, copying the binaries may work.  But, with the rather significant O/S version upgrade that you have, it sounds safer to me to re-install and relink the Oracle binaries.

3) Copying the Oracle database files is a very easy process, if you have the database shutdown cleanly, like with: "shutdown immediate" or "shutdown transactional".  Don't do a "shutdown abort"!  You just have to make sure to get all of the: data (tablespace), log (on-line redo) and control files plus the init or spfile files.  For the temp tablespace(s) you can either copy the temp file(s) or rebuild it/them.
0
sam15Author Commented:
According to oracle support I might need to re-install binaries when going from RHEL 5.8 to RHEL 7.4 and different hardware.
After I do that, just shutdown all databases, do a cold backup (copy) and then copy to new machine? I Assume there is no need to CREATE DATABASE or reconfigure those again. Correct?

I am also considering installing the latest software (i.e 12.2.0). Would the database file copy still work or we have to recreate/configure the databases we have?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

slightwv (䄆 Netminder) Commented:
>>I might need to re-install binaries when going from RHEL 5.8 to RHEL 7.4 and different hardware.

You should only need to worry about things if there was a different endianness:
https://en.wikipedia.org/wiki/Endianness

Notice they said "might" and I said "should"!!!  You need to test in your environment to know for sure.

>>After I do that...Correct?

Assuming you get EVERYTHING (and I mean EVERYTHING) and endianness is the same, I would agree you are correct.

Using RMAN Duplicate, you can save the shutdown/cold backup steps.  It's more involved but it is an option to limit downtime.
0
sam15Author Commented:
How do you verify hardware endianness to know if it is same or different? also, this seems to be hardware and not O/S factor.
Oracle support did not mention this at all.
0
slightwv (䄆 Netminder) Commented:
>>How do you verify hardware endianness to know if it is same or different?

Google?  Sorry but I'm not 100% sure.  I just remember from a long time ago that they need to match.
0
sam15Author Commented:
Very good.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.