Playing with VirtualBox, Oracle 12c (12.1.0.1) and OEL 6.4 – Part 2

We will complete our lab by installing the Oracle Database software, create a Pluggable database and take a look in the Oracle Enterprise Manager Database Express. The steps to install and create an Oracle Database 12c are: 1 – Go Continue reading Playing with VirtualBox, Oracle 12c (12.1.0.1) and OEL 6.4 – Part 2

What was new for Oracle Backup and Recovery at 11g?

Oracle 12c is around the corner and due that I have received many questions from fellow DBAs about what was new about Backup and Recovery at 11g I have decided to write a small white paper about it. Hope you Continue reading What was new for Oracle Backup and Recovery at 11g?

Tip of the month – Magic for DBAs

Who never had a problem with a SQL that is killing your Database Performance and you can’t fix it because it’s running from an external closed application that you or your developers can’t touch? Since Oracle version 10 this is Continue reading Tip of the month – Magic for DBAs

DB_ULTRA_SAFE a new GEM for High Availability

DB_ULTRA_SAFE is a new parameter introduced with Oracle 11gR1, and a fantastic new GEM for High Availability, that using Data Guard to configure on both the primary and standby will trigger the most comprehensive data corruption prevention and detection (and Continue reading DB_ULTRA_SAFE a new GEM for High Availability

Error libdb.so.2: cannot open shared object file when installing Grid Control

I’m writing this post due that I receive this question almost once a week regarding OEM installations. If you see this error when installing your Oracle Enterprise Manager (Grid Control 10.2.0.3) at OEL 5 or RHEL 5: /home/oracle/OracleHomes/oms10g/Apache/Apache/bin/httpd: error while Continue reading Error libdb.so.2: cannot open shared object file when installing Grid Control

Finally, Oracle 11gR2 is here!!

After months of tests, Oracle released today the newest release of 11g Database (11.2.0.1 – for Linux x86 and 64bit only), with more than 200 new features and a lot of excellent surprises. Oracle Database 11g Release 1 (11.1 – Continue reading Finally, Oracle 11gR2 is here!!

Back to Basics:The Oracle Editions

Sometimes understanding the Oracle Database Editions is a little confuse, and on my opinion know all the options available in the market is something very important and fundamental for any DBA. The main idea of this post is to help you Continue reading Back to Basics:The Oracle Editions

RemoteOperationException: ERROR: NMO not setuid-root (Unix-only)

One of my DBA’s just ask me why he was receiving the following error each time he tried to setup the host information thru the dbconsole (OEM): – RemoteOperationException: ERROR: NMO not setuid-root (Unix-only) The answer is very easy, this Continue reading RemoteOperationException: ERROR: NMO not setuid-root (Unix-only)

How to solve the error “EXP-00056: ORACLE error 19206″ during an export

If you see the error EXP-00056 with Oracle error 19206 (like show bellow) when executing a export of an entire schema in Oracle 9i or 10g, don’t panic. The solution is easy. EXP-00056: ORACLE error 19206 encountered ORA-19206: Invalid value Continue reading How to solve the error “EXP-00056: ORACLE error 19206″ during an export

Be a hero, be proactive!

Let start this New Year with a new mentality or a new resolution if you prefer call this way, let stop being reactive and start being proactive. Being proactive will reduce your database administration costs and increase your level of Continue reading Be a hero, be proactive!