Download Apex20.2 from the below link:
https://www.oracle.com/tools/downloads/apex-downloads.html
1. Unzip the apex_22.2_en.zip file to your installation directory.
Sql plus**
SQL>Conn sys as sysdba
Check sga_max_size through this command
SQL> Show parameter sga
if sga_max_size< 3000M THEN
SET IT TO AT LEAST 4000M USING this command
SQL> alter system set memory_target= 4000M SCOPE=SPFILE;
——FROM SYS/SYS AS SYSDBA——– CONTAINER DB
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
SQL> alter pluggable database ORCLPDB open;
Pluggable database altered.
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
SQL> Alter session set container = ORCLPDB;
Session altered.
SQL> CREATE OR REPLACE TRIGGER open_pdbs
AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE ‘ALTER PLUGGABLE DATABASE ALL OPEN’;
END open_pdbs;
/
Trigger created.
SQL>Show parameter sga
2. Open Sqlplus login as sysdba & Create a Tablespace for apex installation.
SQL> CREATE TABLESPACE APEX DATAFILE ‘C:\oracle21c_base\oradata\ORCL\APEX.DBF’ SIZE 100M AUTOEXTEND ON;
NOTE: Change your datafile location as my location is <‘C:\Database\oradata\orcl>.
3. Open Command (cmd)
Set your Apex unzip directory connect sqlplus & paste that line @apexins apex apex temp /i/ Or @apexins.sql SYSAUX SYSAUX temp /i/
and press enter. It will take 10-15 minutes.
C:\Windows\system32>cd C:\apex_22.2\apex
C:\apex_22.2\apex>sqlplus/nolog
SQL*Plus: Release 21.0.0.0.0 – Production on Tue Nov 29 13:16:38 2022
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> @apexins apex apex temp /i/
Or @apexins.sql SYSAUX SYSAUX temp /i/
…set_appun.sql
4. After completing the previous steps paste the below line and give the user name, email address, and password.
SQL> @apxchpwd.sql
…set_appun.sql
================================================================================
This script can be used to change the password of an Oracle APEX
instance administrator. If the user does not yet exist, a user record will becreated.
================================================================================
Enter the administrator’s username [ADMIN]
User “ADMIN” does not yet exist and will be created.
Enter ADMIN’s email [ADMIN] admin@gmail.com
Enter ADMIN’s password [] M@vros123#
Created instance administrator ADMIN.
5. After completing steps 4 paste the below line and give Password twice like: admin_123
SQL>@apex_rest_config.sql
6. After completing the previous steps paste the below lines:
NOTE: To remember the password use the same password for all. As I used “admin_123”.
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;
ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;
ALTER USER APEX_220200 ACCOUNT UNLOCK identified by admin_123;
ALTER USER ORDSYS ACCOUNT UNLOCK identified by admin_123;
ALTER USER ANONYMOUS ACCOUNT UNLOCK identified by admin_123;
7. For Oracle Database version 12c or later run the below script:
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => ‘*’,
ace => xs$ace_type(privilege_list => xs$name_list(‘connect’),
principal_name => ‘APEX_220200’,
principal_type => xs_acl.ptype_db));
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => ‘localhost’,
ace => xs$ace_type(privilege_list => xs$name_list(‘connect’),
principal_name => ‘APEX_220200’,
principal_type => xs_acl.ptype_db));
END;
/
EXEC DBMS_XDB.sethttpport(0);
Commit
NOW Click hare for ORDS install
Ords Installation Guide For Oracle Apex
