Installing Oracle XE 11g r2 on Amazon micro-instance (Oracle Linux 5.4)

April 4, 2011  |  apex, cloud, dba, linux  |  4 Comments

Amazon EC2 Micro instances provide 613 MB of memory and support 32-bit/64-bit platforms Linux or Windows. Micro instances price starts at $0.02 per hour for Linux and $0.03 per hour for Windows. Oracle XE 11g release 2 (beta) was launched on April 1st 2011 and it's available for Linux 64...

Read More

Reverse proxy APEX with Nginx

October 22, 2010  |  apex, linux, security  |  13 Comments

Today i'll describe how easy is to use Nginx as a reverse proxy for APEX applications, providing a layer of security by not exposing the APEX database server. Nginx (pronounced “engine X”) is a lightweight, high-performance Web server/reverse proxy and e-mail (IMAP/POP3) proxy, licensed under a BSD-like license. It is stable, secure...

Read More

Download Oracle Software with WGET

August 15, 2010  |  apex, dba, linux  |  5 Comments

Almost every people that work with Oracle software use to grab their software from either edelivery or OTN site. Some of them are avid command line geeks :)... as me! So, one of the things a command line experienced user hates is to have to go to a browser to download...

Read More

Apex on 11g R2 Release 2 post install actions

July 31, 2010  |  apex  |  No Comments

Installing Oracle 11g Release 2 is pretty straightforward... Oracle 11g R2 default installation comes with APEX 3.2 installed out of the box, but it's not accessable. After installing Oracle Database 11g R2 we need to run 2 commands to enable it [sql] exec dbms_xdb.sethttpport(8080) ALTER USER ANONYMOUS ACCOUNT UNLOCK; [/sql] apxchpwd script (located in /home/oracle/app/oracle/product/11.2.0/dbhome_1/apex for...

Read More

Speed Up execution of APEX packages – PINNING!

July 16, 2008  |  apex, dba  |  No Comments

One of the most important parts of tuning a stressed Oracle database is to increase performance of business logic code. Lot's applications in nowadays use RDBMS not only for data storage but also for business logic processing. For instance, at Neoface we always try to put every data manipulation code...

Read More

No doubt APEX is here to stay!

July 16, 2008  |  apex  |  No Comments

In 2005 there were some doubts about APEX future, former HTMLDB. Oracle made it quite simple to show its commitment in the end of 2005 by releasing their rewrited Metalink support site using their own APEX technology. If any of you still have some doubts about it, Oracle used APEX technology...

Read More