Now that 12c was released it’s time to install in on OEL 6.4 64 bits OS. Let’s start playing with this. Before we start with the creation of the VM we will need to download some software first, such as: The VirtualBox for Windows: https://www.virtualbox.org/wiki/Downloads The OEL 6.4 OS: https://edelivery.oracle.com/linux The Oracle Database 12c Release…
Category: Oracle FAQ
Frequent Answers for Questions Made in the Oracle OTN Foruns
Once again, How to Improve your Oracle Career
The main question about the DBA job I hear all the time is: How can I became a successful DBA? Most of the people that I talk to who have difficulties starting out in their DBA career really have an issue trying to absorb the mountainous volumes of information that a DBA needs to know…
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 will enjoy reading it as much I enjoyed writing it. What_is_new_at_11g Cheers, Francisco Munoz Alvarez
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 a problem of the past, now you can easy solve this kind of problem using…
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 repair on 11gR2, see **) tool in the market. ** Starting in Oracle Database 11g Release…
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 loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory Don’t…
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 – Released at August 2007) and Release 2 (11.2 – Released today) are the versions with…
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 to understand a little bit more about all available options in the Oracle market, learn…
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 error occurs when you forgot to run the root.sh after you finished your installation, you…
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 for query or REF CURSOR parameter ORA-06512: at “SYS.DBMS_XMLGEN”, line 83 ORA-06512: at “SYS.DBMS_METADATA”, line…