I just applied a patch to my version of Oracle (18.104.22.168.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 22.214.171.124.5, because of cumulative patch.
Oracle Server version number is displayed as 126.96.36.199.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?
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"
/* ,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;
Ps. I think I stole this script from this webpage.
even after you apply the 188.8.131.52.5, you won't see the 5 and you still see 184.108.40.206.1. As long as you follow the instructions to aplly the 220.127.116.11.5 patchset , you should be ok
Unfortunatly, it does show what I want. It does show version 18.104.22.168.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.)
Click Here to Expand Forum to Full Width