Keystore import

adjkey -import -trustcacerts -keystore adkeystore.dat -alias xxxxx -file cert.p7b -storepass xxxxx

help:https://www.sslshopper.com/ssl-converter.html

How unzip multiple zip file in linux

for z in *.zip do unzip $z; done

R12.2 Information Center

E-Business Suite Diagnostics References for R12 (Doc ID 421245.1)

Information Center: Using EBS Technology Stack OID and SSO (Doc ID 1461466.2) Oracle E-Business Suite Release 12.2 Information Center (Doc ID 1581299.1) Information Center: Using EBS Technology Stack - Framework (Doc ID 1478640.2) Information Center: Overview E-Business Suite Technology - Forms (Doc ID 1411953.2)

Information Center: E-Business Suite Performance (Doc ID 1671692.2)

Information Center: Using EBS Technology Stack Java (Doc ID 1462269.2)

Information Center: Using EBS Technology Stack - Discoverer (Doc ID 1476179.2)

Information Center: Troubleshooting the E-Business Suite Technology Stack Database (Doc ID 1676460.2)

Information Center: E-Business Suite Utilities (Cloning, Autoconfig, Patching) (Doc ID 1375925.2) Information Center: Overview EBS Technology Stack - Advanced Configurations (SSL,DMZ,Loadbalancer) (Doc ID 1478637.2) Information Center: Troubleshooting E-Business Suite Utilities (Doc ID 1377828.2)

ORA-01103: database name 'DEVSID' in control file is not 'PRODSID'

startup nomount
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             436208520 bytes
Database Buffers          616562688 bytes
Redo Buffers               13905920 bytes
SQL> ALTER SYSTEM SET DB_NAME=PRO0TS SCOPE=spfile;
System altered.
shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL>; exit 
SQL>; startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             444597128 bytes
Database Buffers          608174080 bytes
Redo Buffers               13905920 bytes
Database mounted.
Database opened.

Java bug 6521844

How to Diagnose a Linux Entropy Issue on WebLogic Server Instances (Doc ID 1574979.1) This Document helped my environment.

Oracle Endeca R12.2

Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V5 (Doc ID 1614014.1) 

Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12cR1 database . (Doc ID 1585343.1)

upgrade DST 18 to 24

Download p20875898_112040_Linux-x86-64.zip

Download DBMS_DST_scriptsV1.9.zip
$ORACLE_HOME/oracore/zoneinfo/timezlrg_18.dat

SQL> SELECT version FROM v$timezone_file;

   VERSION
----------
        18

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
  2  FROM DATABASE_PROPERTIES
  3  WHERE PROPERTY_NAME LIKE 'DST_%'
  4  ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ ------------------------------
DST_PRIMARY_TT_VERSION         18
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE

SQL> exit

$/scratch/DBMS_DST_scriptsV1.9
  upg_tzv_check.sql
  upg_tzv_apply.sql
  countstarTSTZ.sql
  countstatsTSTZ.sql

$sqlplus '/as sysdba'

