RE: How to find Oracle Packs already installed

  • From: FMHabash <fmhabash@xxxxxxxxx>
  • To: Niall Litchfield <niall.litchfield@xxxxxxxxx>, <sharmakdeep_oracle@xxxxxxxxx>, <Freek.DHooge@xxxxxxxxx>, <Santhosh.Channa@xxxxxxxxxxxx>, <Chris.Taylor@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 19 Feb 2009 13:44:52 -0500

I think this is how oracle tracks who uses what and if it is paid for. For 
example, awr and all associated packs are installed by default, but does not 
mean you can use it unless you pay.

Not to hijack the thread, but the intent was to tell that sometimes an 
option/feature is missing in v-option can show as used in above view and 
therefore, installed.

Thank you 

-----Original Message-----
From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
Sent: Thursday, February 19, 2009 12:44 PM
To: fmhabash@xxxxxxxxx; sharmakdeep_oracle@xxxxxxxxx; Freek.DHooge@xxxxxxxxx; 
Santhosh.Channa@xxxxxxxxxxxx; Chris.Taylor@xxxxxxxxxxxxxxx; 
oracle-l@xxxxxxxxxxxxx
Subject: Re: How to find Oracle Packs already installed

How would you not install for example the database diag pack? It is
installed and operational by default on all versions of the db, even
those you can't run it on.

On 2/19/09, FMHabash <fmhabash@xxxxxxxxx> wrote:
> Dba-feature-usage-statistics shows usage for all including rac and aso.
> Sometimes you can infer one from the other.
>
>
> -----Original Message-----
> From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
> Sent: Thursday, February 19, 2009 10:52 AM
> To: Freek.DHooge@xxxxxxxxx; Santhosh.Channa@xxxxxxxxxxxx
> <Santhosh.Channa@xxxxxxxxxxxx>; Chris.Taylor@xxxxxxxxxxxxxxx
> <Chris.Taylor@xxxxxxxxxxxxxxx>; oracle-l@xxxxxxxxxxxxx
> <oracle-l@xxxxxxxxxxxxx>
> Subject: Re: How to find Oracle Packs already installed
>
> yeah, you are right.  Same is true for RAC (even though there could be other
> ways to find that out, but it's not listed in v$option).
>
>
>
>
> ________________________________
> From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
> To: "sharmakdeep_oracle@xxxxxxxxx" <sharmakdeep_oracle@xxxxxxxxx>;
> "Santhosh.Channa@xxxxxxxxxxxx" <Santhosh.Channa@xxxxxxxxxxxx>;
> "Chris.Taylor@xxxxxxxxxxxxxxx" <Chris.Taylor@xxxxxxxxxxxxxxx>;
> "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> Sent: Thursday, February 19, 2009 9:47:08 AM
> Subject: RE: How to find Oracle Packs already installed
>
> Yes, but "advanced security" for instance is not listed in v$option, even if
> it is installed.
>
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer
>
>
> ________________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Deepak Sharma
> Sent: donderdag 19 februari 2009 16:37
> To: Santhosh.Channa@xxxxxxxxxxxx; Chris.Taylor@xxxxxxxxxxxxxxx;
> oracle-l@xxxxxxxxxxxxx
> Subject: Re: How to find Oracle Packs already installed
>
> Thanks.  Yes, it can see the listed ones in "v$option"
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

-- 
Sent from Google Mail for mobile | mobile.google.com

Niall Litchfield
Oracle DBA
http://www.orawin.info

--
//www.freelists.org/webpage/oracle-l


Other related posts: