Search notes:

Oracle

In 1977, Larry Ellison, Bob Minor and Ed Oates started consultancy Software Development Laboratories which was later renamed to Relational Software, Inc. (RSI).
1979, RSI released Oracle V2, the first commercially available SQL-based RDBMS.
In 1983, RSI was renamed to Oracle Systems Corporation and then Oracle Corporation.

Products

Some products can be queried from default_pwd$:
select
-- count(*),
   product
from
   sys.default_pwd$
group by
   product
order by
   product;
--
-- DB Service FireWall USER
-- EBS Endeca
-- Oracle Airlines Data Model
-- Oracle Application Core ATG Lite
-- Oracle Application Express
-- Oracle E-Business Suite
-- Oracle Fusion Transportation Intelligence
-- Oracle Health Insurance Back Office
-- Oracle Hospitality Simphony
-- Oracle On Demand
-- Oracle Pedigree And Serialization Manager
-- Oracle Scheduler
-- Oracle Transportation Management
-- Unified Manageability Framework

TODO

Java Virtual Machine

Manual installation

MOS Note 1461562.1
SQL Plus:
shutdown -- ???

connect / as sysdba
startup mount

alter system set "_system_trig_enabled" = false scope=memory;
alter database open;


--------- javavm/install/initjvm ----------

select obj#, name from obj$ where type#=28 or type#=29 or type#=30 or namespace=32;
-- No rows selected

select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type;
-- no rows selected

@?/javavm/install/initjvm.sql

select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type;
--
--   COUNT(*) OBJECT_TYPE
-- ---------- -----------------------
--       1209 JAVA DATA
--      32853 JAVA CLASS
--       1566 JAVA RESOURCE

--------- xdk/admin/initxml      ----------

@?/xdk/admin/initxml.sql

select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type;
--
--   COUNT(*) OBJECT_TYPE
-- ---------- -----------------------
--       1209 JAVA DATA
--      33901 JAVA CLASS
--       1639 JAVA RESOURCE

--------- xdk/admin/xmlja        ----------

@?/xdk/admin/xmlja.sql

---------

@?/rdbms/admin/catjava.sql

select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type;
--
-- COUNT(*) OBJECT_TYPE
-- ---------- -----------------------
--       1209 JAVA DATA
--      34271 JAVA CLASS
--          2 JAVA SOURCE
--       1642 JAVA RESOURCE

---------

@?/rdbms/admin/catexf.sql
-- SP2-0310: unable to open file "…/rdbms/admin/catexf.sql"

-------

shutdown immediate

startup

-------

-- Recompile objects

@?/rdbms/admin/utlrp.sql

-------

select comp_id from dba_registry;
--
-- Newly added: XML, JAVAVM, CATJAVA

See also

Scriptlets and patterns
SQL*Loader
PL/SQL
Information Lifecycle Management
Hybrid Columnar Compression
SAS and Oracle
The R package ROracle.
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

Index