Скачать или смотреть How to Install Oracle APEX 23.1 | DB 19c Pluggable | Windows 10 | Omar Baig

Today we are going to Install Oracle APEX 23.1 and ORDS 25.1 with Database 19c [Pluggable] in Windows 10 InshaAllah.

Patreon:   / omarbaig  

a. Create folder with name "19c_23.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 19c from this link
https://www.oracle.com/database/techn...
d. Unzip Oracle Database 19c 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:\19c_23.1\ords), so we do not need to copy & paste it (ords)
g. Download Oracle APEX 23.1 from this link
https://www.oracle.com/tools/download...
h. Unzip "apex_23.1" in a folder (C:\19c_23.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.)
i. Run database setup with "Administrator" rights.
j. Create and configure a single instance database. Hit Next Button
k. Desktop Class. Hit Next Button
l. Use Windows Built-in Account. Hit Next Button.
m. Assign "Global Database Name (orcl), Pass.. & Confirm Pass.. from your choice, Change path while hitting Browse Button and hit Next Button.
n. Hit "Install" button.
o. Hit "Close" button.
p. Open command prompt & reach where apex folder is available. (C:\19c_23.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 ORCLPDB 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 = ORCLPDB;
(Make sure "Session altered" appear if not then connect again as sys / as sysdba)
v. Install apex by running this command
@apexins sysaux sysaux temp /i/
w. Run @apxchpwd.sql, username is "ADMIN", email, & password 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 "bin" folder is available under ORDS. (C:\19c_23.1\ords\bin)
za. Run this command ords.exe --config C:\19c_23.1\ordsconf\config install
zb. Choose [1]: Select "s" then Hit "Enter" button.
zc. Basic (...) [1]: Hit "Enter" button.
zd. Enter the Database ... [localhost]: Hit "Enter" button
ze. Enter the database listen ... [1521]: Hit "Enter" button, my port is 1521 your port will be different.
zf. Enter the database service ... [...]: provide ORCLPDB, because my database service name is "ORCLPDB"
zg. Enter administrator username, pass..
zh. Choose [A]: Enter "3"
zi. Choose [G]: Enter "s"
zj. Enter database pass.. and Confirm Pass.. for ORDS_PUBLIC_USER from your choice.
zk. Choose [A]: Enter "9"
zl. Copy images folder from "C:\19c_23.1\apex" and paste it to "C:\19c_23.1\ords"
zm. Enter the APEX static resources...: Provide "image" path "C:/19c_23.1/apex/images"
zn. If you want other changes do it pressing desire number.
zo. Choose [A]: Enter "A"
zp. Once "Oracle REST Data Services initialized" appear use Oracle APEX through this link (localhost:8080/ords/apex)
zq. Open cmd with administrator rights, reach where "bin" folder is available under ORDS (C:\19c_23.1\ords\bin) & run this command "ords.exe --config C:\19c_23.1\ordsconf\config serve", when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize cmd 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:36 Creating Folders
02:05 Unzipping Folders
05:03 Database Installation
07:40 Oracle APEX 23.1 Installation
10:58 Oracle APEX 23.1 Configuration
12:47 ORDS 25.1 Installation
16:25 Copy Images Folder
19:29 How to Start ORDS 25.1

#OmarBaig #oracleapex`