Re: Oracle 32 bit Vs 64 bit

How do you plan to "point the datafiles to the disks...."? Aside from the 64-bit/32-bit thing, what mechanism are you going to use to plug them in? External tables? Transportable tablespaces? External tables will be most portable, but is very similar to exp/imp (basically a sqlldr behind the scenes, if I read it correctly). I am not exactly sure about Transportable tablespaces - I would have to go back to the online docs: http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#ADMIN01101

Looks like the big deal is the "endianess" of the platform, which should not be an issue for you. As long as the 64-bit host can read the 32-bit datafile headers, you should be golden. I will wait for someone else to come along and correct me on that.... =)

On 9/6/06, Nirmalya Das <nirmalya_at_hln.com> wrote:
>
> Sorry forgot to mention that we are in 10g release 1....
>
> Now I have a brand new box with 64 bit oracle installed. Not upgrading,
> it is a
> new install. I am just trying to find out the easiest and fastest way
> to do the
> data movement. Trying to avoid exp from 32 bit and imp into 64 bit. So
> thought
> about bring the hard drive containg data from 32 bit machine to the 64
> machine.
> If I create the tablespaces on 64 bit and point the datafiles to the
> disks that
> I brought over will that work?
>
> Quoting Charles Schultz <sacrophyte_at_gmail.com>:
>
> > It is my understanding that this will not work due to the different word
> > size - the 64-bit software will point to different locations than your
> > 32-bit software. What version are you dealing with? If you are going
> from
> > anything lower than 10gR1 to 10gR2, the upgrade will automatically
> convert
> > the word size. If you are coming from 10gR1, there is a rather simple
> script
> > you can run to accomplish this during the upgrade.
> >
> > So in essence, you could clone the database (via mirrors, if you like),
> > upgrade as documented and you should be all set.
> >
> > On 9/6/06, Nirmalya Das <nirmalya_at_hln.com> wrote:
> >>
> >> Currently we run Oracle standard edition (32 bit) on RHEL release 4 on
> an
> >> IBM
> >> 345 (x86) with 6GB of memory.
> >>
> >> Here's what I am trying to accomplish:
> >>
> >> 1. Trying to figure out whether 64 bit Oracle will improve performance.
> >>
> >> I will appreciate if anyone could share their experience who has done
> such
> >> testing already and have established a performance matrix.
> >>
> >> 2. I am setting up a machine with 64 bit oracle. Trying to figure out
> the
> >> fastest way to set up the database with data from an existing 32 bit
> >> database.
> >>
> >> I am trying to avoid exp/imp process really.
> >>
> >> Here's what I am thinking:
> >>
> >> - install 64 bit oracle on the new machine
> >> - create an empty database.
> >> - break the mirror (data disks) from the 32 bit machine and bring one
> >> set of
> >> data disks to the new machine.
> >> - create new tablespaces on the new machine and point the datafiles
> to
> >> newly
> >> acquired disks with data from the 32 bit machine.
> >>
> >> Do you think that will work?
> >> Is this a crazy idea......
> >> If it works but the performance gain from 64 bit Oracle is nothing then
> >> take
> >> those data disks and move it to the old 32 bit machine.
> >>
> >> Thanks all for your input.
> >>
> >> Nirmalya
> >> --
> >> http://www.freelists.org/webpage/oracle-l
> >>
> >>
> >>
> >
> >
> > --
> > Charles Schultz
>
>
>

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l