Home » RDBMS Server » Server Administration » how to spot which oracle packages are installed / licensed (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production)
how to spot which oracle packages are installed / licensed [message #495825] Tue, 22 February 2011 09:55 Go to next message
fourty2
Messages: 6
Registered: January 2011
Junior Member
hello,

I need to figure out which Oracle Database packages are installed on a certain server.
First problem: no Enterprise Manager available. So I need some command line tools or SQL statements.

I've allready found some with them I was able to spot RAC, partitioning and so on. But I'm still missing a option/command to spot
- diagnistic pack
- tuning pack
- web logic
- web server

any ideas?

thx
Re: how to spot which oracle packages are installed / licensed [message #495827 is a reply to message #495825] Tue, 22 February 2011 10:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
1* select COMP_NAME from DBA_REGISTRY
SQL> /

COMP_NAME
--------------------------------------------------------------------------------
OWB
Oracle Application Express
Oracle Enterprise Manager
OLAP Catalog
Spatial
Oracle Multimedia
Oracle XML Database
Oracle Text
Oracle Expression Filter
Oracle Rules Manager
Oracle Workspace Manager

COMP_NAME
--------------------------------------------------------------------------------
Oracle Database Catalog Views
Oracle Database Packages and Types
JServer JAVA Virtual Machine
Oracle XDK
Oracle Database Java Packages
OLAP Analytic Workspace
Oracle OLAP API

18 rows selected.

SQL>
Re: how to spot which oracle packages are installed / licensed [message #495830 is a reply to message #495825] Tue, 22 February 2011 10:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
- diagnistic pack
- tuning pack

Quote:
First problem: no Enterprise Manager available.

=> These pack are not used (or should not be used).

Quote:
- web logic
- web server

Not Oracle RDBMS point.

Quote:
I've allready found some with them I was able to spot RAC, partitioning and so on

And what about sharing with how you get this?

Have a look at V$OPTION and DBA_FEATURE_USAGE_STATISTICS.

Regards
Michel
Re: how to spot which oracle packages are installed / licensed [message #495933 is a reply to message #495830] Wed, 23 February 2011 05:56 Go to previous message
fourty2
Messages: 6
Registered: January 2011
Junior Member
Michel Cadot wrote on Tue, 22 February 2011 17:32
Quote:
- web logic
- web server

Not Oracle RDBMS point.

sure. and I see the point that it won't work with some SQL statements.
but I guess there must be a command or package which I would be able to see/start if these packages are installed.
sorry, maybe it's a stupid question. but I have no idea about weblogic/webserver associated with oracle.

Quote:

Have a look at V$OPTION and DBA_FEATURE_USAGE_STATISTICS.

thx!

Quote:
I've allready found some with them I was able to spot RAC, partitioning and so on

And what about sharing with how you get this?
[/quote]
I've used the following statements to spot some packages/informations:
SQL> select * from v$license;

SQL> select banner from v$version where BANNER like '%Edition%';

SQL> select decode(count(*), 0, 'No', 'Yes') Partitioning
from ( select 1 
       from dba_part_tables
       where owner not in ('SYSMAN', 'SH', 'SYS', 'SYSTEM')
         and rownum = 1 );

SQL> select decode(count(*), 0, 'No', 'Yes') Spatial
from ( select 1
       from all_sdo_geom_metadata 
       where rownum = 1 );

SQL> select decode(count(*), 0, 'No', 'Yes') RAC
from ( select 1 
       from v$active_instances 
       where rownum = 1 );

# nearly the same as you proposed
SQL> Col name  format a50 heading "Option"
Col value format a5  heading "?"      justify center wrap
Break on value dup skip 1
Spool option
Select parameter name, value
from v$option 
order by 2 desc, 1
/

SQL> Set feedback off
Set linesize 122
Col name             format a45     heading "Feature"
Col version          format a10     heading "Version"
Col detected_usages  format 999,990 heading "Detected|usages"
Col currently_used   format a06     heading "Curr.|used?"
Col first_usage_date format a10     heading "First use"
Col last_usage_date  format a10     heading "Last use"
Col nop noprint
Break on nop skip 1 on name
Select decode(detected_usages,0,2,1) nop,
       name, version, detected_usages, currently_used,
       to_char(first_usage_date,'DD/MM/YYYY') first_usage_date, 
       to_char(last_usage_date,'DD/MM/YYYY') last_usage_date
from dba_feature_usage_statistics
order by nop, 1, 2
/
Previous Topic: Tablespace reaches threshold
Next Topic: CSALTER ERROR after csscan ran clean.
Goto Forum:
  


Current Time: Wed May 08 17:26:59 CDT 2024