4 Perform Online Application Upgrade Using EBR
EBR (Edition-Based Redefinition) is a feature supported in Oracle Database which facilitates to upgrade the database component of an application while it is in use, thereby minimizing or eliminating downtime.
Upgrading by this process means, copying the database objects that comprise the
application and redefining the copied objects in isolation. These changes do
not affect application users and they continue to run the unchanged
application. When you are sure that the changes are correct, you can make
the upgraded application available to all users.
Note:
Enabling EBR involves a set of configurations which are to be performed by system administrator who is well-versed with installation and upgrade of OFSLL environment. Since this is an irreversible process, ensure that you are familiar with EBR and take extra caution before you proceed. The information provided in this section is specific to EBR configuration process in OFSLL and for detailed information about EBR, refer to https://docs.oracle.com/database/121/ADFNS/adfns_editions.htm#ADFNS020If you require EBR (Edition Based Redefinition) to be enabled, the same can be done after successful application database installation. To configure OFSLL with EBR, follow the below configuration process.
Before you begin,
- Place the executable file (
config_ebr.sh) in staging folder. - The procedures directory consists of sql files which are executed by the installation scripts to create procedures in the schema. Hence, create a directory for installation to write the sql files which will be used in subsequent steps.
- Ensure that the above mentioned directories have read, write and execute permissions before installation.