Link to home
Create AccountLog in
Avatar of rrowe73
rrowe73

asked on

How do you tell what version (standard or enterprise) of Oracle server that you are running on a Windows server

Hi everyone,

i was given a task to identify the version of Oracle running on our servers (whether the version is enterprise or standard.)  I haven't been able to find this out (I know NOTHING about Oracle).

I Googled for the answer: http://vicker313.wordpress.com/2009/05/16/how-to-check-oracle-10g-is-standard-or-enterprise-edition/ 

This doesn't help me.  None of the servers with supposedly version 10 installed had an entry for (VAL).  

I need to know how to find out the version type for versions 10 & 11 of Oracle.  I have about 50 servers I have to go through so if you have some tips, I'd appreciate it!!

Thank you
Avatar of sventhan
sventhan
Flag of United States of America image

select * from v$version
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
select * from v$version
You can find the version info by connecting to SQL plus too

SQL*Plus: Release 10.1.0.4.2 - Production on Wed Dec 29 15:24:08 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

  2  
sqlplus can have a very diffrent release that the database itself.

From   Release 9 and up you can do
SELECT * FROM DBA_REGISTRY
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>>sqlplus can have a very diffrent release that the database itself.

sventhan was pointing out the piece after "Connected to:".  That is the database info not the client info.
to just know the version you can also run

select version from v$instance;
>>to just know the version you can also run

Maybe so but that isn't the complete question.  There are several views to get all this information but v$version is probably the best for what was asked.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
>>'compatible'

this does not guarantee the version installed.
Avatar of rrowe73

ASKER

Is there a config file or something I can look at rather than having to connect to the database? I don't have admin rights to the databases themselves.  No one seems to know the admin password.  

thanks folks
The problem is there could be multiple oracle homes with different versions or patches applied.

The opatch utility from each oracle home can probably tell you but I can't test right now since I'm on mobile.

The only way I know of for sure is connect to the database.

If no ones knows the passwords, you have bigger issues.

As long as your user is in the dba group (dba on unix or ora_dba on windows) then you can always connect: / as sysdba
I should add the "/ as sysdba" is the most powerful user you can connect as, SYS.

You should not do it unless you know what you are doing.  It can get you into a lot of trouble.
Avatar of rrowe73

ASKER

Nevermind, we found the key in the registry:
for 11g: HKLM>SOFTWARE>ORACLE>KEY_ORA11G under the key: oracle_bundle_name
it will tell you Enterprise or Standard

for 10g: HKLM>SOFTWARE>ORACLE>KEY_ORA10G under the key: oracle_bundle_name
it will tell you Enterprise or Standard

Thanks anyway folks.  

I know someone knows the password... it's just trying to get them to help that is the real problem.  
That does not tell you the version unless 10g/11g is good enough for you.  Oracle has two major releases of both:  R1 and R2.

Also if there are multiple Oracle Homes on the machine it will not tell you what the version of running databases is.

The most accurate way is to ask the database itself with the information provided.
The only thing we forgot to tell you is, look at the oracle installation CD cover. Thats the easiest way to find the version info without touching the system. Most of the time it works for me ;)

Wish you all very Happy New Year 2011!!!
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of rrowe73

ASKER

Although these did not help me, I am going to just accept these since the "experts" won't allow me to close this without giving someone credit for it.  

What worked for me was what I listed in my previous post... maybe one of these "solutions" will help someone else.  

Wasn't looking for the release (R1 or R2) - only needed to know whether it was standard or enterprise because apparently they are looking to renew the licensing on this.  

thanks folks for your assistance.
Because @slightwv raised an objection you cannot give him points. Actually points have to be given to  ID:34444217  -  Author:sventhan
I am not the user who asked the question and I cannot use request_attention function. I am the one who also provided solution.
I'm really Happy to see some one get the points. In fact slightwv's answer is more clear than mine. Its kind of difficult to answer this question.



Things just fine. Thanks to the author for the rewards.

@seventhan you are really down to earth...
I think we all answered this question at the same time with few seconds difference in hitting the submit button.
Avatar of rrowe73

ASKER

I give up. Split up the points however you see fit.
Avatar of rrowe73

ASKER

Yeah well everyone seems to have an issue with it so that's why I said that.  I am done with the site (cancellation pending).  I figured everyone could argue it out to their heart's content.  I don't want to be bothered with this anymore.