Re: Can you tell an Oracle Patch ??

You need to have a Metalink account for that, you can sign up for Metalink with a valid Oracle Metals License/Support Contract.

Hth,

Sybrand Bakker, Oracle DBA

"Aaron" <asentell_at_my-deja.com> wrote in message news:8jr4n8$8oo$1_at_nnrp1.deja.com...
> Here's what I get when I run the query select * from v$version:
>
> BANNER
> ----------------------------------------------------------------
> Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
> PL/SQL Release 8.1.5.0.0 - Production
> CORE Version 8.1.5.0.0 - Production
> TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
> NLSRTL Version 3.4.0.0.0 - Production
>
> That would mean I am at patch level 0, correct? Where do I learn about
> patches as they are made available and what they fix? Where can I
> download them? As you might have guessed, I'm new to Oracle.
>
> Thanks,
> Aaron
>
> In article <8jd9bo$h40$1_at_nnrp1.deja.com>,
> scjonson_at_my-deja.com wrote:
> > Try:
> > SQL> select * from v$version;
> >
> > BANNER
> > ----------------------------------------------------------------
> > Oracle8i Enterprise Edition Release 8.1.5.0.1 - Production
> > PL/SQL Release 8.1.5.0.0 - Production
> > CORE Version 8.1.3.0.0 - Production
> > TNS for Linux: Version 8.1.5.0.0 - Production
> > NLSRTL Version 3.4.0.0.0 - Production
> >
> > The 4th decimal is the patch set.
> >
> > hth
> > Steve...
> >
> > In article <8jctug$7e8$1_at_nnrp1.deja.com>,
> > sjoshi_at_ingr.com wrote:
> > > Hello All
> > > I was wondering if Oracle records internally any patches that are
> > > applied. I need a way to figure out if a user has installed the
 latest
> > > patch. Is this possible ?
> > >
> > > thanks
> > > Sunit
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jul 04 2000 - 00:00:00 CDT