Thank you for joining this comprehensive guide that demonstrates the step-by-step installation procedure for Oracle Apex.
Throughout this tutorial, we will provide detailed instructions on setting up Oracle Apex version 23.1 alongside ORDS version 23.1.4 within an Oracle pluggable Database environment running version 21c.
Regardless of your expertise level, whether you're new to development or an experienced professional, this tutorial is designed to swiftly introduce you to Oracle Apex and assist you in quickly building your inaugural application.
Software Download Links:
First need to Download the Oracle Apex, JDK and ORDS in order:
Unlock the power of a comprehensive and easy-to-follow step-by-step script.
1st Step - Install Apex 23.1
Create Apex tablespace
sqlplus / as sysdba
show pdbs
alter session set container = PDB1;
select name from v$datafile;
create tablespace apex datafile size 200M autoextend on next 10m maxsize unlimited;
select name from v$datafile;
Run APEX Installation Script
@apexins.sql APEX APEX TEMP /i/
Change APEX Admin Password
@apxchpwd.sql
username ADMIN
password Oracle123#
Unlock Database Accounts
ALTER USER anonymous ACCOUNT UNLOCK;
alter user APEX_PUBLIC_USER identified by Oracle123 account unlock;
ALTER USER flows_files ACCOUNT UNLOCK;
2nd Step - Install JDK 11.0.15 or later
If you don't have JDK installed,
just double click the JDK file and click Next to install it.
3rd Step - Install ORDS 23.1.4
Create Required Users for ORDS
@apex_rest_config.sql
Enter a password for the APEX_LISTENER user
Enter a password for the APEX_REST_PUBLIC_USER user
Disable the Oracle XML DB Protocol Server
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
EXEC DBMS_XDB.SETHTTPPORT(0);
Unlock ORDS Database Accounts
alter user APEX_LISTENER identified by Oracle123 account unlock;
alter user APEX_REST_PUBLIC_USER identified by Oracle123 account unlock;
alter user ORDS_PUBLIC_USER identified by Oracle123 account unlock;
Configure Oracle REST Data Services (ORDS)
Open CMD window
cd D:\Apex\ords
java -jar ords.war --config D:\Apex\ords\config install
Enter a number to select the type of installation
[1] Install or upgrade ORDS in the database only
[2] Create or update a database pool and install/upgrade ORDS in the database
[3] Create or update a database pool only
Choose [2]:2
Enter a number to select the database connection type to use
[1] Basic (host name, port, service name)
[2] TNS (TNS alias, TNS directory)
[3] Custom database URL
Choose [1]:1
Enter the database host name [localhost]:localhost
Enter the database listen port [1521]:1531
Enter the database service name [orcl]: PDB1
Provide database user name with administrator privileges.
Enter the administrator username: sys as sysdba
Enter the database password for the sys as sysdba: oracle
Enter the default tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [SYSAUX]: APEX
Enter the temporary tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [TEMP]: TEMP
Enter a number to select additional feature(s) to enable:
[1] Database Actions (Enables all features)
[2] REST Enabled SQL and Database API
[3] REST Enabled SQL
[4] Database API
[5] None
Choose [1]:1
Enter a number to configure and start ORDS in standalone mode
[1] Configure and start ORDS in standalone mode
[2] Skip
Choose [1]: 1
Enter a number to select the protocol
[1] HTTP
[2] HTTPS
Choose [1]:1
Enter the HTTP port [8080]:8080
Enter the APEX static resources location: D:\Apex\apex\apex\images
Free Tag -
rajuddx bytebotsolution #Oracle #APEX231 #installation #ORDS #database #SQL #PLSQL #development #webdevelopment #applicationdevelopment #software #technology #programming #coding #databaseadministration #datamanagement #webapps #server #backend #databasequerying #OracleApexInstallation #DatabaseDevelopment #InstallationGuide #OracleDevelopment #WebDevelopment#SoftwareInstallation#OracleDatabase#ApplicationDevelopment #WebApplications#TechTips#TechBlog #DatabaseManagement #WebDevelopmentTips #SoftwareDevelopment #Programming #CodeTips #TechTutorial#ITTips #SoftwareEngineering #TechnologyInsights
0 Comments