Re: Can you tell an Oracle Patch ??

From: Aaron <asentell_at_my-deja.com>
Date: 2000/07/03
Message-ID: <8jr4n8$8oo$1@nnrp1.deja.com>#1/1

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 Mon Jul 03 2000 - 00:00:00 CDT