| Moving a 32 bit Oracle 9i database to 64 bit on a different server [message #258666] |
Mon, 13 August 2007 05:22  |
orausern
Messages: 826
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 #258674 is a reply to message #258672] |
Mon, 13 August 2007 06:12  |
orausern
Messages: 826
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 #258734 is a reply to message #258726] |
Mon, 13 August 2007 08:43 |
orausern
Messages: 826
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 |
orausern
Messages: 826
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 #260713 is a reply to message #258672] |
Mon, 20 August 2007 14:58 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
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 #261747 is a reply to message #260913] |
Thu, 23 August 2007 08:46 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
