- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Migration Help
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
тАО10-29-2003 06:25 AM
тАО10-29-2003 06:25 AM
We are planning to migrate from Oracle 7.3.4 to Oracle 9.2
I'm just a developer in oracle and i have never did migration before. Can anyone please let me know what are the aspects i need to
take care of or worry about. Also any link/books that would help me in this regard.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 06:36 AM
тАО10-29-2003 06:36 AM
Re: Oracle Migration Help
First you must upgrade the data to 8.1.7, then up can upgrade it directly to 9.2.
Source: http://metalink.oracle.com
The procedure is also available at http://otn.oracle.com
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
тАО10-29-2003 06:53 AM
тАО10-29-2003 06:53 AM
Re: Oracle Migration Help
-A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 07:45 PM
тАО10-29-2003 07:45 PM
Re: Oracle Migration Help
As above you need to go via 8i to get from 7.x to 9i, and 7 is quite old so you may struggle to find documentation.
The oracle 8i docs are at http://otn.oracle.com/documentation/oracle8i.html
If you're doing the upgrade in place, then the installer will recognise the older version and upgrade it for you.
If you're going to a new box, you'll need to do an fresh install and export the 7.3.4 database and import it to 8i.
It's a similar process from 8 to 9.
Docs are at http://otn.oracle.com/documentation/oracle9i.html
And don't forget to update your client s/w.
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 08:19 PM
тАО10-29-2003 08:19 PM
SolutionThere is no direct path to migrate Oracle database from release 7.3.4 to release 9.2.0
You will have to migrate in thow phases.
1. From Oracle 7.3.4 to Oracle 8i (preferable 8.1.7)
2. From Oracle 8.1.7 to Oracle 9.2.0
So install Oracle 8i and Oracle 9i in different homes respectively (and different from oracle 7.3.4).
Then refer to the attachment for "Checklist for Migrating from Oracle7 to Oracle8.doc" to migrate the database from 7.3.4 to 8.1.7. I had migrated few database following this document.
When the database is in 8i then take a full cold backup of the database.
Then follow the guidelines of the attachment "migrating from oracle 8 to oracle 9.doc" to migrate from 8i to 9i. These are only guidelines. It would be better if the DBA was near by.
I hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 08:20 PM
тАО10-29-2003 08:20 PM
Re: Oracle Migration Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2003 10:01 AM
тАО10-30-2003 10:01 AM
Re: Oracle Migration Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-02-2005 09:46 PM
тАО01-02-2005 09:46 PM
Re: Oracle Migration Help
I have following queries about migration.
How to test migrated data???
In migration we are having 600GB data.
Which method is best for migration???
Thanks in advance.
Bye...