A Automating the APEX Installation Process

Automate the process of installing and configuring an Oracle APEX instance.

• About apxsilentins.sql
  Run the apxsilentins.sql script to automate the installation and configuration of an Oracle APEX instance.
• Running apxsilentins.sql
  Run the apxsilentins.sql script.

A.1 About apxsilentins.sql

Run the apxsilentins.sql script to automate the installation and configuration of an Oracle APEX instance.

Traditionally you run the run the apexins.sql script to install Oracle APEX and then perform a multiple other steps to configure the APEX_PUBLIC_USER account. The apxsilentins.sql script simplifies the installation and configuation process. apxsilentins.sql accepts additional parameters so that passwords can be passed for following database users associated with the Oracle APEX schema: APEX_PUBLIC_USER, APEX_LISTENER, APEX_REST_PUBLIC_USER and the Oracle APEX Instance Administration user, ADMIN. You can also use these passwords for the configuration of middle tiers and other processes. apxsilentins.sql also completes other installation steps such as creating and setting the password for the Instance Administration user, ADMIN, configuring a network ACL, and configuring Oracle REST Data Services.

Running the apxsilentins.sql script, removes the need for completing the following topics:

• Installing APEX

• Creating or Updating Your Instance Administration Account

• Configuring the APEX_PUBLIC_USER Account

• Enabling Network Services in Oracle Database

• Configuring Static File Support (apex_rest_config.sql)

A.2 Running apxsilentins.sql

Run the apxsilentins.sql script.

To run apxsilentins.sql:

1. Change your working directory to apex.
2. Start SQLcl and connect as user SYS to the database where Oracle APEX is installed. You will need to specify the SYSDBA role. For example:

   • On Windows:

     SYSTEM_DRIVE:\ sql /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password

   • On UNIX and Linux:

     $ sql /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password

3. Disable any existing password complexity rules for the default profile.
4. Run apxsilentins.sql passing the following eight arguments in the order shown:

   @apxsilentins.sql tablespace_apex tablespace_files tablespace_temp images
         password_apex_pub_user password_apex_listener password_apex_rest_pub_user
         password_internal_admin

   Where:

   • tablespace_apex is the name of the tablespace for the Oracle APEX application user.
   • tablespace_files is the name of the tablespace for the Oracle APEX files user.
   • tablespace_temp is the name of the temporary tablespace or tablespace group.
   • images is the virtual directory for Oracle APEX images. To support future Oracle APEX upgrades, define the virtual image directory as /i/.
   • password_apex_pub_user is the password for the APEX_PUBLIC_USER database account.
   • password_apex_listener is the password for the APEX_LISTENER database account.
   • password_apex_rest_pub_user is the password for the APEX_REST_PUBLIC_USER database account.
   • password_internal_admin is the password for the Instance Administration ADMIN Oracle APEX account. This password must meet the following requirements:
     • Contain at least 6 characters.
     • Contain at least one numeric character (0123456789).
     • Contain at least one punctuation character (!"#$%&()``*+,-/:;?_).
     • Contain at least one uppercase alphabetic character.

For example:

@apxsilentins.sql SYSAUX SYSAUX TEMP /i/ Passw0rd!1 Passw0rd!2 Passw0rd!3 Passw0rd!4

Once apxsilentins.sql completes, you follow the steps in Downloading and Installing Oracle REST Data Services (ORDS) and Configuring Oracle REST Data Services (except for "Configuring Static File Support").

Use the passwords you supplied to apxsilentins.sql when completing these steps. Then, move on to Creating a Workspace and Adding APEX Users.