- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle Version?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 01:44 AM
тАО07-05-2002 01:44 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 01:59 AM
тАО07-05-2002 01:59 AM
Re: Oracle Version?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 02:04 AM
тАО07-05-2002 02:04 AM
Re: Oracle Version?
#file ../product/8.1.7/bin/oracle
regards seba
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 02:16 AM
тАО07-05-2002 02:16 AM
Solutionselect * 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 02:18 AM
тАО07-05-2002 02:18 AM
Re: Oracle Version?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 02:28 AM
тАО07-05-2002 02:28 AM
Re: Oracle Version?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2002 04:16 AM
тАО07-08-2002 04:16 AM
Re: Oracle Version?
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