Re: Anybody can please confirm these version numbers for me?

Niall Litchfield wrote:
> And yet I get
>
> SQL> select banner from v$version;
>
> BANNER
> -------------------------------------------------------------
> Oracle8i Release 8.1.7.4.1 - Production
> PL/SQL Release 8.1.7.4.0 - Production
> CORE 8.1.7.2.1 Production
> TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
>
> SQL>
>
>
> Perhaps there is no patch for CORE in 8.1.7.4 and there was in the 8.1.7.2
> patchset, so you get the versions for CORE that you had before you patched.
> Curious.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
> "Frank" <fbortel_at_home.nl> wrote in message news:3E019C79.2000709_at_home.nl...
>

>>Gerhard Häring wrote:
>>
>>>So I've patched a development Oracle 8i server to the 8.1.7.4 patch
>>

>>>Now when I do a
>>>
>>>#v+
>>>SQL> select * from v$version;
>>>
>>>BANNER
>>>----------------------------------------------------------------
>>>Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
>>>PL/SQL Release 8.1.7.4.0 - Production
>>>CORE    8.1.7.0.0       Production
>>>TNS for Linux: Version 8.1.7.4.0 - Production
>>>NLSRTL Version 3.4.1.0.0 - Production
>>>#v-
>>>
>>>the version number for the 'CORE' component look strange. It's still at
>>>8.1.7.0.0. Is this normal or did something go wrong during my patching?
>>>
>>>TIA,
>>
>>Same here:
>>Connected to:
>>Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
>>With the Partitioning option
>>JServer Release 8.1.7.4.0 - Production
>>
>>SQL> select * from v$version;
>>
>>BANNER
>>----------------------------------------------------------------
>>Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
>>PL/SQL Release 8.1.7.4.0 - Production
>>CORE    8.1.7.0.0       Production
>>TNS for Linux: Version 8.1.7.4.0 - Production
>>NLSRTL Version 3.4.1.0.0 - Production
>>

That is Windows - same as for Terry Dykstra. OP's versions are from Linux, as far as I can judge.
Seems an insert/update on the table is missing from the patch for Linux.
Wouldn't be too worried.

Frank Received on Thu Dec 19 2002 - 05:05:19 CST