- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- upgrade from oracle 8.1.7 to oracle 9i
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-09-2006 09:36 PM
тАО05-09-2006 09:36 PM
Soon we will be upgrading from Oracle 8.1.7.2 to 9.2.0.7 on HP-UX 11.00.
I think that the release is 9.2.0.1 and after apply some patch.
I don' know if is better upgrade oracle 8i to oracle 9i using the database upgrade assistant or to do a new installation and after the migration of all schema delete the installation of oracle 8i.
Can I know which problem could be in a upgrade on existent applications?
Is useful run InstallPrep.sh script in any case ?
Please send me link or details about setting and installing Oracle 9i
Thanks
Solved! Go to Solution.
- Tags:
- upgrade
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-09-2006 09:44 PM
тАО05-09-2006 09:44 PM
Re: upgrade from oracle 8.1.7 to oracle 9i
1. Check system for the required HPUX patches.
2. Install Oracle 9i sw + patches into a new ORACLE_HOME
3. Create a DB backup
4. Close Ora8 DB
5. Change environment to Ora9 ORACLE_SID, ORACLE_HOME, init.ora files etc
6. migrate your Ora8 DB to Ora9 (see the Oracle 9i Migration Guide)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-09-2006 10:52 PM
тАО05-09-2006 10:52 PM
Re: upgrade from oracle 8.1.7 to oracle 9i
You need to know if your data is 32 bit or 64 bit. There is a word size conversion process needed on the data if you wish to migrate to 64 bit Oracle.
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-09-2006 11:55 PM
тАО05-09-2006 11:55 PM
Re: upgrade from oracle 8.1.7 to oracle 9i
Please some detail about the phase 5. Change environment to Ora9 ORACLE_SID, ORACLE_HOME, init.ora files etc
For the environment you intend the .profile file of oracle user ?
I can use the same oracle user when I install and in the profile I have one ORACLE_SID but
I have trhee instances of oracle, when I upgrade oracle it change all instances ?
And about init.ora files which change are needed ?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2006 01:19 PM
тАО05-10-2006 01:19 PM
SolutionBefore the migration process,
Verify the applications are certified to run under the new RDMBS release.
Verify the certification of Oracle 9i on the OS version you are using.
Verify all necessary OS patches are installed.
It is very useful to run the script InstallPrep.sh.
A good full cold backup of the existing database, is necessary.
Upgrade path for Oracle 8i (8.1.7) to Oracle 9i release 2, is a direct path and you can directly upgrade your database to Oracle 9.2.
Oracle Enterprise Edition release 9.2 64-bit is certified on HP-UX 11.00
Refer to Note:159657.1 in Metalink for "Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9i
You can also check the installation in metalink Note 169706.1
As Steven mentioned about the word size conversion, as Oracle 9i release 2 is 64-bit, and if your current database in 8.i.7 is in 32-bit then you need the word conversion. Refer to Refer to metalink Note:62290.1
Refer to Note 197737.1 for "Corruption / Internal Errors Possible after Upgrading a Database to Oracle 9.2.0.1"
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2006 03:23 AM
тАО05-11-2006 03:23 AM
Re: upgrade from oracle 8.1.7 to oracle 9i
Just a comment, after apply patch to 9.2.0.7 version, you need to apply the most recent Oracle interim Patch.
https://metalink.oracle.com/metalink/plsql/f?p=130:14:10576498718088699447::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,189489.1,1,0,1,helvetica
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2006 05:05 AM
тАО05-14-2006 05:05 AM
Re: upgrade from oracle 8.1.7 to oracle 9i
You have alot of good responses, but I want to throw my two cents in.
If you have the ability to do an export/import migration of the database, I would probably recommend that route. It gives you the ability to create the database as a true 9i database, so the SYSTEM tablespace is LMT, and the tablespaces will be created LMT as well (if they aren't right now). Also, it gives a "clean" database, so there isn't any of the previous Oracle stuff floating around in the SYSTEM tablespace.
The biggest problem I see with that is simply the time involved in doing it, since you have to have the database unavailable to the users through the export and import. On a large database, this can take a while, and isn't always worth the additional downtime.
If you decide to do the migration, I would strongly recommend using the 'dbua' migration assistant, rather than doing the manual process. I have done a number of upgrades using it, and haven't had any problems that I can remember.
Hope this helps,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2006 08:32 PM
тАО05-14-2006 08:32 PM
Re: upgrade from oracle 8.1.7 to oracle 9i
Sorry but I am not an expert ,I have a doubt
Do you mean export of users schema, not full export ?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2006 12:43 AM
тАО05-15-2006 12:43 AM
Re: upgrade from oracle 8.1.7 to oracle 9i
Again, personal preference, but a full export should make sure that everything that you need to load onto the new database is there, so that there isn't any oversight. If you are concerned about the "extra" users (OUTLN, DBSNMP, etc) or the SYSTEM objects, the tables/views/etc that are loaded are generally ones that do not affect the running of the database, or are user generated in that schema.
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2006 10:44 PM
тАО05-15-2006 10:44 PM
Re: upgrade from oracle 8.1.7 to oracle 9i
So if I make a full export of a oracle 8.1.7 relelase and after a full import on the oracle 9.2.0 , it doesn't any problem also on system table and object ?
There isn't different architecture ?
Thanks