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
rrowe73Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sventhanCommented:
select * from v$version
slightwv (䄆 Netminder) Commented:
Connect to the database then:
select * from v$version;

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
anumosesCommented:
select * from v$version
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

sventhanCommented:
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  
anumosesCommented:
sqlplus can have a very diffrent release that the database itself.

From   Release 9 and up you can do
SELECT * FROM DBA_REGISTRY
slightwv (䄆 Netminder) Commented:
>>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.
anumosesCommented:
to just know the version you can also run

select version from v$instance;
slightwv (䄆 Netminder) Commented:
>>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.
SharathData EngineerCommented:
try these also.

select distinct version from dba_feature_usage_statistics;

select * from product_component_version;

select value from v$system_parameter where name = 'compatible';
slightwv (䄆 Netminder) Commented:
>>'compatible'

this does not guarantee the version installed.
rrowe73Author Commented:
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
slightwv (䄆 Netminder) Commented:
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
slightwv (䄆 Netminder) Commented:
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.
rrowe73Author Commented:
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.  
slightwv (䄆 Netminder) Commented:
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.
sventhanCommented:
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!!!
slightwv (䄆 Netminder) Commented:
The more I think about your reason for closing this out, I feel I have to object.

We provided a few answers to the question asked.  Even more accurate answers to the solution you chose to go with.

Just because you chose to not take our solutions does not mean they were not valid solutions.

I would suggest a split between: http:#a34444217 and http:#a34444458 for the  product_component_version view.
rrowe73Author Commented:
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.
anumosesCommented:
Because @slightwv raised an objection you cannot give him points. Actually points have to be given to  ID:34444217  -  Author:sventhan
anumosesCommented:
I am not the user who asked the question and I cannot use request_attention function. I am the one who also provided solution.
sventhanCommented:
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.

anumosesCommented:
@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.
rrowe73Author Commented:
I give up. Split up the points however you see fit.
rrowe73Author Commented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.