Learn Oracle Application Express from anywhere in the world !

DBCON announces Live Online Training in "Developing Applications with Oracle Application Express". Forget traveling to learn the intricacies of APEX or waiting for the course to come to your city. Now anyone with a basic understanding of SQL, PL/SQL, HTML and database objects can start developing in APEX quickly and easily - with just as much live interaction with instructors and other students as they would have in an in-person course, but on a convenient online schedule. Moreover, the course is about one-fourth to one-half the price of courses offered by other institutions.

DBCON’s “Developing Applications with Oracle APEX” course, based on the firm’s progressive training methodology offers students an in-class environment with online convenience. Students can ask questions, participate in discussions and talk to instructors in real time and sketch ideas on a virtual whiteboard.

The class is not just a paraphrase of Oracle APEX training books. Our instructors have real-world experience working in Oracle and APEX, backed up by Oracle certification. Students get the benefit of speaking directly to Oracle professionals who can answer their questions in the context of working as a professional developer.

“Developing Applications with Oracle APEX” gives students a solid foundation in using the popular Rapid Web Application Development Tool. Classes include live demonstrations that allow participants to see exactly how the technology works, along with extensive hands-on lab exercises. Each student has a dedicated lab workspace available 24 hours for the duration of the class. Total training time is about 14 hours, not including individual lab time; students can attend part-time or full-time, weekdays or weekends - and classes are batch scheduled to cater to various time zones. All sessions are recorded, allowing students to revisit concepts as needed.

“Although it is simple to start using APEX, the breadth of the product can be a little overwhelming,” stated course participant Stuart Ellis of London. “This excellently structured and well-delivered course provides a solid grounding that should enable [students] to develop APEX applications with confidence. The online conferencing technology proved to be quick and unintrusive. I would not hesitate to take another course that is delivered in this way.”

Check out this audio video presentation on our Live Online Training. To view it in full screen please visit http://www.dbcon.com/video/oracle_apex_lot_video.html .

We also offer a free trial class as well as a 100% money-back guarantee on the course. To learn more, please visit http://www.dbcon.com/DevelopingWithOracleApex.html.

Configuring Oracle APEX on Port 80 (with Embedded PL/SQL Gateway) in XE database

You can use the following instructions to configure Oracle APEX on Port 80 in Oracle XE database. The default port is port 8080 but if you want it change to port 80 instead use the following steps.

Port numbers less than 1024 are reserved for use by privileged processes on many operating systems. To enable the XML DB HTTP listener on a port less than 1024 such as port 80 your DBA must do the following:

1. (UNIX only) Use this shell command to ensure that the owner and group of executable file tnslsnr are root

$ chown root:root $ORACLE_HOME/bin/tnslsnr

2. (UNIX only) Add the following entry to the listener file, LISTENER.ora, where hostname is your host name.

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 80))
(PROTOCOL_STACK = (PRESENTATION = HTTP) (SESSION = RAW))
)

3. (UNIX only) Stop, then restart the listener, using the following shell commands, where user_id and group_id are your UNIX user and group identifiers, respectively:

$ lsnrctl stop
$ tnslsnr LISTENER -user user_id -group group_id &

Use the ampersand (&), to execute the second command in the background. Do not use lsnrctl start to start the listener.

4. Use PL/SQL procedure DBMS_XDB.sethtpport with SYS as SYSDBA to setthe HTTP port number to 80 in the Oracle XML DB configurationfile /xdbconfig.xml.

SQL> exec DBMS_XDB.setHTTPPort(80);

5. Force the database to reregister with the listener, using this SQL statement:

SQL> alter system register;

6. Check that the listener is correctly configured:

$ lsnrctl status

7. Access Oracle APEX by giving the following URL. You do not need to specify the port number explicitly as port 80 is the default port.

http://hostname/apex

Reference: http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28369.pdf Page 795

Step-by-step guide to install Oracle Application Express on Oracle XE Database on Windows

Oracle Application Express - one of the hidden jewels of Oracle is a rapid web application development tool. APEX uses only a web browser to develop, deploy and administer professional applications that are fast and secure. APEX combines the qualities of a personal database, productivity, ease of use and flexibility with qualities of an enterprise database, security, integrity, scalability, availability, and built for the web.

APEX lives completely within Oracle database and is also available with Oracle Express Edition database which is a free product from Oracle.With Oracle XE & 11g APEX has no footprint at the operating system level and that makes it an extremely simple architecture to use. Using APEX applications can be deployed on a desktop to start with and can be scaled up very easily.

Try Oracle Application Express - It's easy to develop, easy to deploy & easy to administer. Check out this step-by-step guide to install Oracle Application Express on Oracle XE database on Windows platform.

Step-by-step guide to install Oracle APEX on XE on Windows - Upload a Document to Scribd

Read this document on Scribd: Step-by-step guide to install Oracle APEX on XE on Windows