Re: help determine 64-bitness of solaris x86 opteron install

foothillbiker_at_gmail.com wrote:
> All,
>
> I've installed what is allegedly 64bit oracle on 64bit solaris x86-64
> platform.
>
> The actual s/w I've installed is from
> 10201_database_solx86_64.zip
> so that seems promising.
>
> The o/s seems to be on board too:
> $ isainfo
> amd64 i386
>
> I created a db, and went ahead and applied the patchset:
> p4547817_10202_Solaris86-64.zip
>
> The binaries seem to be 64-bit:
> $ file oracle
> oracle: ELF 64-bit LSB executable AMD64 Version 1, dynamically
> linked, not stripped
>
> **BUT** I am not getting love from the banner, or v$version, where
> /thought/ the 64-bitedness is supposed to be celebrated:
>
> $ sqlplus system
>
> SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 1 00:00:03 2007
>
> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>
> Enter password:
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
> With the Partitioning, Oracle Label Security, OLAP and Data Mining
> Scoring Engine options
>
> SQL> select * from v$version
> 2 /
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
> PL/SQL Release 10.2.0.2.0 - Production
> CORE 10.2.0.2.0 Production
> TNS for Solaris: Version 10.2.0.2.0 - Production
> NLSRTL Version 10.2.0.2.0 - Production
>
>
> Anybody else out there have collaborating data?
>
> Am I, or am I not 64-bit?
>
> Thanks.
>
> Regards,
> fhb.

On various platforms 32-bit development has been discontinued starting with 10g. Oracle may have adjusted the banner accordingly: 64 bit is the default now, so doesn't need to be specified. You could check the libraries in $ORACLE_HOME/lib, and find out whether there is an $ORACLE_HOME/lib32 directory, and the setting of $LD_LIBRARY_PATH.
But personally I would stop worrying.

Hth and Happy New Year

-- 
Sybrand Bakker
Senior Oracle DBA