Home » RDBMS Server » Server Administration » Moving a 32 bit Oracle 9i database to 64 bit on a different server
Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258666] Mon, 13 August 2007 05:22 Go to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Hello,

We have a 24 GB database with Oracle 9.2.0.7 (32 bit). As the hardware of this server is getting obsolete, it is planned to move this instance to another server, which has 64 bit Oracle software of same version (9.2.0.7). In this scenario what is the best way to move the instance?

Is it only the full export from 32 bit server and import into 64 bit server(after creating the instance there)?

Since this is a 24 GB database, and target server is 8 gb of ram, any pointers on how long the import process can take?

Thanks,
Nirav

[Updated on: Mon, 13 August 2007 05:24]

Report message to a moderator

Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258668 is a reply to message #258666] Mon, 13 August 2007 05:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I had 18 GB of data and without parallel parameter it took 2 hours to complete.
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258669 is a reply to message #258668] Mon, 13 August 2007 05:28 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Was it similar 9i migration from 32 bit to 64 bit? How much ram your server had? Thanks for sharing your experience.

And there is no other way except resorting to this export/import right?

Thanks,
Nirav
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258672 is a reply to message #258669] Mon, 13 August 2007 06:01 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should be able to simply copy your database to the new server's 64-bit Oracle home and change the word-size by running utlirp.sql. Check Changing the Word Size of Your Current Release.
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258674 is a reply to message #258672] Mon, 13 August 2007 06:12 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Thank you Ebrian!

What my doubt is: after I copy the database files to the new server, in 64 bit home, change the parameters to the new environment, first I need to create the database , in the new server right?
so will Oracle allow me to create the db, when the datafiles are actually in 32 bit format. -before the database is created , I can not run the utlirp.sql so , but whether the database creation statement succeed on the new server (where the word size is different)?

Thanks,
Nirav

[Updated on: Mon, 13 August 2007 06:26]

Report message to a moderator

Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258719 is a reply to message #258674] Mon, 13 August 2007 08:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should do a backup of the database prior to copying it to the new 64-bit platform. Once you copy the appropriate config files and the database to the new host, you should be able to start the database with STARTUP MIGRATE and then run utlirp.sql. The database will already be created because you are copying it from your old platform.
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258726 is a reply to message #258719] Mon, 13 August 2007 08:21 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Thank you very much Ebrian. This helps me a lot!
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258734 is a reply to message #258726] Mon, 13 August 2007 08:43 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Ebrian,

Here is one more doubt:

The directory structures and hence all the CRD file locations in the two servers are totally different. -Like in the existing server it is like /u01 and in the new server it is like /app
so the datafile locations in the two servers are different. So with a simple copy of the datafiles, the database will not get created right? -because the location of controlfiles etc will all be different in the new server..

With thanks,
Nirav

[Updated on: Mon, 13 August 2007 08:45]

Report message to a moderator

Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258749 is a reply to message #258734] Mon, 13 August 2007 09:11 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
I saw the metalink note: 62290.1, which details the same process.

But here is the problem: the control file location can be changed (by editing the init.ora file) but the information in the control file still will point to that old locations which are no longer valid so how to change that? - I mean the new datafile locations are totally different but this info. is not updated in the control file (as control file is simply copied from old server to new server) so what is to be done to change this data to reflect the new locations?


Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258757 is a reply to message #258749] Mon, 13 August 2007 09:33 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Ebrian:

My confusion which I described earlier is resolved..I need to start the database in mount mode and then rename the datafile/log files to the new location so that takes care of all the location related issues.

Thank you for suggesting a very effective way to achive the task.

Thanks,
Nirav
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258799 is a reply to message #258757] Mon, 13 August 2007 10:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
nirav_hyd wrote on Mon, 13 August 2007 10:33

My confusion which I described earlier is resolved..I need to start the database in mount mode and then rename the datafile/log files to the new location so that takes care of all the location related issues.

That's correct. Sorry I wasn't able to get back to your earlier post sooner.
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #259120 is a reply to message #258799] Tue, 14 August 2007 08:06 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
That's fine, important thing was correct approach so thanks a lot for suggesting the same!

Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #260713 is a reply to message #258672] Mon, 20 August 2007 14:58 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
ebrian wrote on Mon, 13 August 2007 07:01
You should be able to simply copy your database to the new server's 64-bit Oracle home and change the word-size by running utlirp.sql. Check Changing the Word Size of Your Current Release.


What you have said is correct.

I have upgraded from 816 32-bit to 817 64-bit but on the same machine. Did run the "utlirp.sql" as needed. What it does is that it invalidates all the objects and recompiles them again. Where as "utlrp.sql" just compiles invalid objects.

Nirav, you said that you are going from 9207 to 9207, this is good. But is the OS same between the old and new h/w ? I suppose YES.

Another thing is the LIB folder. Since you will be using 64-bit Oracle, you will have 2 libs (64bit and 32 bit).

?/lib = 64 bit lib - DEFAULT
?/lib32 = 32 bit lib.

Make sure your LIBPATH is set correctly with the 64 bit lib infront of 32 bit lib (since you are using 64 bit now). If for any reasons this does not work, then you swap the 32 and 64 bit lib.

I had a situation where my "oracle" login had 64 bit lib in front while some of the developers had the 32 bit lib in front.

LD_LIBRARY_PATH=/u01/app/oracle/product/9.2.0/lib:/u01/app/oracle/product/9.2.0/lib32:/lib:.....

Good luck.
--
Sanjay B.
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #260895 is a reply to message #260713] Tue, 21 August 2007 04:00 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Thanks for sharing your experience Sanjay. My libpath on target server is like: $ORACLE_HOME/lib ..so I think it should be good.

We have solaris 8 on source server and solaris 10 on target server, I guess that should be ok...

Thanks again...
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #260913 is a reply to message #260895] Tue, 21 August 2007 04:35 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Typically LD_LIBRARY_PATH does not need to be set for Solaris, unless an application requires it.
Re: Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #261747 is a reply to message #260913] Thu, 23 August 2007 08:46 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
ebrian wrote on Tue, 21 August 2007 05:35
Typically LD_LIBRARY_PATH does not need to be set for Solaris, unless an application requires it.


I think that is true ....

I have worked in various falours of UNIX so I get confused with the oracle as well as OS requirements. So I basically set LIBPATH and copy the same over to LD_LIBRARY_PATH and SH_LIBPATH just to be in the safe side.

LIBPATH = $ORACLE_HOME/lib:$ORACLE_HOME/lib32 .....
LD_LIBRARY_PATH = $LIBPATH
SH_LIBPATH = $LIBPATH

And BTW, I think going from Solaris 8 to 10 should not be a problem. I have never done so ...
--
Sanjay B.
Previous Topic: Help me for Connect SYSDBA
Next Topic: Defragmenting
Goto Forum:
  


Current Time: Thu Dec 08 10:03:31 CST 2016

Total time taken to generate the page: 0.11421 seconds