Create and Set Up an APEX Service Instance
Set up Oracle APEX Application Development by creating and setting up an APEX Service instance.
Create an APEX Service Instance
Create an APEX Service instance on the APEX Instances page.
To create an APEX Service instance:
- Navigate to the OCI Console Sign-In Page and sign in as described in Access Oracle Cloud Infrastructure.
- In the upper left corner next to the Oracle Cloud logo, click
- From the Oracle Cloud Infrastructure left navigation list, select
Developer Services and then APEX
Application Development or APEX
Instances.The APEX Instances page appears.
- Choose your Compartment. See Understanding Compartments for information on using and managing compartments.
- At the top of the APEX Instances page, click the Create APEX service button.
- Enter the basic information:
- Compartment - Choose a compartment within your OCI tenancy. See Understanding Compartments.
- Display Name - Enter a user-friendly name to help you easily identify the resource. The display name does not have to be unique.
- Database name - Enter the database name. It must consist of letters and numbers only. The maximum length is 30 characters. The same database name cannot be used for multiple Autonomous Databases in the same tenancy in the same region.
- Configure the APEX Service:
- Always Free - Enable this switch to sign up for Always Free APEX
Service. See Always Free Oracle APEX Application Development.
Note
Enabling Show only Always Free configuration options disables some options described in this task. - Choose Database Version - Displays the available database version (for example, 19c).
- OCPU count - Specify the number of OCPU cores for your database.
- Storage (TB) - Specify the storage, in terabytes, you wish to make available to your database.
- OCPU auto scaling - By default auto scaling is enabled to allow the system to automatically use up to three times more CPU and IO resources to meet workload demand. If you do not want to use auto scaling then deselect this option to disable auto scaling.
- Storage auto scaling - Enables system to expand up to three times the reserved storage.
- Always Free - Enable this switch to sign up for Always Free APEX
Service. See Always Free Oracle APEX Application Development.
- Create administrator credentials:
- Username - The default username is
ADMIN
. This option is read-only and is not editable. - Password - Enter a password.
- Confirm Password - Enter your password again.
Tip:
Make a note of the username,ADMIN
, and your password. You need these credentials to sign into the Oracle APEX Administration Services application (Administration Services) and Database Actions.
- Username - The default username is
- Choose network access. Access Types include:
-
Secure access from everywhere - Allow users with database credentials to access the database from the internet.
-
Secure access from allowed IPs and VCNs only - Restrict access to specified IP addresses and VCNs.
Specify the following:
-
IP notation type
-
Values
-
-
Private endpoint access only - Restrict access to a private endpoint within an OCI VCN. Specifying this option allows traffic only from the VCN you specify and blocks access to the database from all public IPs or VCNs. This allows you to define security rules, ingress/egress, at the Network Security Group (NSG) level and to control traffic to your Autonomous Database.
Specify the following:
-
Virtual cloud network in
compartment
- Select a Virtual cloud network. -
Subnet in
compartment
- Select a Virtual cloud network.
-
-
- Show advanced options - Click Show advanced options to
view the following:
- Private IP address
- Host name prefix
- Network security groups (NSGs):
-
Network security group in
compartment
- Select a Virtual cloud network.To add another, click Another Network Security Group.
-
- Provide contacts for operational notifications and announcements:
- Contact Email - Enter a valid email address.
- Click Add Contact to add additional email addresses.
- Show Advanced Options - Click Show Advanced Options to
configure:
- Encryption - Encryption management settings.
- Maintenance - Patch levels.
- Management - Character sets.
- Tools - Available tools.
- Tags - Organize resources
- Click Create APEX Service.
The APEX Instances Details displays again.
When the provisioning process completes, the APX logo turns from orange to green and the Launch APEX and Launch Database Actions buttons are enabled.
- Next, complete the process of setting up your APEX Service instance and create a workspace and APEX user account as described in the next topic.
Set Up a New APEX Service
Before using a new APEX Service, you must set up your APEX Service instance by completing two tasks: create an initial APEX workspace and create an APEX user account.
Tip:
To perform these tasks from APEX Instances page, find your APEX Service instance, click the three dots (or Row menu) and select Launch APEX.
To create an initial APEX workspace and APEX user account:
- On the APEX Instance
Details, click Launch APEX.
The Administration Services Sign In page appears.
- On the Administration Services Sign In dialog:
- Password - Enter the password your specified when you created your APEX Service.
- Click Sign In to Administration.
A Welcome page appears and prompts you to create a workspace. - On the Welcome page, click Create Workspace.
- On the Create Workspace:
- Specify how to create your workspace. If you are just getting started, choose
New Schema.
Options include:
- New Schema - Create a new database schema for your
workspace:
- Workspace Name - Enter a name for the workspace. A workspace is a shared work area where multiple developers can build applications.
- Workspace Username - Enter the username of the workspace administrator.
- Workspace Password - Enter a password for the workspace administrator. See Help for details about default password complexity rules.
- Advanced - Optionally expand the
Advanced region and edit the following:
- Advanced , Database Password - Enter a password for the workspace database user. See Help for details about default password complexity rules.
- Advanced , Workspace ID - Leave Workspace ID blank to have the new Workspace ID automatically generated. A Workspace ID must be a positive integer greater than 100000.
- Existing Schema - Associate your workspace with an
existing database schema:
- Database User - Select the existing database user for the workspace. Applications will be created against database objects from this schema
- Workspace Name - Enter a name for the workspace. A workspace is a shared work area where multiple developers can build applications.
- Workspace Username - Enter the username of the workspace administrator.
- Workspace Password - Enter a password for the workspace administrator. See Help for details about default password complexity rules.
- Advanced - Optionally expand the
Advanced region and edit the following:
- Workspace ID - Leave Workspace ID blank to have the new Workspace ID automatically generated. A Workspace ID must be a positive integer greater than 100000.
Note
Make a note of the Workspace Name, Workspace Username, and Workspace Password. You will use these credentials to sign into your workspace. - New Schema - Create a new database schema for your
workspace:
- Click Create Workspace.
Administration Services appears. Use Administration Services to perform tasks such as managing user accounts, creating workspaces, monitoring workspace activity, and viewing log files.
You should have received a welcome email from Oracle which includes direct links to APEX Administration Services, APEX Application Development (your workspace), and Database Actions.
- Specify how to create your workspace. If you are just getting started, choose
New Schema.
- Sign out of Administration Services:
Tip:
You can skip this step by clicking your workspace name in the message at the top of the page which indicates your workspace has been created.- Click the Account menu in the header region.
- Click Sign out.
- Click Return to Sign in Page.
- On the Oracle APEX Sign In page, enter your workspace administrator account credentials:
- Workspace - Enter the name of your workspace.
- Username - Enter your user name.
- Enter your case-sensitive password.
- Click Sign In.
The Workspace home page appears.
See Also:
Learn About Oracle APEX