8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
APEX Tips : Basic APEX Management
Some quick tips about basic APEX management.
- Create a New Instance Administrator
- Create a New User
- Create a New Workspace
- Manage Schema Assignments
- Export a Workspace
- Import a Workspace
- Export an Application
- Import an Application
- Upgrade an Application
- Post Upgrade Checks
- Refresh Application Theme
- Amend Navigation Menu Template Options
- Validate APEX Installation
- Validate ORDS Installation
Related articles.
Create a New Instance Administrator
- Login to the INTERNAL workspace as the ADMIN user, or another existing admin user.
- Click the "Create User" link on the right-hand menu.
- For a new admin user enter mandatory items and the following.
- Workspace : INTERNAL
- Default Schema : APEX_180200 {or whatever the highest version is}
- User is an administrator: Yes
- Account Availability : Unlocked
- Password and Confirmation Password.
- Require Change of Password on First Use : Yes
- Click the "Create User" button.
Create a New User
You can create a new user from the INTERNAL workspace, or from a specific workspace. The user creation is similar, but the entry into it is a little different.
- INTERNAL : Click the "Create User" link on the right-hand menu.
- WORKSPACE : Admin Icon (top toolbar) > Manage Users and Groups > Create User
For a new workspace administrator or developer user enter mandatory items and the following, then click the "Create User" button.
- Workspace : {enter workspace if available}
- Default Schema : {select schema}
- User is an administrator: {depending on WS admin or not}
- User is an developer: Yes
- Account Availability : Unlocked
- Password and Confirmation Password.
- Require Change of Password on First Use : Yes
Create a New Workspace
- Login to the INTERNAL workspace as the ADMIN user, or another existing admin user.
- Click the "Create Workspace" link on the right-hand menu. You can also get this from the "Manage Workspace" section.
- Enter a workspace names and click the "Next" button. This is the workspace name a developer will login with.
- If you have already created a schema, do the following.
- Re-use existing schema? : Yes
- Schema Name : {select the schema}
- Click the "Next" button.
- If you need to create a new schema, do the following.
- Re-use existing schema? : No
- Schema Name : {entered new schema name}
- Schema Password : {entered pass}
- Space Quota (MB) : {select required quota}
- Click the "Next" button.
- Enter the admin user details, you can add more later, and click the "Next" button.
- Click the "Create Workspace" button.
- Click the "Done" button.
- Create additional admin and developer users for the workspace.
Manage Schema Assignments
- Login to the INTERNAL workspace.
- Click on the "Manage Workspaces" link.
- Click on the "Manage Workspace to Schema Assignments" link.
- Click the "Add Schema" button.
- Accept the "Existing" option by clicking the "Next" button.
- Select the workspace you wish to assign a schema to, and click the "Next" button.
- Select the schema you want to assign to the workspace, and click the "Next" button.
- Click the "Add Schema" button.
Export a Workspace
- Login to the INTERNAL workspace as the ADMIN user, or another existing admin user.
- Manage Workspaces > Export Workspace
- Select the workspace and click the "Export Workspace" application.
- Select the options you want and click the "Save File" button, then pick a location and save the file.
- Click the "Cancel" button on the "Export Workspace" dialog.
Import a Workspace
- Login to the INTERNAL workspace as the ADMIN user, or another existing admin user.
- Manage Workspaces > Import Workspace
- Click the "Choose file" button and select the file holding the workspace you want to import, then click the "Next" button.
- Enter the password for the workspace schema and click the "Next" button.
- Check the confirmation checkbox and click the "Next" button.
- Click the "Install Workspace" button.
- You are presented with the "Imported Workspace Export Files" screen. The operation is complete.
Export an Application
- Go into the application builder and click on the application of interest.
- Click the "Export/Import" link.
- Click the "Export" link.
- Select the export options, the defaults are usually fine, and click the "Export" button.
- Save the file in the normal way.
Import an Application
If you are transferring a new version of an application to an environment, you will need to delete the old version of the application first.
- Go into the application builder and click on the application of interest.
- Click the "Delete this Application" link on the right-hand menu.
- Click the "Permanently Delete Now" button.
You can now continue with the import.
- Go into the application builder and click "import" button.
- Click the "Choose file" button and select the file holding the application you want to import, then click the "Next" button. There several options you can pick from, but the default "Database Application, Page or Component Export" is the one you want.
- Click the "Next" button.
- Select the "Reuse Application ID ??? From Export File" option and click the "Install Application" button.
- The application is now imported.
Upgrade an Application
- Go into the application builder and click on the application of interest.
- Utilities > Upgrade Application
- If any of the components in the application need to be upgraded, they will be listed.
- Click on each link in turn (the number on the right-side) and perform the upgrade.
- The upgrade is complete once the last group of components is upgrade and the list is empty.
Post Upgrade Checks
Compatibility Mode:
- Application > Shared Components > Application Definition Attributes
- Select the "Compatibility Mode" required. Typically the latest.
- Click the "Apply Changes" button.
Javascript:
- Application > Shared Components > User Interface Attributes
- Click the "Pen" icon next to the "Desktop" row.
- In the JavaScript section decide what Javascript support you wuld like. To use the latest, uncheck the checkboxes and select "No" for the "Include jQuery Migrate" option.
- Click the "Apply Changes" button.
Components:
- Application > Shared Components > Component Settings
- Check the components listed have the desired settings. Typically "Switch" will need editing. Enter values for "Yes" and "No", and select "Switch" for the "Display Style".
- Click the "Apply Changes" button.
Theme:
- Application > Shared Components > Themes
- Drill into theme.
- Click the "Refresh Theme" button.
- Click the "Icons" tab and check the "Library" is set to "Font APEX".
- Click the "Styles" tab and select the style of interest.
- Make sure it is marked as "Is Current".
- If you made any changes, click the "Apply Changes" button.
Refresh Application Theme
- Go into the application builder and click on the application of interest.
- Shared Components > Themes > Universal Theme - 42
- Click on the "Refresh Theme" button.
- Click on the "Apply Changes" button.
Amend Navigation Menu Template Options
- Refresh theme, as described above.
- Remember to re-select your Template Style if you are not using the default.
- Go to "Shared Components > User Interface Attributes".
- Click on the "Pen" icon next to the "Desktop" item.
- Under "Navigation Menu" section select the following:
- Template Options: Use Template Defaults
- Style: Style A
- Click "Apply Changes", and "Apply Changes" again.
- If you have any problems, it's worth switching between theme styles in the Theme Roller.
Validate APEX Installation
Some database operations, such as database upgrades, can leave APEX in an invalid state. Running the following command will validate the APEX installation and redo any missing grants. If you've installed APEX in a PDB, remember to switch to the relevant PDB before running the command.
CONN / AS SYSDBA --ALTER SESSION SET CONTAINER=pdb1; SET SERVEROUTPUT ON EXEC SYS.validate_apex;
Validate ORDS Installation
Check out the note here.
For more information see:
Hope this helps. Regards Tim...