AMD
OLAP Catalog
11.2.0.4.0? ? ? ? ? VALID
COMP_ID
------------------------------
COMP_NAME
------------------------------------------------------------
VERSION? ? ? ? ? ? ? STATUS
-------------------- ----------------------
SDO
Spatial
11.2.0.4.0? ? ? ? ? VALID
ORDIM
Oracle Multimedia
COMP_ID
------------------------------
COMP_NAME
------------------------------------------------------------
VERSION? ? ? ? ? ? ? STATUS
-------------------- ----------------------
11.2.0.4.0? ? ? ? ? VALID
XDB
Oracle XML Database
11.2.0.4.0? ? ? ? ? VALID
CONTEXT
COMP_ID
------------------------------
COMP_NAME
------------------------------------------------------------
VERSION? ? ? ? ? ? ? STATUS
-------------------- ----------------------
Oracle Text
11.2.0.4.0? ? ? ? ? VALID
ODM
Oracle Data Mining
11.2.0.4.0? ? ? ? ? VALID
COMP_ID
------------------------------
COMP_NAME
------------------------------------------------------------
VERSION? ? ? ? ? ? ? STATUS
-------------------- ----------------------
EXF
Oracle Expression Filter
11.2.0.4.0? ? ? ? ? VALID
RUL
Oracle Rules Manager
11.2.0.4.0? ? ? ? ? VALID
COMP_ID
------------------------------
COMP_NAME
------------------------------------------------------------
VERSION? ? ? ? ? ? ? STATUS
-------------------- ----------------------
OWM
Oracle Workspace Manager
11.2.0.4.0? ? ? ? ? VALID
CATALOG
Oracle Database Catalog Views
COMP_ID
------------------------------
COMP_NAME
------------------------------------------------------------
VERSION? ? ? ? ? ? ? STATUS
-------------------- ----------------------
11.2.0.4.0? ? ? ? ? VALID
CATPROC
Oracle Database Packages and T
11.2.0.4.0? ? ? ? ? VALID
JAVAVM
COMP_ID
------------------------------
COMP_NAME
------------------------------------------------------------
VERSION? ? ? ? ? ? ? STATUS
-------------------- ----------------------
JServer JAVA Virtual Machine
11.2.0.4.0? ? ? ? ? VALID
XML
Oracle XDK
11.2.0.4.0? ? ? ? ? VALID
COMP_ID
------------------------------
COMP_NAME
------------------------------------------------------------
VERSION? ? ? ? ? ? ? STATUS
-------------------- ----------------------
CATJAVA
Oracle Database Java Packages
11.2.0.4.0? ? ? ? ? VALID
APS
OLAP Analytic Workspace
11.2.0.4.0? ? ? ? ? VALID
COMP_ID
------------------------------
COMP_NAME
------------------------------------------------------------
VERSION? ? ? ? ? ? ? STATUS
-------------------- ----------------------
XOQ
Oracle OLAP API
11.2.0.4.0? ? ? ? ? VALID
17 rows selected.
SQL> select * from v$timezone_file;
select * from registry$database;? (this shows the old value of the timezone)
SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;
FILENAME? ? ? ? ? ? ? ? VERSION
-------------------- ----------
timezlrg_14.dat? ? ? ? ? ? ? 14
1 row selected.
SQL> SQL>? 2? SQL> SQL>? 2? ? 3? ? 4
PROPERTY_NAME
------------------------------
VALUE
------------------------------------------------------------
DST_PRIMARY_TT_VERSION
14
DST_SECONDARY_TT_VERSION
0
DST_UPGRADE_STATE
NONE
3 rows selected.
SQL>
SQL> select * from registry$database;
PLATFORM_ID
-----------
PLATFORM_NAME
--------------------------------------------------------------------------------
EDITION? ? ? ? ? ? ? ? ? ? ? ? TZ_VERSION
------------------------------ ----------
? ? ? ? 13
Linux x86 64-bit
? ? ? ? ? ? ? ? ? ?