Re: 64-bit RDBMS server question
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: mschmitt@xxxxxxxxxxxx
- Date: Fri, 2 Feb 2007 11:00:30 -0800
On 2/2/07, Mike Schmitt <mschmitt@xxxxxxxxxxxx> wrote:
We have setup a 64-bit Linux server with 64-bit Oracle 10g binaries. The
vendor has now come back and said they do not support the database running
as 64-bit, even though there are no application components that run on the
database server. Are there any differences in datatypes between 64-bit and
32-bit database software? My understanding is that they are identical to
the client. Can you think of any problems that 32-bit client software, or
jdbc connections would have with connecting to a 64-bit database on a
different server?
The only issue might be patch levels and bugs unique to the 64 bit
environment.
The 32 bit and 64 bit datafiles are identical.
The control files are not identical. I restored a 64bit database to a 32
bit
server. The datafiles were fine, but restoring the control file would never
quite work. I don't know the difference in control file between the 2
platforms,
but the database worked after manually creating a control file.
The point being that the client cannot discern through normal operation
the memory structure of the database server.
Some apps might be very picky about such things however.
SAP comes to mind...
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
