-
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.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Code:
sqlplus user_with_dba_priv
SELECT version
FROM v$instance;
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Looks like that is the 8.0.6 base and there had not been any patches applied to it.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|