SQL> sta upg_tzv_check.sql
INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 11.2.0.4 .
INFO: Database RDBMS DST version is DSTv18 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv24 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run upg_tzv_apply.sql to do the actual RDBMS DST update.
INFO: Note that the upg_tzv_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.
SQL> sta upg_tzv_apply.sql
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: The database RDBMS DST version will be updated to DSTv24 .
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             436208520 bytes
Database Buffers          616562688 bytes
Redo Buffers               13905920 bytes
Database mounted.
Database opened.
INFO: Starting the RDBMS DST upgrade.
INFO: Upgrading all SYS owned TSTZ data.
INFO: It might take time before any further output is seen ...
An upgrade window has been successfully started.
INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             436208520 bytes
Database Buffers          616562688 bytes
Redo Buffers               13905920 bytes
Database mounted.
Database opened.
INFO: Upgrading all non-SYS TSTZ data.
INFO: It might take time before any further output is seen ...
INFO: Do NOT start any application yet that uses TSTZ data!
INFO: Next is a list of all upgraded tables:
Table list: "APPLSYS"."AQ$_FND_CP_GSM_IPC_AQTBL_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_FND_CP_GSM_IPC_AQTBL_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_FND_CP_TM_AQTBL_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_FND_CP_TM_RET_AQTBL_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_FND_CP_TM_AQTBL_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_FND_CP_TM_RET_AQTBL_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_FND_CP_GSM_OPP_AQTBL_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_FND_CP_GSM_OPP_AQTBL_L"
Number of failures: 0
Table list: "ASO"."AQ$_ASO_ORDER_FEEDBACK_T_S"
Number of failures: 0
Table list: "OKC"."AQ$_OKC_AQ_EV_TAB_S"
Number of failures: 0
Table list: "AR"."AQ$_AR_REV_REC_QT_S"
Number of failures: 0
Table list: "XNP"."AQ$_XNP_OUT_MSG_QTAB_S"
Number of failures: 0
Table list: "CS"."AQ$_CS_SERVICE_REQUEST_IQT_S"
Number of failures: 0
Table list: "CS"."AQ$_CS_SERVICE_REQUEST_OQT_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_DEFERRED_TABLE_M_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_DEFERRED_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_REPLAY_IN_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_ERROR_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_OUT_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_REPLAY_OUT_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_IN_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JMS_IN_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JMS_OUT_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_NOTIFICATION_IN_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JAVA_DEFERRED_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_WS_JMS_IN_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_WS_JMS_OUT_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JAVA_ERROR_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JMS_JMS_OUT_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_WS_SAMPLE_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_CONTROL_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_CONTROL_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_NOTIFICATION_OUT_S"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_NOTIFICATION_OUT_L"
Number of failures: 0
Table list: "ASO"."AQ$_ASO_ORDER_FEEDBACK_T_L"
Number of failures: 0
Table list: "XNP"."AQ$_XNP_OUT_MSG_QTAB_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_OUT_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_ERROR_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_REPLAY_IN_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_DEFERRED_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_DEFERRED_TABLE_M_L"
Number of failures: 0
Table list: "CS"."AQ$_CS_SERVICE_REQUEST_OQT_L"
Number of failures: 0
Table list: "CS"."AQ$_CS_SERVICE_REQUEST_IQT_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_NOTIFICATION_IN_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JMS_OUT_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JMS_IN_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_IN_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_REPLAY_OUT_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_WS_SAMPLE_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JMS_JMS_OUT_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JAVA_ERROR_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_WS_JMS_OUT_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_JAVA_DEFERRED_L"
Number of failures: 0
Table list: "APPLSYS"."AQ$_WF_WS_JMS_IN_L"
Number of failures: 0
Table list: "AR"."AQ$_AR_REV_REC_QT_L"
Number of failures: 0
Table list: "OKC"."AQ$_OKC_AQ_EV_TAB_L"
Number of failures: 0
INFO: Total failures during update of TSTZ data: 0 .
An upgrade window has been successfully ended.
INFO: Your new Server RDBMS DST version is DSTv24 .
INFO: The RDBMS DST update is successfully finished.
INFO: Make sure to exit this sqlplus session.
INFO: Do not use it for timezone related selects.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
property@didbs2b$pwd
/scratch/applications/12c/DBMS_DST_scriptsV1.9
property@didbs2b$sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 6 13:09:42 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
  2  FROM DATABASE_PROPERTIES
  3  WHERE PROPERTY_NAME LIKE 'DST_%'
  4  ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ ------------------------------
DST_PRIMARY_TT_VERSION         24
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE

Oracle Time Zone upgrade from 14 to 18

oracle support doc 1358166.1 for detailed information on timezone upgrade. It’s recommended to go through this document to understand the affects of below commands and any deviation from below steps if slight change in versions involved in this upgrade.

