• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 643
  • Last Modified:

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

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now