Showing posts with label Login console. Show all posts
Showing posts with label Login console. Show all posts

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