Download oracle Time zone patch  p13417321_112040_Linux-x86-64

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value

  2  FROM DATABASE_PROPERTIES

  3  WHERE PROPERTY_NAME LIKE 'DST_%'

  4  ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE

------------------------------ ------------------------------

DST_PRIMARY_TT_VERSION         14

DST_SECONDARY_TT_VERSION       0

DST_UPGRADE_STATE              NONE

SQL> purge dba_recyclebin;

DBA Recyclebin purged.

SQL> alter session set "_with_subquery"=materialize;

Session altered.

SQL> alter session set "_simple_view_merging"=TRUE;

Session altered.

SQL>  EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO('upg_tzv');

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_DST.BEGIN_PREPARE(18);

PL/SQL procedure successfully completed.

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value 

  2  FROM DATABASE_PROPERTIES

  3  WHERE PROPERTY_NAME LIKE 'DST_%'

  4  ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE

------------------------------ ------------------------------

DST_PRIMARY_TT_VERSION         14

DST_SECONDARY_TT_VERSION       18

DST_UPGRADE_STATE              PREPARE

SQL> TRUNCATE TABLE SYS.DST$TRIGGER_TABLE;

Table truncated.

SQL> TRUNCATE TABLE sys.dst$affected_tables;

Table truncated.

SQL> TRUNCATE TABLE sys.dst$error_table;

Table truncated.

SQL> set serveroutput on

SQL>  BEGIN

  2  DBMS_DST.FIND_AFFECTED_TABLES

  3  (affected_tables => 'sys.dst$affected_tables',

  4  log_errors => TRUE,

  5  log_errors_table => 'sys.dst$error_table');

  6  END;

  7  /

PL/SQL procedure successfully completed.

SQL> SELECT * FROM sys.dst$affected_tables;

no rows selected

SQL>  SELECT * FROM sys.dst$error_table;

no rows selected

SQL> SELECT * FROM sys.dst$error_table where ERROR_NUMBER= '1883';

no rows selected

SQL> SELECT * FROM sys.dst$error_table where ERROR_NUMBER= '1878';

no rows selected

SQL> SELECT * FROM sys.dst$error_table where ERROR_NUMBER not in ('1878','1883');

no rows selected

SQL> EXEC DBMS_DST.END_PREPARE;

A prepare window has been successfully ended.

PL/SQL procedure successfully completed.

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value

  2   FROM DATABASE_PROPERTIES

  3   WHERE PROPERTY_NAME LIKE 'DST_%'

  4   ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE

------------------------------ ------------------------------

DST_PRIMARY_TT_VERSION         14

DST_SECONDARY_TT_VERSION       0

DST_UPGRADE_STATE              NONE

SQL> select name from v$database;

NAME

---------

SID

SQL>  shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2260088 bytes

Variable Size             444597128 bytes

Database Buffers          608174080 bytes

Redo Buffers               13905920 bytes

Database mounted.

Database opened.

SQL> set serveroutput on

SQL>  set timing on

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value

  2  FROM DATABASE_PROPERTIES

  3  WHERE PROPERTY_NAME LIKE 'DST_%'

  4  ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE

------------------------------ ------------------------------

DST_PRIMARY_TT_VERSION         14

DST_SECONDARY_TT_VERSION       0

DST_UPGRADE_STATE              NONE

Elapsed: 00:00:00.02

SQL> purge dba_recyclebin;

DBA Recyclebin purged.

Elapsed: 00:00:00.01

SQL>  TRUNCATE TABLE SYS.DST$TRIGGER_TABLE;

Table truncated.

Elapsed: 00:00:00.02

SQL> TRUNCATE TABLE sys.dst$affected_tables;

Table truncated.

Elapsed: 00:00:00.01

SQL> TRUNCATE TABLE sys.dst$error_table;

Table truncated.

Elapsed: 00:00:00.02

SQL>  alter session set "_with_subquery"=materialize;

Session altered.

Elapsed: 00:00:00.00

