Oracle Apex 22.2 Installation Guide

By | December 4, 2022

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

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *