today:
139
yesterday:
311
Total:
1,018,378

SQL How to Update Oracle XE

admin 2018.04.25 21:01 Views : 161

How to Update Oracle XE Version 2 to APEX Version 4

If you have installed Oracle XE Version 2 (msi file: OracleXE.exe) then you can upgrade to the latest Oracle Apex version using the steps below.

Download and unzip the latest Apex kit from Oracle.com.

In the steps below substitute the word password with your actual XE system password.

When logging into Application Express Version 4 in Oracle Database XE, you will be presented with a login page that prompts for Workspace, Username and Password. The Workspace name is the same as the database username used to login to Oracle Database XE (except for the Admin user - see Login details below).


You should have a directory structure similar to this:
c:\oraclexe\apex (this is the unzipped Version 4 kit) 
c:\oraclexe\app (this is created by the Oracle XE installation) 
c:\oraclexe\oradata (this is created by the Oracle XE installation)

Step 1
Open DOS CMD window and change default to the directory of the unzipped Apex kit.
e.g.
CMD> cd c:\oraclexe\apex  ---- apex가 있는 위치 unzip파일 위치

Step 2 - Upgrade to Version 4 
CMD> sqlplus system/password as sysdba
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/

@apexins.sql APEX APEX TEMP /i/


Step 3 - Set images directory 
CMD> sqlplus system/password as sysdba
SQL> @apxldimg.sql c:\oraclexe

Step 4 - Set Admin password 
SQL> @apxchpwd.sql password

Step 5 - Enable remote http connections
SQL> exec dbms_xdb.setListenerLocalAccess (l_access => FALSE);

Login
URL: http://127.0.0.1:8080/apex 
Workspace: Internal 
Username: Admin 
Password: password


--------------------------------------------------------------------------
@apexins.sql APEX APEX TEMP /i/

C:\Users\solat\Downloads\apex_20.2/apex
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Joseph0323

@apex_rest_config.sql
No. Subject Author Date Views
66 NVL admin 2016.05.19 175
65 INSERT PROCESS admin 2016.04.28 176
64 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 179
63 DELETE PROCESS admin 2016.04.28 180
62 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 181
61 JAVA for delete admin 2016.04.28 181
60 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 186
59 UPDATE PROCESS admin 2016.04.28 188
58 EXPORT & IMPORT admin 2016.05.01 191
57 Captcha Test file admin 2016.04.18 192
56 CREATE TABLESPACE admin 2016.04.28 192
55 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 195
54 Apex setup procedure admin 2016.04.28 198
53 TABLE PRINT admin 2018.06.18 210
52 Name Show admin 2016.04.28 217
51 How to convert DATE to NUMBER admin 2018.05.27 217
50 MISSIONARY_SUB admin 2018.06.25 223
49 IF/ELSE ... CASE WHEN admin 2018.06.25 223
48 use a validation function for an element in apex 5.0 admin 2018.05.19 226
47 All Data DELETE from Table admin 2018.05.10 231