- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle migration
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-14-2002 07:21 AM
тАО05-14-2002 07:21 AM
We have an old (very old) Oracle database 7.3.2.2 running on an old D-380 server (HP/UX 10.20).
we plan to move to a newer architecture : L1000/HP-11i.
1) Is it possible to run Oracle 7.3.2.2 with HP 11i?
2) If this is not possible, we plan to migrate to Oracle 8.1.7 - L1000 - HP/UX 11i.
which is the best (more secure) way to go :
2.1) 2 phases jump :
first jump :
from D380/10.20/7.3.2.2
to D380/10.20/8.1.7
second jump :
from D380/10.20/8.1.7
to L1000/11i (32bits)/8.1.7
2.2) 3 phases jump :
first jump :
from D380/10.20/7.3.2.2
to D380/10.20/8.0.6
second jump :
from D380/10.20/8.0.6
to D380/10.20/8.1.7
third jump :
from D380/10.20/8.1.7
to L1000/11i(32 bits)/8.1.7
2.3 an other way to go?
3) if we plan to use an HP11i/8.1.7 with a 64bits architecture (OS + Oracle) : which is the best way to proceed?
best regards,
Frederic,
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2002 07:28 AM
тАО05-14-2002 07:28 AM
Re: Oracle migration
Pete
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2002 07:31 AM
тАО05-14-2002 07:31 AM
Solution1) Install 64-bit (why not?) 8.1.7 on your new box. Install any 8.1.7 patches.
2) Do a full export on the old box and a full import on the new box.
I have done exactly this transition and it works flawlessly. The beauty of this method is that it is perfectly safe. Your 10.20 box reemains untouched and if for some reason this Plan A fails, you have an intact starting point for Plan B.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2002 07:53 AM
тАО05-14-2002 07:53 AM
Re: Oracle migration
But this application is critical, and if we plan to move one way, we can't go back.
A lot of interfaces write and read "non duplicated informations" from this system.
And one of the constraint, is to let interface code free of modifications.
we can only modify the name of the target OracleSID. but not had one!
Are you sure that an export/import from 7.3.2.2/8.1.7 run without problems (case of stored procedure?)
Best regards,
Fred,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2002 08:08 AM
тАО05-14-2002 08:08 AM
Re: Oracle migration
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 01:26 AM
тАО05-15-2002 01:26 AM
Re: Oracle migration
Otherwise, I don't use to spend my time crossing my fingers, I am not a plug 'n play/ mouse player!
I used to work with 8/8i version, and I don't remember if the import/export tools are compatible between 7.3.2.2 (which is not supported by Oracle) and 8.1.7.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 03:04 AM
тАО05-15-2002 03:04 AM
Re: Oracle migration
As far as I remember...
1) It is not possible to upgrade anything lower than 7.3.4 to 8.0
2) It is not possible to upgrade from 7.x to 8.1.x in one step (recommendation is to go via 8.0.6)
3) To import a version 7 dump to an 8.0 database, special scripts needed to be applied on the 8.0 database (catexp7. or likewise), not sure about possibility / requirements for 8.1.x
Pitfalls: Version 7 databases used to default the charset zu US7ASCII, version 8 default to WE8DEC. In any case if you use export / import you may (afaik) not change the DB-charset. If you like to do that, you might need to convert some chars afterwards.
I would recommend the following:
- check out if the version 7 dump can somehow be imported to 8.1.7-64 bit and proceed like this (this would be best choice as someone already said), but do not change the db-charset.
If this is not possible I would go like this:
- upgrade to 7.3.4 on existing box
- install 7.3.4 on new box with UX 11.x executables
- export/import from 734/UX10.20 to 734/UX11
- upgrade new database to 8.0.6
- upgrade new database to 8.1.7
- convert to 64 bit
Hope this helps
Volker