64 bit client accessing 32 bit server? 
Author Message
 64 bit client accessing 32 bit server?

I know this is the opposite of what most people do, but I wanted to
know if it possible to use a 64 bit Oracle client to access a 32 bit
server (8i would be prefered with migration to 9i later)?  Ideally, I
would like to have the option of accessing an Oracle server either on
the same machine or on a remote machine via SQL*Net.

The motivation is the need to build a very large in-memory model (4 -
8GB) on an application server, thus the application server needs the
64 bit address space.  Since 32-bit Oracle is more than sufficient to
manage the database and more mainstream than 64-bit Oracle, I would
prefer not to make 64 bit Oracle a requirement of the architecture.

If it is relevant, the application server will most likely be using
OCI to access the database.  As far as platform goes, it is a
multi-platform application supporting Solaris, HPUX, AIX, and Tru64.

Finally, does anyone know whether there would be an incremental
licensing charge for the 64 bit client?  I believe the 64 bit server
can be more costly to license than the 32 bit server, but assuming
that you have a properly licensed 32 bit Oracle server can you use
either 32 bit or 64 bit clients at your discretion (without
incremental cost)?  My apologies if the licensing question is off
topic for this group.

Thanks!
Dan



Sun, 01 Aug 2004 02:36:46 GMT
 64 bit client accessing 32 bit server?

No problem to connect with a 64-bit Oracle Client to a 32-bit server.
No problem the reverse way either. Even a SQLNET 2.3.4 Client can
connect to 64-bit server (if no UTF character set). The only thing is:
use sqlnet and not a shared memory connection. So the connect string

listener running on the server. The old-fashioned way, where the
ORACLE_SID environment variable is used to indicate the database, can
not be used in your case.

With regards to the licensing question, Oracle Corporation does not
charge extra fee for 64-bit versions. Unless the new per seat or
processor metrics have changed.

Edzard

Quote:

> I know this is the opposite of what most people do, but I wanted to
> know if it possible to use a 64 bit Oracle client to access a 32 bit
> server (8i would be prefered with migration to 9i later)?  Ideally, I
> would like to have the option of accessing an Oracle server either on
> the same machine or on a remote machine via SQL*Net.

> The motivation is the need to build a very large in-memory model (4 -
> 8GB) on an application server, thus the application server needs the
> 64 bit address space.  Since 32-bit Oracle is more than sufficient to
> manage the database and more mainstream than 64-bit Oracle, I would
> prefer not to make 64 bit Oracle a requirement of the architecture.

> If it is relevant, the application server will most likely be using
> OCI to access the database.  As far as platform goes, it is a
> multi-platform application supporting Solaris, HPUX, AIX, and Tru64.

> Finally, does anyone know whether there would be an incremental
> licensing charge for the 64 bit client?  I believe the 64 bit server
> can be more costly to license than the 32 bit server, but assuming
> that you have a properly licensed 32 bit Oracle server can you use
> either 32 bit or 64 bit clients at your discretion (without
> incremental cost)?  My apologies if the licensing question is off
> topic for this group.

> Thanks!
> Dan



Mon, 02 Aug 2004 05:48:46 GMT
 64 bit client accessing 32 bit server?
Oracle provides a 64-bit version of its server, but I would be HIGHLY
surprised if a 64 bit client exists.  Comments?


Tue, 03 Aug 2004 01:20:29 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. 32-bit Clients to 64-bit Oracle Server

2. 32-bit client to 64-bit server

3. Interoperability of 32-bit and 64-bit client/server

4. 32-bit and 64-bit client/server interoperability

5. 64-bit SQL Server and 32-bit dlls question

6. 32-bit Oracle Server on 64-bit Solaris?

7. Join between 32-bit and 64-bit servers

8. Performance: 32-bit SE vs. 64-bit EE

9. Changes in 64 bit Oracle from 32 bit

10. Moving from 8.1.7 32-bit to 8.1.7 64-bit

11. 8.0.5 32-bit on HP-UX 11.0 64-bit

12. 64-bit or 32-bit word size?


 
Powered by phpBB® Forum Software