how to spot which oracle packages are installed / licensed [message #495825] |
Tue, 22 February 2011 09:55 |
|
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 #495933 is a reply to message #495830] |
Wed, 23 February 2011 05:56 |
|
fourty2
Messages: 6 Registered: January 2011
|
Junior Member |
|
|
Michel Cadot wrote on Tue, 22 February 2011 17:32Quote:- 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
/
|
|
|