How to check the complete version of Oracle

Hi all,

I want to check the whole version of our Oracle. When I connect to sqlplus, it shows just 8.0.6.0.0.

I want to know the complete ver. like 8.0.6.1.3 or something.

How to do that?

Thanks in Adv.

Code:

---

    sqlplus user_with_dba_priv
   
      SELECT version
        FROM v$instance;

---

Sam

What you see from sqlplus is what you get. The complete version display depends on Oracle and where they choose to have the patches update the version information. I ran into the same issue when I applied patches 1 and 2 to our 8.1.7.0.0 install. After the first patch it showed 8.1.7.2.1 but after the second patch it still showed only 8.1.7.2.1, not 8.1.7.2.5 like it should have. The readme.txt sent with the patch will tell you if it will change the version numbers.

Personally, I think it stinks. If I apply a patch, I should see it in the version numbers. How else are you going to know what patch you applied.

Hi Sam,
SELECT version
FROM v$instance;

shows me Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production.

Actually, we have server partition with Oracle Apps 11i. We have two Homes 8i and 806. I know 8i ver. it is 81730.

I want to check similarly for 806 home.

With sqlplus, it shows 8.0.6.0.0.

I still can't check that.

Any help?

Thanks,

Looks like that is the 8.0.6 base and there had not been any patches applied to it.

Sam

Try to check:

../oraInventory/Components/oracle.rdbms/*
It should to show oracle version and all pathes for rdbms.

Did oracle inventory play any role in 8.0 version? oraInventory was in use as of 8i I presume. One other place to look for the database version would be the alert_log

I might be wrong!

Sam