Re: 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 must be something like user/password_at_tnsname and you must have the 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

danberkery_at_yahoo.com (Dan Berkery) wrote in message news:<d5831952.0202121036.706c17d_at_posting.google.com>...
> 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
Received on Wed Feb 13 2002 - 15:48:46 CST