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