How Can I Verify What Specific Version of Oracle Enterprise Manager I have Installed?

I am working on a new Oracle server for the first time at a client site. I'm trying to find out what specific version number or level that is installed for Oracle. I know it's Oracle 10g. but I'm looking for the entire version level of the Oracle DB. For example: 10.1.2xxx.

Is there an Oracle file I can view or program inside of Oracle Enterprise Manager that I can view? Thanks!
matrix0511Asked:
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.

AndytwCommented:
To find out version information you don't need to look in enterprise manager, you can just query the database using the following in SQL*Plus
For enterprise manager:
SELECT comp_id, comp_name, version, status
FROM   dba_registry;

and for the database version:
SELECT *
FROM   v$version;
SQL> l
  1  SELECT  comp_name, version, status
  2* FROM   dba_registry
SQL> /
 
COMP_NAME                                VERSION         STATUS
---------------------------------------- --------------- -----------
Oracle XML Database                      10.2.0.4.0      VALID
Oracle Enterprise Manager                10.2.0.4.0      VALID
Oracle Data Mining                       10.2.0.4.0      VALID
OLAP Catalog                             9.2.0.6.0       INVALID
Oracle Ultra Search                      10.2.0.4.0      INVALID
Oracle Text                              10.2.0.4.0      VALID
Spatial                                  10.2.0.4.0      VALID
Oracle interMedia                        10.2.0.4.0      VALID
Oracle Workspace Manager                 10.2.0.4.3      VALID
Oracle Database Catalog Views            10.2.0.4.0      VALID
Oracle Database Packages and Types       10.2.0.4.0      VALID
JServer JAVA Virtual Machine             10.2.0.4.0      VALID
Oracle XDK                               10.2.0.4.0      VALID
Oracle Database Java Packages            10.2.0.4.0      VALID
OLAP Analytic Workspace                  9.2.0.6.0       INVALID
Oracle OLAP API                          9.2.0.6.0       INVALID
 
16 rows selected.
 
SQL> SELECT *
  2  FROM   v$version
  3  /
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Open in new window

0

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
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.