- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: migrate oracle from 11.23 ia to 11.31 ia
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-17-2011 01:02 PM - last edited on тАО08-08-2011 02:12 PM by Kevin_Paul
тАО05-17-2011 01:02 PM - last edited on тАО08-08-2011 02:12 PM by Kevin_Paul
Hi All, Greetings.
I am researching how to migrate several oracle 9i, 10g, 11g databases from hp-ux 11.23 ia servers (vpars) to 11.31 ia servers (i2 blade). I found this HP forum link http://h30499.www3.hp.com/t5/Databases/Oracle-database-migration-between-11-23-and-11-31/m-p/4470893#M38945 ; which mentioned to migrate oracle by presenting the lun's to the new 11.31 server and startup databases. No reinstall or relink needed.
Can you please help me with the following questions from my dba regarding this migration task?
1. there are couple oracle files in /var and etc directories, do they need to copy over?
2. What about oracle patch levels on the 11.31 server?
3. Is there any risk that the data files might get corrupted after oracle startup on the 11.31 server?
Can you please help and let me know your suggestions on this? Thank you.
Kind Regards,
Jan
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-17-2011 01:19 PM
тАО05-17-2011 01:19 PM
SolutionYou can follow the following path:
1) create new vpar 11.31 and set up access to the oracle disks, which hopefully are on SAN or NFS.
2) Complete all preparation steps required by Oracle, patching and such.
3) Install Oracle on the new 11.31 host
4) Bring down the database on the 11.23 host.
5) Bring up the database on the 11.31 host.
You will need the entries from /etc/oratab
As var as /var goes, depends what is sitting there.
Question 2 of yours: You need to check the Oracle metalink site and install all necessary OS patches they list and dependencies.
Question 3 of yours: Yes. You need a full cold backup.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-17-2011 01:41 PM
тАО05-17-2011 01:41 PM
Re: migrate oracle from 11.23 ia to 11.31 ia
Thanks for helpful information. The 11.31 servers are on blades bl860c i2 (they are not vpars).
I plan to present the oracle binary directory /u01 (on a san disk LUN) from 11.23 server to 11.31 server. Do I still need to reinstall oracle 9, 10, 11 binary on the 11.31 servers?
The reinstall oracle 10g, 11g binary takes long time. Also Oracle doesn't support 9i databases any more. It will be too challenging and time consuming(for my dba team) to install oracle 9i on new servers. We hope NOT to reinstall oracle binary on the new 11.31 servers. What do you think?
Regards,
Jan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-17-2011 08:05 PM
тАО05-17-2011 08:05 PM
Re: migrate oracle from 11.23 ia to 11.31 ia
You should not need to install old version oracle versions the new server.
If the (version) gap is too large you might want to do a 'quick' upgrade to an intermediate level on the old server.
You should rely first and foremost on Oracle information, and hpux only secondarily.
As such you should already have mentioned and studied:
"Oracle├В┬о Database Upgrade Guide
11g Release 2 (11.2) E17222-07"
http://download.oracle.com/docs/cd/E11882_01/server.112/e17222.pdf
In there you will find a further reference:
"For information about upgrading from Oracle9i Release 2 to
Oracle Database 11g Release 2, see Oracle 11gR2 Upgrade
Companion Note 785351.1 at My Oracle Support. Other upgrade
companions are available as well for upgrading to earlier releases."
Good luck!
Hein
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-17-2011 08:09 PM
тАО05-17-2011 08:09 PM
Re: migrate oracle from 11.23 ia to 11.31 ia
And start the oracle on vpar mode. It should start. I have done similar activities where oracle din't make any issue after upgrade to 11.31.
After that, you can have ignite backup & get it restored on i2 blade.
Thanks,
Vivek
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-18-2011 05:05 AM
тАО05-18-2011 05:05 AM
Re: migrate oracle from 11.23 ia to 11.31 ia
Thanks for the oracle doc. We are upgrading the HP-UX OE and hardware, but not the Oracle versions at this migrate. Each databases will keep their own versions.
Hi Vivek,
Thanks for the reply. I am not using update-ux to upgrade OE 11.23 to 11.31 on the same vpar box. I have already cold installed OE 11.31 on a new blade server box; and now I need to migrade the oracle databases from the old 11.23 box to the new 11.31 box.
Thank you.
Kind Regards,
Jan Shu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-18-2011 05:39 AM
тАО05-18-2011 05:39 AM
Re: migrate oracle from 11.23 ia to 11.31 ia
I am going to use the steps in above your message. I should assign 10 points for your posting but I don't know how to change it. Many thanks for your great help again.
Have a nice week.
Kind Regards,
Jan Shu