Thursday, September 20, 2012

Oracle HTTP Server Mod_rewrite to Redirect to Apex Home Page

Suppose you have Oracle Fusion Middleware 11.1.1.2.0 Web Tier installed and it is required to redirect the base URL:
http://<hostname>:<port>
to the default APEX application URL (APP_ID =1001)
http://<hostname>:<port>/apex/f?p=1001

The Solution

You will need to add the RewriteRule directives to the httpd.conf file inside the virtual host that was configured to listen on mentioned <port>.
```
RewriteEngine on
RewriteLog logs/rewrite.log
RewriteRule ^/$ /apex/f?p=1001 [R]
RewriteRule ^/index.html$  /apex/f?p=1001 [R]
```
Restart HTTP Server so changes will take effect.
Test accessing http://<hostname>:<port>, it should redirect you to the APEX application page.

This will start Apex application with predefined default page.

Redirect to non default page

If you want to start specific application page (non default) change:

 
RewriteRule ^/$ /apex/f?p=1001 [R]
RewriteRule ^/index.html$  /apex/f?p=1001 [R]

 
RewriteRule ^/$ /apex/f?p=1001:xxx [R]
RewriteRule ^/index.html$  /apex/f?p=1001:xxx [R]

where xxx is Apex page number you want to start.

The End

This is nothing but making one official reminder for future reference ...
Hope this helps someone.
Cheers!

Sunday, September 16, 2012

Debugging in Apex (3.0.1 and onward) with Embedded PL/SQL Gateway

If your web page, run by Oracle EPG Web server, displays an error that you cannot resolve easily, you can see all the errors with the activating error logging. It allows you to trace PL/SQL errors when you develop a web application.
You must first activate the log option with a PL/SQL command. Make sure you are logged in as a SYSTEM user prior to running the below command:

SQL> execute dbms_epg.set_global_attribute('log-level', 3)

Where different log-levels are:
0 - LOG_EMERG (Default Log-Level)
1 - LOG_ALERT
2 - LOG_CRIT
3 - LOG_ERR
4 - LOG_WARNING
5 - LOG_NOTICE
6 - LOG_INFO
7 - LOG_DEBUG
This should generate a .trc file on the server file system in bdump directory. To get this location, use classic checking of parameter:

SQL> show parameter background_dump_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string c:\oracle\product\10.2.0\dbhome_1\admin\XE\bdump

Note that there will be many .trc and .trm files in this directory from different DB functions. The files of interest are the .trc files that are generated at the time of the APEX event of interest. To further identify the specific .trc file(s) containing the desired information, accomplish a unix grep or windows find for the word "APEX" in the file:

UNIX
```
grep APEX .trc
```
Windows
```
type .trc|find "APEX"
```

The End

This is nothing but making one official reminder for future reference...
Hope this helps someone.
Cheers!

Wednesday, September 5, 2012

Java download locations

This short blog post has intention to make short notice about how to download any kind of Java JRE for Windows. Regardless it is 32 or 64 bit version ... looking for correct one, may be sometime consuming and a little frustrating.
So here are links for all 6 and 7 versions:

For all other (non Windows) Java versions, look at

All other older versions for all platforms, as well as previous one, may be downloaded form OTN for which you must have free OTN account.
Hope this help someone.

Cheers!