SQL> alter session set "_simple_view_merging"=TRUE;

Session altered.

Elapsed: 00:00:00.00

SQL>  EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO('upg_tzv');

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01

SQL>  EXEC DBMS_DST.BEGIN_UPGRADE(18);

An upgrade window has been successfully started.

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.61

SQL> SELECT * FROM sys.dst$error_table;

no rows selected

Elapsed: 00:00:00.00

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value

  2  FROM DATABASE_PROPERTIES

  3  WHERE PROPERTY_NAME LIKE 'DST_%'

  4  ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE

------------------------------ ------------------------------

DST_PRIMARY_TT_VERSION         18

DST_SECONDARY_TT_VERSION       14

DST_UPGRADE_STATE              UPGRADE

Elapsed: 00:00:00.01

SQL> select OWNER, TABLE_NAME, UPGRADE_IN_PROGRESS from ALL_TSTZ_TABLES where UPGRADE_IN_PROGRESS='YES';

OWNER                          TABLE_NAME                     UPG

------------------------------ ------------------------------ ---

APPLSYS                        AQ$_FND_CP_GSM_IPC_AQTBL_S     YES

APPLSYS                        AQ$_FND_CP_GSM_IPC_AQTBL_L     YES

APPLSYS                        AQ$_FND_CP_TM_AQTBL_S          YES

APPLSYS                        AQ$_FND_CP_TM_RET_AQTBL_S      YES

APPLSYS                        AQ$_FND_CP_TM_AQTBL_L          YES

APPLSYS                        AQ$_FND_CP_TM_RET_AQTBL_L      YES

APPLSYS                        AQ$_FND_CP_GSM_OPP_AQTBL_S     YES

APPLSYS                        AQ$_FND_CP_GSM_OPP_AQTBL_L     YES

ASO                            AQ$_ASO_ORDER_FEEDBACK_T_S     YES

OKC                            AQ$_OKC_AQ_EV_TAB_S            YES

AR                             AQ$_AR_REV_REC_QT_S            YES

OWNER                          TABLE_NAME                     UPG

------------------------------ ------------------------------ ---

XNP                            AQ$_XNP_OUT_MSG_QTAB_S         YES

CS                             AQ$_CS_SERVICE_REQUEST_IQT_S   YES

CS                             AQ$_CS_SERVICE_REQUEST_OQT_S   YES

APPLSYS                        AQ$_WF_DEFERRED_TABLE_M_S      YES

APPLSYS                        AQ$_WF_DEFERRED_S              YES

APPLSYS                        AQ$_WF_REPLAY_IN_S             YES

APPLSYS                        AQ$_WF_ERROR_S                 YES

APPLSYS                        AQ$_WF_OUT_S                   YES

APPLSYS                        AQ$_WF_REPLAY_OUT_S            YES

APPLSYS                        AQ$_WF_IN_S                    YES

APPLSYS                        AQ$_WF_JMS_IN_S                YES

OWNER                          TABLE_NAME                     UPG

------------------------------ ------------------------------ ---

APPLSYS                        AQ$_WF_JMS_OUT_S               YES

APPLSYS                        AQ$_WF_NOTIFICATION_IN_S       YES

APPLSYS                        AQ$_WF_JAVA_DEFERRED_S         YES

APPLSYS                        AQ$_WF_WS_JMS_IN_S             YES

APPLSYS                        AQ$_WF_WS_JMS_OUT_S            YES

APPLSYS                        AQ$_WF_JAVA_ERROR_S            YES

APPLSYS                        AQ$_WF_JMS_JMS_OUT_S           YES

APPLSYS                        AQ$_WF_WS_SAMPLE_S             YES

APPLSYS                        AQ$_WF_CONTROL_S               YES

APPLSYS                        AQ$_WF_CONTROL_L               YES

APPLSYS                        AQ$_WF_NOTIFICATION_OUT_S      YES

OWNER                          TABLE_NAME                     UPG

------------------------------ ------------------------------ ---

APPLSYS                        AQ$_WF_NOTIFICATION_OUT_L      YES

ASO                            AQ$_ASO_ORDER_FEEDBACK_T_L     YES

XNP                            AQ$_XNP_OUT_MSG_QTAB_L         YES

APPLSYS                        AQ$_WF_OUT_L                   YES

APPLSYS                        AQ$_WF_ERROR_L                 YES

APPLSYS                        AQ$_WF_REPLAY_IN_L             YES

APPLSYS                        AQ$_WF_DEFERRED_L              YES

APPLSYS                        AQ$_WF_DEFERRED_TABLE_M_L      YES

CS                             AQ$_CS_SERVICE_REQUEST_OQT_L   YES

CS                             AQ$_CS_SERVICE_REQUEST_IQT_L   YES

APPLSYS                        AQ$_WF_NOTIFICATION_IN_L       YES

OWNER                          TABLE_NAME                     UPG

------------------------------ ------------------------------ ---

APPLSYS                        AQ$_WF_JMS_OUT_L               YES

APPLSYS                        AQ$_WF_JMS_IN_L                YES

APPLSYS                        AQ$_WF_IN_L                    YES

APPLSYS                        AQ$_WF_REPLAY_OUT_L            YES

APPLSYS                        AQ$_WF_WS_SAMPLE_L             YES

APPLSYS                        AQ$_WF_JMS_JMS_OUT_L           YES

APPLSYS                        AQ$_WF_JAVA_ERROR_L            YES

APPLSYS                        AQ$_WF_WS_JMS_OUT_L            YES

APPLSYS                        AQ$_WF_JAVA_DEFERRED_L         YES

APPLSYS                        AQ$_WF_WS_JMS_IN_L             YES

AR                             AQ$_AR_REV_REC_QT_L            YES

OWNER                          TABLE_NAME                     UPG

------------------------------ ------------------------------ ---

OKC                            AQ$_OKC_AQ_EV_TAB_L            YES

56 rows selected.

Elapsed: 00:00:00.46

SQL>; shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>;  startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2260088 bytes

Variable Size             444597128 bytes

Database Buffers          608174080 bytes

Redo Buffers               13905920 bytes

Database mounted.

Database opened.

SQL> alter session set "_with_subquery"=materialize;

Session altered.

Elapsed: 00:00:00.02

SQL> alter session set "_simple_view_merging"=TRUE;

Session altered.

Elapsed: 00:00:00.00

SQL>; EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO('upg_tzv');

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01

SQL>;  VAR numfail number

SQL>;  BEGIN

  2      DBMS_DST.UPGRADE_DATABASE(:numfail,

  3      parallel => TRUE,

  4      log_errors => TRUE,

  5      log_errors_table => 'SYS.DST$ERROR_TABLE',

  6      log_triggers_table => 'SYS.DST$TRIGGER_TABLE',

  7      error_on_overlap_time => FALSE,

  8      error_on_nonexisting_time => FALSE);

  9      DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);

 10     END;

 11  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:18.91

SQL> SELECT * FROM sys.dst$error_table;

no rows selected

Elapsed: 00:00:00.00

SQL>; VAR fail number

SQL>; BEGIN

  2  DBMS_DST.END_UPGRADE(:fail);

  3  DBMS_OUTPUT.PUT_LINE('Failures:'|| :fail);

  4  END;

  5  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.45

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value

  2  FROM DATABASE_PROPERTIES

  3  WHERE PROPERTY_NAME LIKE 'DST_%'

  4  ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE

------------------------------ ------------------------------

DST_PRIMARY_TT_VERSION         18

DST_SECONDARY_TT_VERSION       0

DST_UPGRADE_STATE              NONE

Elapsed: 00:00:00.00

SQL> SELECT * FROM v$timezone_file;

FILENAME                VERSION

-------------------- ----------

timezlrg_18.dat              18

Elapsed: 00:00:00.00

SQL>