Blog Posts on ‘Oracle’
Oracle Application Express 4.1 Early Adopter is now available
Breaking News: Oracle Application Express 4.1 early adopter release is now available for you to try at http://tryapexnow.com/
To learn about all new cool features of this release please navigate to URL http://apex.oracle.com/pls/apex/f?p=52663:1
Useful URLs for Oracle Application Express
Here is a list of all the useful URLs on Oracle Application Express. If you would like to see all the books available on Oracle Application Express please visit http://www.asagarwal.com/547/oracle/books-on-oracle-application-express/ .
As URLs constantly change, if any of the following URL is not working, please leave a comment with details and I will update the URL. Also if you come across any other URL that is useful for Oracle Application Express, do let me know. I will include that URL in the list here.
Oracle APEX Home Page
http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html
Oracle APEX Download Page
http://www.oracle.com/technetwork/developer-tools/apex/documentation/index.html
Oracle APEX Manuals
http://www.oracle.com/technetwork/developer-tools/apex/documentation/index.html
Oracle APEX Packaged Applications
http://www.oracle.com/technetwork/developer-tools/apex/application-express/packaged-apps-090453.html
Oracle APEX 4.0 New Features
http://apex.oracle.com/pls/apex/f?p=34738:1:0
Oracle APEX Forum
http://forums.oracle.com/forums/forum.jspa?forumID=137
Get an Oracle APEX Workspace On Internet
http://apex.oracle.com/pls/apex
Oracle APEX Certification
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=1001&lang=US&p_exam_id=1Z0_450
Oracle APEX Plug-Ins (By Oracle)
http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-plug-ins-182042.html
Oracle APEX Plug-Ins (By Community)
http://www.apex-plugin.com
Oracle APEX Listener
http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html
Oracle APEX Listener Forum
http://forums.oracle.com/forums/forum.jspa?forumID=858
Oracle APEX Live Online Training
http://www.dbcon.com/courses.html
Books on Oracle Application Express
Here is the complete list of available & yet-to-be-released books on Oracle Application Express. Yet-to-be-released books are mainly based on Oracle Application Express 4.0. Click on the icon to order or pre-order books from Amazon.com
 Published : December 2008
|
 Published : June 2010
|
 Published : September 2008
|
 Published : December 2010 |
 Published : July 2009
|
 Published : August 2009
|
 Published : September 2009
|
 Published : December 2009 (German) |
 Published : 2009 (French) |
The following books on Oracle Application Express will be released soon. Click on the icon, if you would like to pre-order these books from Amazon.com
 |
 |
 |
 |
 |
Tom Kyte’s DBA Resolutions for 2009
Read Tom Kyte’s DBA Resolutions for 2009. I liked it and you will too. It’s available at http://www.oracle.com/newsletters/information-indepth/database-insider/jan-09/kyte.html?msgid=7295775
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
6. 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