Home » RDBMS Server » Server Administration » Migrate from 32 Bit Oracle 9.2.0 to 64 Bit Oracle 9.2.4
- Migrate from 32 Bit Oracle 9.2.0 to 64 Bit Oracle 9.2.4 [message #60670] Tue, 24 February 2004 09:57 Go to next message
Vinny75
Messages: 44
Registered: October 2003
Member
folks,

I have a solaris 2.8 box currently hosting a 32 Bit Oracle 9.2.0 Dev Instance. I would like to migrate to a 64 Bit Oracle RDBMS since I am on a 2.8 Solaris box. It also seems to be our corporate standard to stay on 64 Bit RDBMS. Can someone please tell me if there is a simple way to have this done?

Can a new 64 Bit 9.2.4 Oracle Home share on the same box with 9.2.0 32 Bit RDBMS? Also�will an�export of 9.2.0 32 Bit Oracle have problems when I import on a 64 Bit Oracle? If there wont be a problem, I thought of having a new home for 9.2.4 and creating new instance using DCA and use my existing datafiles? If that dont work I thought of running a full import from 9.2.0 to 9.2.4

Please advice and your expert opinion will be greately appreciated.

Thanks

�

Report message to a moderator

- Re: Migrate from 32 Bit Oracle 9.2.0 to 64 Bit Oracle 9.2.4 [message #60682 is a reply to message #60670] Wed, 25 February 2004 05:42 Go to previous messageGo to next message
croca
Messages: 50
Registered: January 2004
Member
It is ok you create a new ORACLE_HOME for Oracle rdbms 64 bits, and it is OK to create a new instance. Bu want be able to re-use your current datafiles.
You will have to recreate datafiles, and you can import your data from the old DB.
You can also do a full export from your old DB, create a new instance on 64 bits and full import. The full import will recreate your datafiles and tablespaces. Of course, you will have to create the same directory names on the new server as it exists in your old server.
Regards.
www.otools.com.ar

Report message to a moderator

- Re: Migrate from 32 Bit Oracle 9.2.0 to 64 Bit Oracle 9.2.4 [message #60914 is a reply to message #60670] Fri, 12 March 2004 09:37 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
This is a different case than mine ....

I went from 816 32bit to 817 64 bit, so it was an upgrade on version as well as bit and all went fine. (I have gone from 817 64bit to 920 64bit now)

Did you try to contact Oracle on this ?

Report message to a moderator

Previous Topic: ORA-03113: end-of-file on communication channel
Next Topic: db link
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 06 05:58:39 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.