Article : https://mindmajix.
com/how-to-install-oracle-apex
ORACLE HOME USER(new window user):
username : user_123
password : 1234
---------------------------------------------
Global Database name: apexdb
SID : apexdb
---------------------------------------------
Automatically shared memory management :
SGA size : 2379 MB
PGA size : 794 MB
---------------------------------------------
Same administrative password for all accounts :
password : 1234
---------------------------------------------
Changed Password management :
HR :
password - 12
----------------------------------------------
CMD:(Connect to database )
"D:\Oracle_installation\WINDOWS.X64_193000_db_home\bin\sqlplus.exe"
----------------------------------------------
D:\Oracle_installation\app\user_12\oradata\APEXDB
------------------------------------------------
CREATEING TABLESPACE :-
CREATE TABLESPACE APEX321 DATAFILE 'D:\Oracle_installation\app\user_123\oradata\
APEXDB\APEX321.dbf' SIZE 1000M AUTOEXTEND ON NEXT 1M;
-------------------------------------------------
Administrator's name: - user_1
Administrator's email: - [email protected]
Administrator's password : - Oracle$029
Incance created : user_1
Password : Oracle$029
APEX_Listener Password : 1234
--------------------------------------------------
ORDS installation Path:
'java -jar ords.war --config D:\Oracle_installation\Oracle_apex\Oracle_ords\config
install'
java --add-opens java.prefs/java.util.prefs=ALL-UNNAMED -jar ords.war --config D:\
Oracle_installation\Oracle_apex\Oracle_ords\config install
-----------------------------------------------
Custom database url :
jdbc:oracle:thin:@localhost:1521:apexdb
jdbc:oracle:thin:@[HOST][:PORT]:SID
----------------------------------------------------
Start Listner/Stop Listener
lsnrctl stop
lsnrctl start
----------------------------------------------------
HOST : - DESKTOP-03TCHDU.lan
---------------------------------------------------
listener.ora files code(OLD) :
# listener.ora Network Configuration File: D:\Oracle_installation\
WINDOWS.X64_193000_db_home\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = apexdb)
(ORACLE_HOME = D:\Oracle_installation\WINDOWS.X64_193000_db_home)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\Oracle_installation\WINDOWS.X64_193000_db_home\
bin\oraclr19.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
-------------------------------------------------------------------
listener.ora file :- (Updated)
# listener.ora Network Configuration File: D:\Oracle_installation\
WINDOWS.X64_193000_db_home\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = apexdb) # SID for the database
(ORACLE_HOME = D:\Oracle_installation\WINDOWS.X64_193000_db_home) # Path to
Oracle Home
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) # Listener
address
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) # For external procedures
)
)
----------------------------------------------------------------------
ords.conf file :-
(previous)
# ORDS Service Script Configuration File (ords.config)
#
# This file should be placed in the /etc folder.
# Following are the properties that can be set via this file:
#
# ORDS_BASE The base path for ORDS installation by default is /opt/oracle
# but if the rpm was installed with --prefix [path] to relocate
# the package this variable will track the installation path.
# If you install ORDS by ORDS zip file is not possible to track
# and you need to set this value.
# ORDS_CONFIG The absolute path to an ORDS configuration directory. If set
# and not empty then the script will overwrite the configdir
# property in the ords.war file located next to the script
# whenever the script is called with the start parameter.
# SERVE_EXTRA_ARGS Extra arguments to pass to serve command like
# "--java-options "-Xms32G -Xmx32G" --port 8888 --apex-images $
{APEX_IMAGES}".
# Examples
#ORDS_BASE=/opt/oracle #Only if installed by zip file.
#ORDS_CONFIG=/etc/ords/config
#SERVE_EXTRA_ARGS=--java-options "-Xms32G -Xmx32G" --port 8888 --apex-images $
{APEX_IMAGES}
---------------------------------------------------------------------------------
ords.conf : file (NEW-updated)
# ORDS Service Script Configuration File (ords.config)
# Base path for ORDS installation (update this to your actual installation path)
ORDS_BASE=D:/Oracle_installation/Oracle_apex/Oracle_ords
# Absolute path to the ORDS configuration directory
ORDS_CONFIG=D:/Oracle_installation/Oracle_apex/Oracle_ords/config
# Additional arguments for the serve command
# Update the port or APEX images path if needed
SERVE_EXTRA_ARGS=--port 8080 --apex-images
D:/Oracle_installation/Oracle_apex/apex/images
---------------------------------------------------------------------------------
tnsnames.ora file (NEW):-
# tnsnames.ora Network Configuration File: D:\Oracle_installation\
WINDOWS.X64_193000_db_home\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
APEXDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = apexdb)
)
)
LISTENER_APEXDB =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
---------------------------------------------------------------------------------
After installation :
RUN apex : java --add-opens java.prefs/java.util.prefs=ALL-UNNAMED -jar ords.war --
config D:\Oracle_installa
tion\Oracle_apex\Oracle_ords\config serve
---------------------------------------------------------------
Creating Workspace :
Schema Name:- Admin
Schema Password:- admin
Space Quota (MB):- 100
Identify Administrator:-
Administrator Username:- user_1
Administrator Password:- Oracle$029
First Name:- Unicloud
Last Name : --------
Email :-
[email protected]Workspace Created: -
Workspace Team_Unicloud provisioned with administrator user_1. Database user ADMIN
created with default tablespace APEX_1600447553066398 using datafile D:\
ORACLE_INSTALLATION\APP\USER_123\ORADATA\APEXDB\APEX_1600447553066398.DBF
Password updated : user_1 - Unicloud$029
