Archive for October, 2010

Faster export with Data Pump parallel option

October 31, 2010  |  dba  |  1 Comment

Exporting Oracle database faster with parallel option is an excelent feature of oracle Datapump. Datapump export has become the defacto export tool on Oracle 10g (exp has been deprecated). Datapump has command line utils (expdp/impdp) and a pl/sql API (dbms_datapump). Nowadays DBA's work with databases with gigabytes or terabytes of...

Read More

Installing Flash on Linux (Centos, RHEL or OEL)

October 26, 2010  |  linux  |  No Comments

Installing flash player on linux can be so simple as running 2 lines at your console as root user. Most of the people is not aware that Adobe provides a yum repository to ease this task. For instance, if you installed Oracle software and you need a patch, probably you already...

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

RMAN Backup fail with error Rman-00600

October 22, 2010  |  dba  |  4 Comments

Managing and checking backups it's a common DBA task. Today a backup from one database that I manage, failed with the error RMAN backup failed with ORA-00600[8201] error. You should always check if the backups are finishing without errors, and you should always made some restore tests of your backups. As...

Read More