Appendix 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.

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 configuration 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_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)

Running apxsilentins.sql

Run the apxsilentins.sql script.

To run apxsilentins.sql:

Change your working directory to apex.
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>
```
Disable any existing password complexity rules for the default profile.
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_rest_pub_user
    password_internal_admin
```
Where:
- tablespace_apex is the name of the tablespace for the APEX platform schema.
- tablespace_files is the name of the tablespace for the APEX files schema.
- tablespace_temp is the name of the temporary tablespace or tablespace group.
- images is the virtual directory for APEX images. To support future 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_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 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.