Re: Determine if 32-bit or 64-bit installed

Ed,

When connecting via SQL*PLUS as system you will recieve this type of message:

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

Note the 64 bit production message on databases with 64 bit installations.

Good luck,
Patrick

Ed Stevens <nospam_at_noway.nohow> wrote in message news:<hppr6v4cn48oiqgc46fhirheh95i2vvedh_at_4ax.com>...
> Platform: Sun Solaris, Oracle 8.1.7.0.0
>
> We recently installed 8.1.7.0.0 on three Sun Solaris boxes. Now we
> need to apply the 8.1.7.4 patch/upgrade. Unfortunately, no one seems
> to know for sure if we are running the 32-bit or 64-bit version of
> Oracle (long story, involves application vendor!)
>
> So my question is, is there a query or a log file that will tell me if
> I'm 32-bit or 64-bit? I thought v$version might, but that only
> yeilded
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> PL/SQL Release 8.1.7.0.0 - Production
> CORE 8.1.7.0.0 Production
> TNS for Solaris: Version 8.1.7.0.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
>
> SQL>
Received on Tue Mar 11 2003 - 13:14:05 CST