Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to determine 32 and 64bit version of Oracle 8.1.7

Miloslav
Occasional Visitor

How to determine 32 and 64bit version of Oracle 8.1.7

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.
4 REPLIES
Hari Kumar
Trusted Contributor

Re: How to determine 32 and 64bit version of Oracle 8.1.7

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
Information is Wealth ; Knowledge is Power
Hari Kumar
Trusted Contributor

Re: How to determine 32 and 64bit version of Oracle 8.1.7

$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

Information is Wealth ; Knowledge is Power
Jean-Luc Oudart
Honored Contributor

Re: How to determine 32 and 64bit version of Oracle 8.1.7

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
fiat lux
Yogeeraj_1
Honored Contributor

Re: How to determine 32 and 64bit version of Oracle 8.1.7

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)