Oracle Database version, options installed and port listening
                                                 Last update (2008-05-16 21:15:46)
                                                                                                                   Date added (2008-04-17 17:58:13)

Summary
You can find the Database version and options installed with the following query:
SELECT banner
FROM   sys.v_$version
UNION
SELECT '   With the '||parameter||' option' with_option
FROM   sys.v_$option
WHERE  VALUE = 'TRUE' 
ORDER BY banner DESC;

BANNER
------------------------------------------------------------------------------
TNS for HPUX: Version 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
NLSRTL Version 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
   With the Visual Information Retrieval option
   With the Unused Block Compression option
   With the Trial Recovery option
   With the Transparent Data Encryption option
   With the Transparent Application Failover option
   With the Table compression option
   With the Streams Capture option
   With the Spatial option
   With the Sample Scan option
   With the Proxy authentication/authorization option
   With the Point-in-time tablespace recovery option
   With the Plan Stability option
   With the Partitioning option
   With the Parallel load option
   With the Parallel execution option
   With the Parallel backup and recovery option
   With the Oracle Data Guard option
   With the Online Redefinition option
   With the Online Index Build option
   With the Objects option
   With the OLAP option
   With the OLAP Window Functions option
   With the Materialized view warehouse refresh option
   With the Materialized view rewrite option
   With the Managed Standby option
   With the Join index option
   With the Java option
   With the Instead-of triggers option
   With the Incremental backup and recovery option
   With the Flashback Table option
   With the Flashback Database option
   With the Fine-grained access control option
   With the Fine-grained Auditing option
   With the File Mapping option
   With the Fast-Start Fault Recovery option
   With the Export transportable tablespaces option
   With the Enterprise User Security option
   With the Duplexed backups option
   With the Database resource manager option
   With the Database queuing option
   With the Data Mining option
   With the Connection pooling option
   With the Connection multiplexing option
   With the Coalesce Index option
   With the Change Data Capture option
   With the Block Media Recovery option
   With the Block Change Tracking option
   With the Bit-mapped indexes option
   With the Backup Encryption option
   With the Application Role option
   With the Advanced replication option

56 rows selected.

Elapsed: 00:00:00.01
To find wich options is not installed execute:
SELECT '   The '||parameter||' option is not installed' not_installed
FROM   sys.v_$option
WHERE  VALUE <> 'TRUE';

NOT_INSTALLED
------------------------------------------------------------
   The Real Application Clusters option is not installed
   The Oracle Label Security option is not installed
   The Data Mining Scoring Engine option is not installed

Elapsed: 00:00:00.00
To find the database port listening execute:
select dbms_utility.port_string from dual;
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search