How to know if a oracle installation is to 32 or 64 bytes?

[azulita]

How to know if a oracle installation is to 32 or 64 bytes?

Thanks but I am new in Oracle.

 

[SantaMufasa]

Little-Blue,

Issue the following query:

select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - [b]64bit Production[/b]

The above is 64-bit. The following is 32-bit:

select * from v$version;

BANNER
----------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

Notice if the installation is 64-bit, it says so; if not, there is no "bit" message.

Let us know what you find.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[hoinz]

Hello,

there is one point to add to Dave's advice,
because the sentence
"if the installation is 64-bit, it says so"
may be misleading.

For instance, for our Oracle 9i on Tru64 Unix we have this:

select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production

Nevertheless I am quite sure that it is 64 bit,
just because there doesn't exist an Oracle 9i 32 bit for Tru64.

So the first question should be:
Is there both a 32 bit and a 64 bit version for my OS?

Only if the answer is 'yes',
you need query v$version,
and only in this case you may rely on the answer.

regards

 

[SantaMufasa]

That is correct, Hoinz. I actually never noticed that apparent anomaly before. (Not a good choice on Oracle's part if you ask me.) So, given this fact, I am not aware of a definitive, empirical method of querying whether a particular version of Oracle is a 32- versus 64-bit configuration. Does anyone else have a suggestion?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[azulita]

Hello!

I found a answer,
If you run in $ORACLE_HOME/bin

file oracle

this is the answer:

oracle: 64-bit XCOFF executable or object module not stripped

I think that is the solution but what do you think?

Thanks

Azulita

 

[SantaMufasa]

Little-Blue,

Unfortunately, we are back at the original problem with the DEC-Alpha environment not explicitly showing 64-bit Oracle:

alpha:/dbsrv/oracle/app/oracle/product/8.1.6/bin$ file oracle
oracle: COFF format alpha dynamically linked, demand paged executable or object module not stripped - version 3.13-12

So, nothing stating 64-bit here, either.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.