topic Re: Oracle Version? in Operating System - HP-UX

Oracle Version?

Emanuele Croci — Fri, 05 Jul 2002 08:44:35 GMT

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

Re: Oracle Version?

Steve Steel — Fri, 05 Jul 2002 08:59:58 GMT

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

Re: Oracle Version?

Sebastian Galeski_1 — Fri, 05 Jul 2002 09:04:12 GMT

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

regards seba

Re: Oracle Version?

Thierry Poels_1 — Fri, 05 Jul 2002 09:16:46 GMT

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.

Re: Oracle Version?

Emanuele Croci — Fri, 05 Jul 2002 09:18:02 GMT

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

Re: Oracle Version?

T G Manikandan — Fri, 05 Jul 2002 09:28:49 GMT

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

Re: Oracle Version?

Yogeeraj_1 — Mon, 08 Jul 2002 11:16:38 GMT

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