-
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.
-
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.
-
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
-
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.)
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
|