How to Install Oracle APEX 24.1 | DB 23ai Pluggable | Windows 10 | Omar Baig
Today we are going to Install Oracle APEX 24.1 and ORDS 25.1 with Database 23ai Express Edition [Pluggable] in Windows 10 InshaAllah.
Patreon: / omarbaig
a. Create folder with name "23ai_24.1" under this folder we create 3 folder with the name "DB" & "ords", and "ordsconf".
b. Under "ordsconf" create folder with the name "config"
c. Download Oracle Database 23ai from this link
https://www.oracle.com/database/techn...
d. Unzip Oracle Database 23ai in (D:\Oracle\Database)
e. Download ORDS from this link
https://www.oracle.com/database/sqlde...
f. Unzip ORDS
We extract ORDS in a folder "ords" (C:\23ai_24.1\ords), so we do not need to copy & paste it (ords)
g. Download Oracle APEX 24.1 from this link
https://www.oracle.com/tools/download...
h. Unzip "apex_24.1" in a folder (C:\23ai_24.1), so we do not need to copy & paste it (apex folder)
Java version is Java 24 (java -version) (For ORDS 22.1, 22.2 & 23.1, 24.4, 25.1 install Java 11 at least.)
Remember
Before attempting to install Oracle Database XE 23ai, uninstall any existing Oracle Database XE or database with the SID FREEPDB1 from the target system.
The installer will use SID free for database creation. Any SID other than SID FREE will not be allowed.
i. Run database setup with "Administrator" rights.
j. Hit "Next" button.
k. Check on "I accept the terms..." & hit "Next" button.
l. Change Directory while hitting "Change" button & hit "Next" button. (C:\23ai_24.1\DB\)
m. Enter Database Password & Confirm Password for "SYS", "SYSTEM", & "PDBADMIN" from your choice, hit "Next" button.
n. Hit "Install" button.
o. Hit "Finish" button.
Pluggable Database name is "FREEPDB1" & port is 1521
p. Open cmd & reach where apex folder is available. (C:\23ai_24.1)
q. Run sqlplus /nolog
r. Connect as sys as sysdba
s. We will find pluggable database is in "READ WRITE" while running this command
SELECT name, open_mode
FROM v$pdbs;
t. If not in "READ WRITE" mode then we run this command
ALTER PLUGGABLE DATABASE FREEPDB1 OPEN;
u. Run this command
show pdbs; (this command will run before every apex scripts @apexins, @apxchpwd.sql, @apex_rest_config.sql to make sure that we connect with pluggable database or not, if we connect it then run apex scripts, if not then run below command)
ALTER SESSION SET CONTAINER = FREEPDB1;
v. Install apex by running this command
@apexins sysaux sysaux temp /i/
w. Run @apxchpwd.sql, username is "ADMIN", email, & pass.. from your choice.
x. Run this command & make sure that you connect with "SYS" user
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
y. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER)
z. Open Cmd again with "Administrator" rights & reach where ORDS folder is available. (C:\23ai_24.1\ords)
za. Run this command java -jar ords.war --config C:\23ai_24.1\ordsconf\config install
zb. Basic (...) [1]: Hit "Enter" button.
zc. Enter the Database ... [localhost]: Hit "Enter" button
zd. Enter the database listen ... [1521]: Hit "Enter" button, my port is 1521 your port will be different.
ze. Enter the database service ... [...]: provide FREEPDB1, because my database service name is "FREEPDB1"
zf. Enter administrator username, pass..
zg. Choose [A]: Enter "3"
zh. Choose [G]: Enter "s"
zi. Enter database pass.. and Confirm Pass.. for ORDS_PUBLIC_USER from your choice.
zj. Choose [A]: Enter "9"
zk. Copy images folder from "C:\23ai_24.1\apex" and paste it to "C:\23ai_24.1\ords"
zl. Enter the APEX static resources...: Provide "image" path "C:/23ai_24.1/ords/images"
zm. If you want other changes do it pressing desire number.
zn. Choose [A]: Enter "A"
zo. Once "Oracle REST Data Services initialized" appear use Oracle APEX through this link (localhost:8080/ords/apex)
zp. Open cmd with administrator rights, reach where ORDS folder is available (C:\23ai_24.1\ords) & run this command "java -jar ords.war --config C:\23ai_24.1\ordsconf\config serve", when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize command prompt do not close it.
Search Tags:
Omar Baig, How to Uninstall Oracle APEX 24.1, Uninstall Oracle APEX 24.1, How to Install Oracle APEX 24.1, Oracle APEX 24.1 Installation, How to Uninstall Oracle APEX 23.2, Uninstall Oracle APEX 23.2, How to Install Oracle APEX 23.2, Oracle APEX 23.2 Installation, How to Uninstall Oracle APEX 23.1, Uninstall Oracle APEX 23.1, How to Install Oracle APEX 23.1, Oracle APEX 23.1 Installation, Uninstall Oracle APEX 24.2, How to Uninstall Oracle APEX 24.2, Oracle APEX 24.2 Installation, How to Install Oracle APEX 24.2
Chapters
00:00 Introduction
00:38 Creating Folders
02:23 Unzipping Folders
06:59 Necessary Advise
08:03 Database Installation
10:38 Oracle APEX 24.1 Installation
13:53 Oracle APEX 24.1 Configuration
15:49 ORDS 25.1 Installation
18:46 Copy Images Folder
32:04 How to Start ORDS 25.1
#OmarBaig #oracleapex