This content has been marked as final. Show 4 replies
How serious is your employer about assigning job tasks and responsibilities? ;-)
As you found out already, Oracle Linux, like Red Hat Enterprise Linux, does not support upgrading from one major version to another, and you cannot use YUM to perform the upgrade. You can use the installation DVD, but In-place upgrades across major releases do not preserve all system settings. Perhaps this will be OK with a plain vanilla system, but your mileage will vary. I would not feel comfortable to it on a production system. I see no advantage.
Oracle database servers are typically single purpose installations with no other general use. If there are any settings or software configurations that you are not aware off then you should probably not perform any upgrade and find out the hardware and software requirements first.
Oracle database upgrades are a complete different subject and need to be addressed individually, which is beyond the scope of the Linux forum. It requires many more details. You are most likely not the first person to perform such an upgrade and there should already be plenty of information.
So you think the safeist bet is to do a fresh RH6 install and fresh install Oracle again then import data? Can we just do the intall then copy back all our oracle files again to where they were stored before or it's just not that simple? Our current oracle home is on a SAN /u01/app/oracle/product.... so it's not in the /home area or any other Linux default install area.
Or can we just do a fresh install on top of the previous verison and preserve Oracle and datafiles?
I recommend to upgrade Oracle on the old system first, before planning to upgrade Linux.
Once you have completed the upgrade and everything is fine, create an offline backup of the complete system.
Finally, erase the system disk, install and setup Oracle Linux 6.4. Configure the mount points and set up the Oracle account ID the same way as it was on the old system. You will probably want kernel hugepages and use ASM. You can then install the "oracle-rdbms-server-11gr2-preinstall" package to do the remaining software prerequisites and kernel parameters. Then restore the Oracle database stuff. Don't forget oracle scripts in /usr/local/bin, /home/oracle login profile files and /etc/oratab. And finally relink the oracle binaries on the new system using $ORACLE_HOME/bin/relink all
For more details, the Database Upgrade forum as already mentioned is the right place to ask.
Edited by: Dude on Apr 10, 2013 7:25 PM
I was already leaning that way after I read that Linux doesn't like full version upgrades. It would be too much to do at one time with new hardware and on top of that a different geographical location move. I've already perfomed an 11G upgrade in the past so I will start with that and get my Linux admin skills up in the meantime.