- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: move database from 32 bit to 64 bit
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-04-2004 12:33 AM
тАО05-04-2004 12:33 AM
move database from 32 bit to 64 bit
i got the new machine running with UX and Oracle 8.1.7 without any database. and i got a export from the old machine ( 32bit ). the oracle mount points (u00/...) on the new system are not quite the same, can i adjust them in the export and can i do an import or must th├Г┬йre be any converting from 32 to 64 bi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2004 12:45 AM
тАО05-04-2004 12:45 AM
Re: move database from 32 bit to 64 bit
have a look at metalink note:Note:99206.1 - HP-UX: Migrate/Upgrade of Oracle on HP-UX.
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2004 01:00 AM
тАО05-04-2004 01:00 AM
Re: move database from 32 bit to 64 bit
Install oracle 8.1.7.4 64 nit on hp-ux11i 64 bit first. Move datafiles from source server to the target server. Of course you must recreate control file to reflect new locations of datafiles. And important thing is to change the word size from 32 to 64 bit by running $ORACLE_HOME/rdbms/admin/utlirp.sql
regards tommy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2004 01:36 AM
тАО05-04-2004 01:36 AM
Re: move database from 32 bit to 64 bit
No convert needed. The 64-bitness is reflected in the running code (large SGA!) only. There is no on-disk difference.
You can just to the import as you have planned. If you choose to do so, please consider to also upgrade Oracle to a more recent version?! 9.2?
You may also want to consider a straight DB file copy over the network (piped through compress of course). Or if that is an option, move some disk connections around.
As replied earlier, unless you managed to re-create the exact same filenames you may need some 'alter database rename ...' or 'create controlfile ...' to deal with new places.
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2004 02:21 AM
тАО05-04-2004 02:21 AM
Re: move database from 32 bit to 64 bit
> the oracle mount points (u00/...) on the new system are not quite the same, can i adjust them in the export and can i do an import
The mount points are isolated from the end users and imports through the tablespace mapping. The import just mentions tablespaces, not files or mountpoints. So as long as you created all the tablespaces you are good to go for the import. It would not matter what mountpoints you picked on the newe system. No rename / adjust needed. (nad still no convert needed).
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2004 05:58 AM
тАО05-04-2004 05:58 AM
Re: move database from 32 bit to 64 bit
The export/import does have a record of the tablespaces and datafiles. In the event that you do not build one of the tablespaces, it will create it with the previous datafile locations.
It is not possible to modify this though. The tablespace has to be created before the import is run if the datafiles need to be in a different location or under a different name.
I would also recommend taking an online backup and restoring it instead, and then changing the wordsize.
Thanks,
Brian