Home » RDBMS Server » Server Administration » Oracle Migration Question
Oracle Migration Question [message #60778] Thu, 04 March 2004 14:33 Go to next message
sheela
Messages: 66
Registered: March 2002
Member
Hello:

We are planning to migrate our 64-bit Oracle Databases (currently on Solaris 8 64-bit) to Red Hat Linux on IBM Platform (32-bit) for cost cutting.   Which means the database will be downgraded from 64-bit to 32-bit both from the Oracle and OS Perspective. 

Is there a possiblity that this will have any impact on the databases /performance/configuration.   Are there possibilities of any serious known problems with such a migration (Specially because of Solaris - Linux and 64-32 bit).

Is it even advisable?  

If it is not , we are planning to keep them on solaris as is. 

Thanks

  
More Info. [message #60779 is a reply to message #60778] Thu, 04 March 2004 15:04 Go to previous messageGo to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
Moreover, our current database version is 9.2.0.4.0 (64-bit) on solaris 5.8 (64-bit). However I see Oracle 9i Linux version only upto 9.2.0.1.0. What will happen during the migration? Migrating a database from 9.2.0.4.0 to 9.2.0.1.0 across platforms?????
Re: Oracle Migration Question [message #60786 is a reply to message #60778] Fri, 05 March 2004 01:28 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

The migration shouldn't be a problem, as you will have to export the Solaris database and re-import it on Linux. Nevertheless, I cannot comment of the performance, you will have to benchmark the application on the Linux platform to see if performance will be acceptable.

Best regards.

Frank
Re: More Info. [message #60787 is a reply to message #60779] Fri, 05 March 2004 01:34 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

You can also upgrade the Linux box to 9.2.0.4 - download the latest patch-set from Metalink (or somebody from Oracle to download it for you) and apply it.

Best regards.

Frank
Re: More Info. [message #60788 is a reply to message #60787] Fri, 05 March 2004 09:02 Go to previous messageGo to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
Thanks.
Re: More Info. [message #60808 is a reply to message #60779] Mon, 08 March 2004 03:38 Go to previous message
Pradeep George
Messages: 6
Registered: March 2004
Junior Member
Hi ,
If you are planning to do an export and import , make sure that you are using a vresion of EXP utility which is either equals or lower than the version of your target Datbase. Otherwise the import will not be possible.
Previous Topic: datafile recovering
Next Topic: some doubt about the CKPT background process
Goto Forum:
  


Current Time: Fri Sep 20 12:51:41 CDT 2024