Migrating from Oracle Portal 10g to Oracle APEX

Subra SubramanyamBusiness Strategy, Case Studies, Oracle, Technical Tips2 Comments

Migrating from Oracle Portal 10g to Oracle Application Express (APEX)

There are several enterprises that are currently running the Oracle 10g middleware platform for their front-end applications. They have Oracle Portal 10g or prior versions delivering content for their Oracle Forms, Oracle Reports, and Oracle Discoverer based applications, all running on Oracle Application Server (OAS) 10g. Many of these OAS 10g environments also run Oracle Internet Directory (OID) 10g and Oracle Single Sign-On (OSSO) 10g. Oracle provides a supported and easily repeatable upgrade path for Oracle Database 11g, however, the upgrade of components running on OAS 10g moving to Oracle WebLogic Server (WLS) 11g is not quite as straightforward. Oracle … Read More

Oracle APEX 4 Advanced Tutorial 1 – Creating A Tabular Form Video Walkthrough

kevin.landonTechnical TipsLeave a Comment

Creating A Tabular Form Video Walkthrough

This tutorial is designed to walk you through chapter 2 of the Oracle APEX Advanced Tutorial, Creating a Tabular Form. We will be creating an application with a form, testing the base form, then extending the functionality of that base form. If you haven’t already, please review our APEX Tutorial Preparation and OEHR Sample Data Install Video Walkthrough. APEX 4.2 Series We created and made the original set of tutorials back in 2009 when version 3.2 of APEX was released. Since then we have had an amazing response to our series, even as new versions were released. As of 2013, … Read More

BPM 11g Integrated with WebCenter Spaces (Process Spaces)

AshokNews and Updates, Offerings, Technical TipsLeave a Comment

Our Fusion Middleware expertise allows us to bring it all together. Do you want to follow business processes and ensure transparency to your organization? M&S Consulting has implemented a next generation process portal built on Oracle BPM/SOA, Identity Management, WebCenter, and innovating solutions built by M&S from the ground up. Underlying technologies include WebLogic and ADF.

Installing APEX 4 on Windows Server 2003 64 bit edition with Oracle Database 11g

kevin.landonTechnical Tips6 Comments


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)

Upgrading to APEX 4 on Oracle XE and Windows

kevin.landonTechnical Tips6 Comments


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


Oracle APEX Video Training Tutorials – Complete List

kevin.landonTechnical Tips9 Comments

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 Report    Part 1   Part 2 Tutorial 3 – Drilldown Report    Part 1   Part … Read More