- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Upgrade from7.3.4 to 8i
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
тАО03-28-2002 07:00 AM
тАО03-28-2002 07:00 AM
Oracle Upgrade from7.3.4 to 8i
We are currently using HP-UX 10.20 with Oracle 7.3.4. We are planning to upgrade oracle as this version will not be supported soon. At the same time we are also planning to upgrade HP-UX to 11.00.
What should be the best approach to these upgrades??
What if we do the oracle upgrade first and keep HP-UX 10.20?
Thanks,
Ashish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2002 07:24 AM
тАО03-28-2002 07:24 AM
Re: Oracle Upgrade from7.3.4 to 8i
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2002 07:51 AM
тАО03-28-2002 07:51 AM
Re: Oracle Upgrade from7.3.4 to 8i
1. Take backups (of database AND system) !!!
2. Take full export from database
3. Remove database
4. Upgrade server
5. Recreate database as 8i
Compatible parameter might be important, check this with oracle !!!
6. Import exportfile
To make sure you should check with oracle whether or not a 7.3.4 export can be imported in a 8i database ... but I believe it can be done (one of our dba's did this).
Hope this helps,
Tom Geudens
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2002 08:22 AM
тАО03-28-2002 08:22 AM
Re: Oracle Upgrade from7.3.4 to 8i
1) Install 8i on 10.20 first if possible (?).
2) Use dbassist to create the new db
3) Create your tablespaces, roles, and users
4) Export using the 7.3.4 export
5) Import using the 8i import
6) Connect test applications to the 8i and bang away at it a bit.
If all goes well in 1 to 6, then
8) Uninstall 8i
9) Upgrade to 11 and apply the patches
10) Reinstall 8i and apply the patches
11) repeat 2-5
Be picky about your testing, it pays.
Ryan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2002 12:05 AM
тАО03-29-2002 12:05 AM
Re: Oracle Upgrade from7.3.4 to 8i
Second, there exists a document on Oracle Metalink which describes migration from 7.3.x to 8.1.x - note 99206.1 and other with checklist for migration -note 47290.1.
It's better to read its first.
Obvious, you will need a full backup of database or if you have a test machine it's better to try with a copy of database first. Also, make sure that any possible dependencies with other databases aren't broken after upgrade (views on other databases or anything like this). That's why I recommend to try on a test machine first.
Remember that is a no-return point and if you miss something you'll have to recover from backup.