How to determine 32 and 64bit version of Oracle 8.1.7

[Miloslav]

Hello,

do you know how to determine 32 and 64bit version of Oracle 8.1.7. When i log in, i see just 8.1.7 but nothink more. I need to apply patch, but i have to know the version.

[Hari Kumar]

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
PL/SQL Release 9.0.1.4.0 - Production
CORE 9.0.1.2.0 Production
TNS for 32-bit Windows: Version 9.0.1.4.0 - Production
NLSRTL Version 9.0.1.4.0 - Production

When u login tou your sqlplus, itself you can see the information of Version the 32 or 64 bit e.t.c

[Hari Kumar]

$sqlplus /


SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002


(c) Copyright 2001 Oracle Corporation. All rights reserved.



Connected to:
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.2.0 - Production


SQL>

There it gives me the required information,
If we need to check the OS version
$getconf KERNEL_BITS

[Jean-Luc Oudart]

As mentioned select * fom v$version.
We have oracle 8i
~~~~~~~~~~~~~~~~~~~~~
SVRMGR> select * from v$version
2> /
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for HPUX: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
5 rows selected.

~~~~~~~~~~~~~~~~~~~~~~~~~~~

Rgds,
Jean-Luc

[Yogeeraj_1]

hi,
-
They have had many similar questions in that past!
see:
*
http://search.hp.com/redirect.html?url=http%3A//forums.itrc.hp.com/cm/QuestionAnswer/1,,0x725b35a43b46d71190080090279cd0f9,00.html&qt=oracle+%2B32+%2B64+%2Bbits&hit=4
-&
http://search.hp.com/redirect.html?url=http%3A//forums.itrc.hp.com/cm/QuestionAnswer/1,,0x868493e260b0d611abdb0090277a778c,00.html&qt=oracle+%2B32+%2B64+%2Bbits&hit=8
*
You many others concerning patch installation too!
*
regards
Yogeeraj