A Automating the Oracle Application Express Installation Process
Automate the process of installing and configuring an Oracle Application Express instance.
- About apxsilentins.sql
Run theapxsilentins.sql
script to automate the installation and configuration of an Oracle Application Expresss instance. - Running apxsilentins.sql
Run theapxsilentins.sql
script.
A.1 About apxsilentins.sql
Run the apxsilentins.sql
script to automate the
installation and configuration of an Oracle Application Expresss instance.
Traditionally you run the run the apexins.sql
script to install
Oracle Application Express 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 Application
Express schema: APEX_PUBLIC_USER
, APEX_LISTENER
,
APEX_REST_PUBLIC_USER
and the Oracle Application Express 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.
apxsilentins.sql
script, removes the need for
completing the following topics:
-
"Installing Application Express"
-
"Creating or Updating Your Instance Administration Account"
-
"Configuring the APEX_PUBLIC_USER Account"
-
"Enabling Network Services in Oracle Database 11g or Later"
-
"Configuring Static File Support" (
apex_rest_config.sql
)
A.2 Running apxsilentins.sql
Run the apxsilentins.sql
script.
To run apxsilentins.sql
:
For example:
@apxsilentins.sql SYSAUX SYSAUX TEMP /i/ Passw0rd!1 Passw0rd!2 Passw0rd!3 Passw0rd!4
Once apxsilentins.sql
completes, you complete the steps
in "Downloading and Installing Oracle REST Services" 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 Oracle Application Express Users."