Archive for June, 2008

This is an APEX patch, not an upgrade!

June 27, 2008  |  apex, dba, security  |  No Comments

Today I tried to upgrade APEX 3.1.0 running on 11g like a rookie :) May be I woke up blind or just lazy... Every upgrade I made before was made with these steps: download and unzip apex_release.zip shutdown and startup database keeping listener down... logon as sys (/) and start patching load apex images finally startup...

Read More

Basic Oracle XE and APEX Backup

June 19, 2008  |  apex, linux, security  |  6 Comments

There are thousands of people around the world using Oracle XE APEX version for developing applications and many of them just don't know how to backup their database. Oracle XE database comes with 9 essential files that are the database itself. If you backup those 9 files you have your...

Read More

NEOPI video demo

June 10, 2008  |  linux  |  4 Comments

This post just wants to show you how easy you can setup Linux to be ready for Oracle 10g or 11g versions on any RHEL 4/5 based distributions (CentOS, Oracle Linux, Redhat, Whitebox Linux). After running NEOPI successfully you can run Oracle Universal Installer (OUI) without any problems and checkup...

Read More

Data Pump PL/SQL partial export

June 10, 2008  |  dba, pl/sql  |  11 Comments

Since the release 10g, Oracle have redesigned the export / import method. Oracle still ships EXP and IMP but DATA PUMP is now the standard tool for fast data movement between databases. DATA PUMP syntax is very similar to EXP/IMP, although its technology is entirely different. Data Pump runs independent database...

Read More

Neoface Oracle Pre-Installer RELEASED!

June 7, 2008  |  dba, linux  |  7 Comments

I'm proud to announce the release of NEOPI english version. NEOPI is Neoface Oracle Pre-Installer. As I posted some weeks ago NEOPI is a tool to ease the pre-installation tasks that all you guys around have to do when you install Oracle software on CentOS or Redhat. We've been very busy...

Read More

I'm PROUD to be Portuguese! off-Topic :)

June 3, 2008  |  off-Topic  |  4 Comments

Portugal is a country of emigrants... It always been, but specially in the last 80 years. Switzerland is one of the many European countries that has a relatively large portuguese community. As you may know, the EURO 2008 CUP will start this week and it will take place in Austria...

Read More