Which_oracle_release_To_install...

Hi

I am migrating 3 standalone databases from one old machine running RHEL 5.11 and
Oracle Database 12.1.0.2.0.

The new machine has better processers, RAM, storage and running RHEL 7.2.

Oracle recommended to reinstall oracle software instead of copying binaries.

My questions are:

1) Is it better to install same oracle version 12.1 on new machine or
shall I install the latest  release 12.2.0.1.0?

2) If I installed Oracle 12.2, do I need to do any rebuilds or any extra work for the database files I will be copying
from old machine to new machine?




Thanks,
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.

johnsoneSenior Oracle DBACommented:
I would install the latest version (12.2).  Once you do that and get the data files onto the machine, you would have to follow the upgrade process from 12.1 to 12.2.  It should be fairly straightforward for a dot release like that.
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
arnoldCommented:
To johnstone's point, much depends on your software that is the front end to the data.
Point being, if the front end software supports the newer version, updating all to the newest in the upgrade cycle, will avoid the necessity, complexity of having to transition shoukd the newer software distribution requires a newer version of oracle db.
Since you have redhat 5.1 suggests the system has been in place at least five years.
0
sam15Author Commented:
Does this mean if I installed 12.2 I would have to go upgrade the databases from 12.1. to 12.2 after copying database files to new machine?

If I installed 12.1 then I will not need an upgrade for databases?

Is this correct?

Is the upgrade easy to do?
0
The Ultimate Tool Kit for Technolgy Solution Provi

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 for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

arnoldCommented:
You should double check best practices in transitioning oracle db server from server to server.

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/install-and-upgrade.html

You may want to test your application with the new db server version using backup/restore ....



Not sufficiently familiar with oracle DB process dealing with hawrdware transition.
0
johnsoneSenior Oracle DBACommented:
The biggest caveat moving between servers is Endian.  Likely isn't an issue in this case, but possible.  There is  a way to convert the datafiles with RMAN if needed.  If needed, this would have to be done regardless of whether or not you are upgrading the database, this is a difference in hardware that needs to be addressed.  Since you are going from RHEL to RHEL, there shouldn't be any other issues.

Only other issue I can think of with moving machines is renaming the datafiles (in the database) if the locations are not the same.

Yes, if you install 12.1, then a database upgrade wouldn't be necessary.  But, if you can, take the time to do it.  You have the downtime already.  This prevents a second downtime in the future.

Yes, you would need to upgrade all the databases on the server.  I would refer to the documentation link already posted as to available methods and what is involved.  As with any other change, do it on a test machine and test, then when you are done, test again.
0
sam15Author Commented:
my plan was to shutdown database on old machine and do a coy of files via SSH/SCP to new machine.
The directories are same structure.

I assume I can try copying binaries from old machine to new machine and see if it works. Oracle recommended reinstall since I am going from RHEL 5.11 to RHEL 7.2. I am not sure if the binaries or DLLs or links may not work properly later on.
0
arnoldCommented:
Best go through install, to make sure user, group created correctly. And related.

IMHO copying files tends to over look permissions, setting.
Do you use a mounted filesystem or raw ocfs2?


The software you use, does the vendor release updates/upgrades or the same software has been used for the duration, no updates since?
0
johnsoneSenior Oracle DBACommented:
I will second the install comment.  You could probably copy the binaries, but with a different OS version you would have to relink anyway.  Might as well do the full install.

There are additional directories outside the binary tree that need to be copied and those vary by OS.  If you aren't really familiar with where absolutely everything goes, install.
0
sam15Author Commented:
I think it is a mounted filesystem? How do you find that out?

The software is oracle and they release patches. I remembered that I installed Oracle 12.1 and applied some patches after that.
It might be easier just to install the latest 12.2 and skip any patches and then upgrade DB from 12.1 to 12.2.

I am also using oracle total recall for automatic startup so I would have to install grid software first.
0
arnoldCommented:
df -k lists mounted partitions
Are the oracle partitions listed

My advise do not rush to upgrade the production just because you are considering installing the newer version on the newer server.

Use the new server setup to test/validate.....
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.