LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-12-2011, 10:51 PM   #1
syedkaleem
LQ Newbie
 
Registered: Jan 2011
Posts: 1

Rep: Reputation: 0
shifting database from 32 bit linux to 64 bit


Hi,
I have been ordered to transfer my database running on oracle 10g on linux 32 bit OS to linux 64 bit. I need to know the advantages of 64 bit over 32 bit. Besides i would like to know if would face any difficulty while i migrate the database from 32 bit to 64 bit.
I would be thankful if you would tell me the proper method in steps.

Thanks a lot!!!!!!!!!
 
Old 01-12-2011, 11:07 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Hi, welcome to LQ!

It will depend on a lot of factors whether there's a benefit in
the move, and how much of a benefit you may or may not see.

What's the size of your DB? Specs of the machine, how much RAM
do you have, will the move from 32 to 64 bit also swap hardware?

As for the how: commonly you'll dump your DB, install the new OS,
reinstall your DB (as the 64-bit version), load the dump.


Cheers,
Tink
 
Old 01-13-2011, 04:52 PM   #3
jefro
Moderator
 
Registered: Mar 2008
Posts: 15,691

Rep: Reputation: 2264Reputation: 2264Reputation: 2264Reputation: 2264Reputation: 2264Reputation: 2264Reputation: 2264Reputation: 2264Reputation: 2264Reputation: 2264Reputation: 2264
Oracle has great documentation. I think I saw an integrated linux and oracle distro or set of dvd's to make the install. The deployment guides should show how to stop and move the database safely.

It may be that you can do a live upgrade in place too or live state replication.
 
Old 01-13-2011, 06:12 PM   #4
johnsfine
LQ Guru
 
Registered: Dec 2007
Distribution: Centos
Posts: 5,286

Rep: Reputation: 1181Reputation: 1181Reputation: 1181Reputation: 1181Reputation: 1181Reputation: 1181Reputation: 1181Reputation: 1181Reputation: 1181
Quote:
Originally Posted by syedkaleem View Post
I have been ordered to transfer my database running on oracle 10g on linux 32 bit OS to linux 64 bit.
Are you changing just the Linux OS from 32 bit to 64 bit, or also changing the Oracle database software from 32 bit to 64 bit?

I don't know anything about the Oracle software, most importantly I don't know whether there is a 64 bit version available and I don't know whether the installer for the 32 bit version will tolerate a 64-bit Linux. (I would wild guess that both are true: there is a 64-bit version and the 32-bit version will also install on a 64-bit Linux. But I'm just guessing.)

Quote:
I need to know the advantages of 64 bit over 32 bit.
A 64-bit OS will probably do a much better job running a 32-bit application, especially a database application, than a 32-bit OS would.

A 32-bit application gets a 4GB virtual address space on a 64-bit OS compared to a 3GB virtual address space on a 32-bit OS. If you have a lot of physical ram, the 64-bit OS can also be more flexible in use of shared regions (which are important to some database applications).

Installing a 32-bit application on a 64-bit Linux might be significantly harder than installing it on a 32-bit Linux, especially for Debian based Linux distributions (less of a problem for RedHat based). But once properly installed, a 32-bit application should run fine on a 64-bit OS, in many cases (likely for database) the 32-bit application will run better on a 64-bit OS than on a 32-bit OS.

Of course, the bigger difference between a 32-bit OS and 64-bit OS is that the 64-bit OS can run 64-bit applications.

You may intend switching to 64-bit Oracle software at the same time you switch to 64-bit Linux.

In general, 64-bit software could run faster or slower than the 32-bit version of the same software.

Typically, 64-bit software uses the same file formats as the 32-bit version of the same software. But there are exceptions: programs that need all their data files converted if you switch from 32-bit to 64-bit software.

If you intend to switch from 32-bit Oracle to 64-bit Oracle, you can't use "in general" or "typically". You need to know what happens with the specific product you are using. If you are just switching the OS and not the Oracle software, the issues are much simpler and more predictable.

Last edited by johnsfine; 01-13-2011 at 06:14 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
64 bit cpu-64 bit Ubuntu-are there 32 bit app issues? sofasurfer Ubuntu 7 04-09-2014 03:02 PM
64 bit or 32 bit Ubuntu 10.04 in a multiple boot with windows 64 and 32 bit ? james2b Linux - General 7 09-22-2010 05:12 PM
LXer: Ubuntu 32-bit, 32-bit PAE, 64-bit Benchmarks LXer Syndicated Linux News 0 12-30-2009 12:00 PM
Bit shifting 6-byte value into a u64 ranthal Linux - Kernel 5 07-07-2009 10:26 PM
64-bit or 32-bit Application on 64-bit Linux jjana123 Linux - General 4 05-06-2008 06:27 PM


All times are GMT -5. The time now is 04:08 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration