Tuesday, January 8, 2019

How to install and uninstall Oracle Apex 18.2

--Download apex

https://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

Enter user-name: sys as sysdba
Enter password:

--check version

SQL> select version from dba_registry where comp_id='APEX';

VERSION
------------------------------
18.2.0.00.12

Install Apex 18.2
cmd
cd C:\Apex\apex_18.2\apex
sqlplus

(* Connect to SQL*Plus as the SYS user and run the "apexins.sql" script, specifying the relevant tablespace names and image URL.
 * Note: The above script create some SCHEMA on Database, you can test by querying View ALL_USERS on  SQLPlus)

cmd
cd C:\Apex\apex_18.2\apex

sqlplus

sys as sysdba/passwwd

@apexins.sql sysaux sysaux temp /i/

--take time

--Change Password
(* Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user
 * Password must contain at least one punctuation character. For example: =_-*$# etc)
@apxchpwd.sql

user     : orclapex/Admin
Password : $Abcd_1234

(* Embedded PL/SQL Gateway (EPG) Configuration
 * The images in an Oracle XML DB HTTP Server with the embedded PL/SQL gateway installation are in the XML DB repository.
   Updating the images is accomplished by running the SQL Script apxldimg.sql)

@apxldimg.sql C:\Apex\apex_18.2

--take time
(* Run the "apex_epg_config.sql" script, passing in the base directory of the installation software as a parameter.)

@apex_epg_config.sql C:\Apex\apex_18.2

--take time

Enter user-name: sys as sysdba
Enter password:

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

SELECT DBMS_XDB.gethttpport FROM DUAL;


EXEC DBMS_XDB.sethttpport(8080);

Commit;

http://localhost:8080/apex/apex_admin


Uninstall 

Enter user-name: sys as sysdba
Enter password:

--UNINSTALL ORACLE APEX from Databse

@apxremov.sql


-- again check

SQL> select version from dba_registry where comp_id='APEX';

no rows selected

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...