Overview

This tutorial article and it’s associated video will help guide you through the process of installing APEX version 4.0 in a Windows Server 2003 64 bit OS environment with Oracle Database 11g R2 installed.

Tutorial Video

High Level steps

1. Create destination directory and extract APEX files. (0:20)
2. Login via SQLPLUS (1:13)
3. Install APEX 4.0. (1:58)
4. Change APEX ADMIN password (2:40)
5. Configure PL/SQL Gateway and unlock Anonymous User. (3:15)
6. Verify XML DB HTTP Port (4:04)
7. Enabling Network Services (4:32)
8. Enable Indexing on online help for 11g R2 (4:32)
9. Check Job Queue Processes and Shared Servers (6:45)
10. Check for Previous Releases and remove if needed. (7:00)
11. Remove Invalid ACL’s if needed (7:27)
12. Verify Install by logging in. (8:00)

Overview

This tutorial article and it’s associated video will help guide you through the process of upgrading a previously installed version of Oracle APEX to APEX version 4.0. We are going to be running on a machine that has Oracle Express Edition 10g (XE) and APEX 3.2 installed on it, in a Windows XP Professional environment.

Tutorial Video

A few kind readers asked, so we have delivered. Below is a consolidated list of all of the APEX training tutorials we have created and the links to their respective articles.

Oracle APEX Installation and Configuration

Oracle XE 10g Windows Installation Tutorial

Install Oracle APEX 3.2 on XE and Windows XP Professional Tutorial

Resetting Oracle APEX Admin Password Tutorial

APEX 3.2 Advanced Tutorial Preparation

Oracle APEX Advanced Tutorials - Video Training

Tutorial 1 - Creating a Tabular Form
   Part 1

Tutorial 2 - Parameterized Reprort
   Part 1   Part 2

Tutorial 3 - Drilldown Report
   Part 1   Part 2

Tutorial 4 - Form Layout
   Part 1   Part 2   Part 3

Tutorial 5 - Check Boxes
   Part 1   Part 2

Tutorial 6 - Implementing Web Services
   Part 1   Part 2

Tutorial 7 - Stacked Bar Chart
   Part 1

Tutorial 8 - Up and Downloading Files
   Part 1   Part 2

Tutorial 9 - JavaScript
   Part 1

Tutorial 10 - Access Controls
   Part 1   Part 2

Security. We hear about it everywhere. Make this more secure, make this less secure. In the
computer industry this is also true, and a constant need for any system or application. APEX
allows for basic security by user login, but there is more you might need to do. For this, we
have Acess Control.

Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is also true, and a constant need for any system or application. APEX allows for basic security by user login, but there is more you might need to do. For this, we have Access Controls.

JavaScript is everywhere on the Internet today. Even if you don’t realize it, this handy
little scripting tool has become one of the most used addons on the web, probably even in the
web browser your viewing this article in.

Reports and data entry constitue the bulk of what most of these tutorials cover, and what many businesses need. However, there is the need to be able to upload documents for anyone with permissions to share, afterall, why re-create the same document 100 times if you can just upload it, and others can download it.

Reports and data entry constitue the bulk of what most of these tutorials cover, and what
many businesses need. However, there is the need to be able to upload documents for anyone with
permissions to share, afterall, why re-create the same document 100 times if you can just
upload it, and others can download it

As the world moves forward, there is a higher need for more information. However, it is a near impossible task to create and manage all this information yourself. Sometimes, it’s easier to use freely availible services and information feeds provided by others. One such ‘feed’ is a Web Service.

As the world moves forward, there is a higher need for more information. However, it is a near impossible task to create and manage all this information yourself. Sometimes, it’s easier to use freely availible services and information feeds provided by others. One such ‘feed’ is a Web Service