Re: 64-bit RDBMS server question

On 2/2/07, Mike Schmitt <mschmitt_at_uchicago.edu> 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

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