Previous Next JavaScript must be enabled to correctly display this content

## 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`)

Parent topic: Automating the APEX Installation Process

### 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 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_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` 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.

Parent topic: Automating the APEX Installation Process