Showing version number

[ocp2b]

I just applied a patch to my version of Oracle (8.1.7.2.1) on a WinNT 4.0 machine. According to the patch:

Note: All the products supplied in this patch may NOT display
the version Number 8.1.7.2.5, because of cumulative patch.

Oracle Server version number is displayed as 8.1.7.2.1.


Is there a way to verify that the patch was actually installed? If I can't verify the version number through v$version, then how do I verify it is being used?

Thanks.

[Mr.Hanky]

clear
SET HEAD ON
SET VERIFY OFF
col instance_name form a8 Heading "Instance"
col name form a8 Heading "DB Name"
col host_name form a12 Heading "Hostname"
select version
,name
,log_mode
,host_name
,created
/* ,open_mode - v8i only */
from v$database, v$instance;


Try this script, I put it on all my boxes (Unix and NT) as a quick reference. I named it NAME.SQL this way all I have to do is type name at a SQL prompt and I will know what instance I am logged into. If you support multiple instance this is a real timesaver. Beats the heck out of ..
SQL> select * from global_name;

MH

Ps. I think I stole this script from this webpage.

[mike73]

opc2b,

even after you apply the 8.1.7.2.5, you won't see the 5 and you still see 8.1.7.2.1. As long as you follow the instructions to aplly the 8.1.7.2.5 patchset , you should be ok

[ocp2b]

Unfortunatly, it does show what I want. It does show version 8.1.7.2.1, but I'm still not able to verify that the patch was successfully installed. I guess I just have to go on faith that the patch was successful if my DB doesn't crash. (Which is a huge leap of faith being that we are talking about Oracle Corp.)