[go: up one dir, main page]
Scribd
Upload
81 views2 pages

Apex Installation Steps

The document outlines the steps to install Oracle APEX on an Oracle database. It includes creating a tablespace for APEX, running installation scripts to configure APEX, setting the APEX container, creating APEX users, configuring the EPG and HTTP ports, and unlocking and changing passwords for key APEX accounts.

Uploaded by

Nadeem
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
81 views2 pages

Apex Installation Steps

The document outlines the steps to install Oracle APEX on an Oracle database. It includes creating a tablespace for APEX, running installation scripts to configure APEX, setting the APEX container, creating APEX users, configuring the EPG and HTTP ports, and unlocking and changing passwords for key APEX accounts.

Uploaded by

Nadeem
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Paki1#947 ACCOUNT UNLOCK;

GRANT CONNECT, RESOURCE, DBA TO APEX_PUBLIC_USER;

java -jar apex_22.2_en.zip

ALTER SESSION SET CONTAINER = XEPDB1;

Step 0. Remove old installation


===============================
@apxremov.sql

DROP TABLESPACE APEX INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

Step 1. Create a new tablespace to act as the default tablespace for APEX.
==========================================================================
CREATE TABLESPACE APEX DATAFILE 'APEX.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M;

Step 2. Connect to SQL*Plus as the SYS user and run the "apexins.sql" script,
specifying the relevant tablespace names and image URL.
===================================================================================
==================================================
@apexins.sql APEX APEX TEMP /i/

@apex_epg_config.sql C:\apex\apex_22.2_en\

Step 3. Once complete, change the admin password by running the "apxchpwd.sql"
scripts as the SYS user.
===================================================================================
====================
@apxchpwd.sql

If you want to add the user silently, you could run the following code, specifying
the required password and email.
BEGIN
APEX_UTIL.set_security_group_id( 10 );

APEX_UTIL.create_user(
p_user_name => 'ADMIN',
p_email_address => 'nomi647@hotmail.com',
p_web_password => 'Paki#1947',
p_developer_privs => 'ADMIN' );

APEX_UTIL.set_security_group_id( null );
COMMIT;
END;
/

Step 4. Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the


"apex_rest_config.sql" script.
===================================================================================
===========================
@apex_rest_config.sql

If you want to add these users silently, you can specify the passwords as
parameters to the script.
@apex_rest_config.sql ApexPassword1 ApexPassword2

Step 5. Embedded PL/SQL Gateway (EPG) Configuration.


====================================================
@apex_epg_config.sql C:\apex\product\21c

Step 6. Unlock the ANONYMOUS account.


=====================================
DECLARE
l_passwd VARCHAR2(40);
BEGIN
l_passwd := DBMS_RANDOM.string('a',10) || DBMS_RANDOM.string('x',10) || '1#';
-- Remove CONTAINER=ALL for non-CDB environments.
EXECUTE IMMEDIATE 'ALTER USER anonymous IDENTIFIED BY ' || l_passwd || ' ACCOUNT
UNLOCK CONTAINER=ALL';
END;
/

Step 7. Check the port setting for XML DB Protocol Server.


==========================================================
SELECT DBMS_XDB.gethttpport FROM DUAL;
if 0 value return then run below statement

EXEC DBMS_XDB.sethttpport(8080);

APEX should now be available from a URL like "http://machine:port/apex".

Step 8. Change the password and unlock the APEX_PUBLIC_USER account. This will be
used for any Database Access Descriptors (DADs).
===================================================================================
===============================================
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Paki#1947 ACCOUNT UNLOCK;

select dbms_xdb.gethttpport from dual;

http://localhot:8080/apex/apex_admin

http://127.0.0.1:8080/apex

http://localhost:8181/apex/apex_admin

select username, account_status from dba_users where username like '%APEX%';

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;
/

You might also like