Tuesday, November 26, 2019

INSTALLATION OF ORACLE APEX 19.2 ON ORACLE DATABASE 12.2

-- Check the status of firewall
#service iptables status

-- Stop the firewall
#service iptables stop

-- Login to the Database
sqlplus / as sysdba

-- check the mode in which the database is opened
select name, open_mode from v$database;

-- if database is not up
startup

-- Create a tablespace dedicated for APEX
CREATE TABLESPACE APEX_TBS DATAFILE '/u01/app/oracle/oradata/orclapex/apex01.dbf' SIZE 100M AUTOEXTEND ON maxsize unlimited;

-- Create an APEX directory and give it required permissions
mkdir -p /home/oracle/apex
unzip apex_19.2.zip
chown -R oracle:oinstall /home/oracle/apex
chmod -R 755 /home/oracle/apex
cd /home/oracle/apex

-- Installation of the APEX. You will obtain the installation log something like this in base directory install2019-11-14_17-50-55.log
@apexins.sql APEX_TBS APEX_TBS TEMP /i/

-- It will take around 8 minutes for the APEX modules to get installed.

-- Change the password of the console login ADMIN user
@apxchpwd.sql
-- You will have to Enter ADMIN password
-- anilshenoy.in@gmail.com
-- Password must something like Anil_123 (It should have Alpha numeric values, an uppercase aplhabet and a special character

-- Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.
@apex_rest_config.sql

-- i chose Embedded PL/SQL Gateway (EPG) to front APEX not ORDS for a change
@apex_epg_config.sql /home/oracle/apex

-- Unlock the ANONYMOUS user
sqlplus / as sysdba
alter user ANONYMOUS identified by Oracle_123

-- check if 8080 port is listening
netstat -an

-- if the port is not open, then you can execute the below
sqlplus / as sysdba
SELECT DBMS_XDB.gethttpport FROM DUAL;
EXEC DBMS_XDB.sethttpport(8080);

Now access

http://IP_ADDRESS:8080/apex

WORKSPACE - INTERNAL
USERNAME - ADMIN
Password - <The one that we have entered on execution of @apxchpwd.sql script>



You cam watch the same at this URL -  https://youtu.be/1xpD2o0gfJE 

No comments:

Post a Comment