# WARNING: Failure to carefully read and understand these requirements may
# result in your applying a patch that can cause your Oracle Server to
# malfunction, including interruption of service and/or loss of data.
#
# If you do not meet all of the following requirements, please log an
# iTAR, so that an Oracle support analyst may review your situation.  The
# Oracle analyst will help you determine if this patch is suitable for you
# to apply to your system.
#
# Requirements:
#
#    - You must be using Oracle Application Express Product Version #  : 5.1.4.00.08
#
# If you do NOT meet these requirements, or are not certain that you meet
# these requirements, please log an iTAR requesting assistance with this
# patch and Support will make a determination about whether you should
# apply this patch.
#
#---------------------------------------------------------------
# Patch Set Exception : AnyChart Flash Content
#----------------------------------------------------------------
#
# DATE : December 20, 2017
# ------------------------
# Platform Patch for : Generic - Platform independent
# This fix must be applied to Oracle Application Express Product Version #  : 5.1.4.00.08
# Product Patched    : Oracle Application Express
#
# Bugs Fixed by this patch:
# -------------------------
# This patch installs AnyChart Flash Content
#
# Contents of this patch:
# -----------------------
# README.txt
# apxpreins.sql
# epg_install_images.sql
# epg_install_images_cdb.sql
# epg_install_images_nocdb.sql
# images/flashchart/anychart_6/swf/OracleAnyChart.swf
# images/flashchart/anychart_6/swf/Preloader.swf
# images/flashchart/anychart_6/swf/font/Arial.swf
# images/flashchart/anychart_6/swf/font/Arial_Bold.swf
# images/flashchart/anychart_6/swf/font/Arial_Bold_Italic.swf
# images/flashchart/anychart_6/swf/font/Arial_Italic.swf
# images/flashchart/anychart_6/swf/font/Courier-New.swf
# images/flashchart/anychart_6/swf/font/Courier-New_Bold.swf
# images/flashchart/anychart_6/swf/font/Courier-New_Bold_Italic.swf
# images/flashchart/anychart_6/swf/font/Courier-New_Italic.swf
# images/flashchart/anychart_6/swf/font/Lucida-Sans.swf
# images/flashchart/anychart_6/swf/font/Lucida-Sans_Italic.swf
# images/flashchart/anychart_6/swf/font/Trebuchet-MS.swf
# images/flashchart/anychart_6/swf/font/Trebuchet-MS_Bold.swf
# images/flashchart/anychart_6/swf/font/Trebuchet-MS_Bold_Italic.swf
# images/flashchart/anychart_6/swf/font/Trebuchet-MS_Italic.swf
# images/flashchart/anychart_6/swf/font/Verdana.swf
# images/flashchart/anychart_6/swf/font/Verdana_Bold.swf
# images/flashchart/anychart_6/swf/font/Verdana_Bold_Italic.swf
# images/flashchart/anychart_6/swf/font/Verdana_Italic.swf
# images/flashchart/anygantt_4/swf/AnyGantt.swf
# images/flashchart/anygantt_4/swf/Preloader.swf
#
# Patch Installation Instructions:
# --------------------------------
# To apply the patch
#
#  1. Download the AnyChart_Flash_Content.zip patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.
#
#  2. Unzip and extract the installation files by double-clicking AnyChart_Flash_Content.zip in a Microsoft Windows based system, or entering the following command to unzip on a UNIX or Linux based system:
#
#   $ unzip AnyChart_Flash_Content.zip
#
#  3. Preventing Access to Oracle REST Data Services
#
#     It is important that no developers or end users access Oracle Application Express while you are applying the patch. This section describes how to prevent access to Oracle Application Express if your configuration
#     includes Oracle REST Data Services, embedded PL/SQL gateway (EPG), or Oracle HTTP Server with mod_plsql.
#
#     This section contains these topics:
#
#     - Stopping Oracle REST Data Services
#
#     - About Disabling the embedded PL/SQL gateway
#
#     - Stopping Oracle HTTP Server
#
#     I. Stopping Oracle REST Data Services
#
#        To learn more about stopping the Oracle REST Data Services server, see Oracle REST Data Services Installation and Configuration Guide:
#
#        http://docs.oracle.com/cd/E56351_01/doc.30/e56293/toc.htm
#
#    II. About Disabling the Embedded PL/SQL Gateway
#
#        If your configuration includes the embedded PL/SQL gateway, you need to disable HTTP on the Oracle XML DB Protocol Server. The embedded PL/SQL gateway runs on the
#        Oracle XML DB Protocol Server in the Oracle database. To disable it, you change the port number to 0. Before doing so, first verify the current port number.
#
#        Verifying the Port Assigned to Oracle XML DB Protocol Server
#
#            To verify the port number assigned to HTTP on the Oracle XML DB Protocol Server:
#
#          Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
#
#         - On Windows:
#
#                 SYSTEM_DRIVE:\> sqlplus /nolog
#                 SQL> CONNECT SYS as SYSDBA
#                 Enter password: SYS_password
#
#         - On UNIX and Linux:
#
#                 $ sqlplus /nolog
#                 SQL> CONNECT SYS as SYSDBA
#                 Enter password: SYS_password
#
#            Enter the following statement to verify the port number:
#
#                 SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
#
#            If the port number returns 0, the Oracle XML DB Protocol Server is disabled.
#
#        Disabling HTTP on the Oracle XML DB Protocol Server
#
#            To disable HTTP on the Oracle XML DB Protocol Server:
#
#          Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
#
#         - On Windows:
#
#                 SYSTEM_DRIVE:\> sqlplus /nolog
#                 SQL> CONNECT SYS as SYSDBA
#                 Enter password: SYS_password
#
#         - On UNIX and Linux:
#
#                 $ sqlplus /nolog
#                 SQL> CONNECT SYS as SYSDBA
#                 Enter password: SYS_password
#
#
#          Run the following statements:
#
#                EXEC DBMS_XDB.SETHTTPPORT(0);
#                COMMIT;
#
#   III. Stopping Oracle HTTP Server
#
#        If your configuration includes Oracle HTTP Server with mod_plsql, you need to stop the Oracle HTTP Server.
#
#            To stop the Oracle HTTP Server shipped with Oracle Database 10g release 1 (10.1) or later, enter commands using the following syntax:
#
#                ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl stopproc ias-component=ohs1
#
#            In the previous example, ORACLE_BASE is the path to the Oracle base directory.  The component name can be determined by running ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl status
#
#            Tip: Note that if the Oracle HTTP Server is listening on a port less than 1024, then these commands must be executed as a privileged user (such as root).
#
#  4. Set your current directory to the "patch" directory where you unzipped the AnyChart_Flash_Content.zip file.
#
#
#  5. Install the Patch Set Exception's changes in the images directory
#
#    I. If you are using Oracle HTTP Server, then recursively copy the images directory of the patch to the /images folder of the Oracle Application Express
#       images directory.  This is the filesystem directory mapped to the Web server virtual directory /i/.
#
#       To locate the images directory on the file system, review the following files for the text alias /i/:
#
#       - Oracle Application Server 10g - see the marvel.conf or dads.conf files.
#       - Oracle HTTP Server distributed with Oracle Database 11g - see the marvel.conf or dads.conf files.
#
#       Assuming the AnyChart_Flash_Content.zip file was unzipped to c:\temp on Windows and /tmp on Linux
#
#       On a Windows system, run a command from a command prompt similar to the following example:
#
#           xcopy /E /I c:\temp\images ORACLE_HTTPSERVER_HOME\Apache\Apache\images
#
#       On UNIX or Linux based systems, run a command similar to the following example:
#
#           cp -rf /tmp/images ORACLE_HTTPSERVER_HOME/Apache/Apache
#
#       In the preceding syntax examples, ORACLE_HTTPSERVER_HOME is the existing Oracle Application Server or Oracle HTTP Server Oracle home. The location of the
#       Oracle Application Express images directory may be different in your configuration.
#
#   II. If you are using the embedded PL/SQL gateway instead of Oracle HTTP Server, connect to the database where Oracle Application Express
#       is installed as the SYS user and run epg_install_images.sql, specifying the directory where AnyChart_Flash_Content.zip is unzipped,
#       as in the following example:
#
#           sqlplus "sys/syspass as sysdba" @epg_install_images.sql /tmp
#
#       The preceding example assumes that AnyChart_Flash_Content.zip was unzipped to the /tmp directory
#
#       Note: epg_install_images.sql will determine your installation type and run the appropriate file or a CDB installation if needed.
#
#  III. If you are using Oracle REST Data Services copy the images directory of the patch to the /images folder of the Oracle Application Express installation directory
#       images sub directory. Use a command similar to the one given in step I. except the destination directory will be the Oracle Application Express installation
#       images directory.
#
#
#  6. Starting Oracle Application Express
#
#    I. Starting Oracle REST Data Services
#
#       To learn more about starting the Oracle REST Data Services server, see Oracle REST Data Services Installation and Configuration Guide:
#
#           http://docs.oracle.com/cd/E56351_01/doc.30/e56293/toc.htm
#
#   II. Enabling the Embedded PL/SQL Gateway
#
#       Once disabled, you enable the embedded PL/SQL gateway by assigning a port number to the Oracle XML DB Protocol Server.
#
#       To assign a port number to Oracle XML DB Protocol Server:
#
#          Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
#
#          - On Windows:
#
#                SYSTEM_DRIVE:\> sqlplus /nolog
#                SQL> CONNECT SYS as SYSDBA
#                Enter password: SYS_password
#
#          - On UNIX and Linux:
#
#              $ sqlplus /nolog
#              SQL> CONNECT SYS as SYSDBA
#              Enter password: SYS_password
#
#          Run the following statements:
#
#              EXEC DBMS_XDB.SETHTTPPORT(port);
#              COMMIT;
#
#          For example:
#
#              EXEC DBMS_XDB.SETHTTPPORT(8080);
#              COMMIT;
#
#          Note:
#
#              Port numbers less than 1024 are reserved for use by privileged processes on many operating systems. To enable the Oracle XML DB Protocol Server on a port less than 1024, such as 80, review the following documentation:
#
#                  "Accessing the Repository using Protocols" in Oracle XML DB Developer's Guide:
#
#                      http://docs.oracle.com/cd/E16655_01/appdev.121/e17603/xdb22pro.htm
#
#                  "Protocol Address Configuration" and "Port Number Limitations" in Oracle Database Net Services Reference:
#
#                      http://docs.oracle.com/cd/E16655_01/network.121/e17611/protocoladd.htm
#
#
#  III. Starting Oracle HTTP Server
#
#       To start Oracle HTTP Server shipped with Oracle Database 10g Release 1 (10.1) or later, enter commands using the following syntax:
#
#           ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl startproc ias-component=ohs1
#
#       In the previous example, ORACLE_BASE is the path to the Oracle base directory.  The component name can be determined by running ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl status
#
#       Tip:  If the Oracle HTTP Server is listening on a port less than 1024, then these commands must be executed as a privileged user (such as root).
#
# EOF README.txt
