Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: verifiing 8.1.7.4.1 upgrade to 8.1.7.4.x

Re: verifiing 8.1.7.4.1 upgrade to 8.1.7.4.x

From: Ted McCabe <theom_at_gte.net>
Date: Thu, 15 Apr 2004 23:52:56 GMT
Message-ID: <sfFfc.33614$hd3.2808@nwrddc03.gnilink.net>


Try (might need as SYS)

column comp_name format a35
column status format a20
column version format a11
select comp_name, status, substr(version,1,10) as version from dba_registry
order by comp_name;

HTH
tED
"Ivette Dumois" <ivettedumois_at_hotmail.com> wrote in message news:654ecf81.0404151414.267764e3_at_posting.google.com...
> I have upgraded our test 8.1.7.4.1 database to 8.1.7.4.13. I would
> like to verify this fact.
>
> In the readme it does state that all the products will not display the
> version number 8.1.7.4.13, because it's a cummulative patch.
>
> I would like to see at least one file with the version number greater
> than 8.1.7.4.1
>
> querying the database, v$instance still yields 8.1.7.4.1
>
> Any ideas?
>
> thanks
Received on Thu Apr 15 2004 - 18:52:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US