Showing posts with label APEX. Show all posts
Showing posts with label APEX. Show all posts

Tuesday, November 26, 2019

Oracle APEX 19.2 Managing Instance Login and Workspace requests

Oracle APEX 19.2 Managing Instance Login and Workspace requests
----------------------------------------------------------------------
Login to the APEX Console

WORKSPACE - INTERNAL
USERNAME - ADMIN
PASSWORD - **********

Traverse to Oracle APEX Home page, Under Instance tasks go to Instance settings

Under Self Service
Provision Status, we will have 3 options
1. Manual
2. Request
3. Request with Email Verification

These determine how the process of provisioning (or creating) a workspace works for your development instance.

Options include:

Manual - An Application Express administrator manually creates new workspaces and notifies the Workspace administrator of the login information.

Request - Users request workspaces directly in a self-service fashion. Selecting this option displays a link on the Login page enabling users to request a workspace. When a user requests a workspace, each request is submitted to a queue for approval.

Email Verification - Works similar to Request except each user receives an initial email containing a link. Clicking this link validates the user's email address before the request is processed.

Note: To enable users to request a workspace using a link on the Login page, you must choose Request or Email Verification. If you select Manual, no link appears on the login page.

As an Instance Adminstrator, we can Manage requests. Approve or Decline requests.


You can watch the video on the above in this link  https://youtu.be/-vz-J5s8l20 

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