cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Version?

SOLVED
Go to solution
Emanuele Croci
Occasional Contributor

Oracle Version?

Hi,
how can I see the oracle version (32/64 bit) I installed on my HP-UX system?
Is there an Oracle command for this?

Best regards
Emanuele
6 REPLIES
Steve Steel
Honored Contributor

Re: Oracle Version?

Hi

oracle uses an alert log

for our tst system it is

/oracle_base/admin/tst/bdump/alert_tst.log

This contains all data

pg /oracle_base/admin/tst/bdump/alert_tst.log
Mon Nov 26 09:18:25 2001
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 31457280
large_pool_size = 614400
java_pool_size = 20971520
control_files = /oracle_base/oradata/tst/control01.ctl, /oracle_bas
e/oradata/tst/control02.ctl, /oracle_base/oradata/tst/control03.ctl
db_block_buffers = 2048
db_block_size = 8192
compatible = 8.1.0
log_buffer = 163840
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
db_domain = crc
distributed_transactions = 10

Just extract the data from there


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Sebastian Galeski_1
Trusted Contributor

Re: Oracle Version?

try to use command file on file oracle:
#file ../product/8.1.7/bin/oracle

regards seba
Thierry Poels_1
Honored Contributor
Solution

Re: Oracle Version?

Hi,

select * from v$version;

--> if Oracle 64bit is installed, it will be mentionned

--> if Oracle 32bit is installed, there will be NO reference to 32 nor 64 bit.

regards,
Thierry.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.
Emanuele Croci
Occasional Contributor

Re: Oracle Version?

Hi,
I already know the command:
file oracle

but I would like to know if an oracle command exists to see if the version is 32 or 64 bit.

In the file "alert_CBA.log" there is not this information.

Best regards
Emanuele

T G Manikandan
Honored Contributor

Re: Oracle Version?

Hello,

When you do a

$svrmgrl

you should get whether it is 32 bit or 64 bit.

Also
doing a sqlplus should give you that


$sqlplus system/"password"@sid


Thanks
Yogeeraj_1
Honored Contributor

Re: Oracle Version?

Hello,

Hope this helps!

system@CMTDB.CMT.MU> select * from v$version;

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

system@CMTDB.CMT.MU>
---

Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)