Project Name 11gR2/2011 Author Francisco Munoz Alvarez Software Used Oracle Enterprise Linux 5.6 Oracle VirtualBox 4.0.2 Oracle 11.2.0.2 Database and Infrastructure Software Date 02/02/2011 The idea of this tutorial is to show you how you can create an Oracle Database 11gR2 using Oracle VirtualBox and OEL. This installation should never be used for Production or…
Category: Tutorials
Playing with Oracle 11gR2, OEL 5.6 and VirtualBox 4.0.2 (2nd Part)
Project Name 11gR2/2011 Author Francisco Munoz Alvarez Software Used Oracle Enterprise Linux 5.6 Oracle VirtualBox 4.0.2 Oracle 11.2.0.2 Database and Infrastructure Software Date 02/02/2011 The idea of this tutorial is to show you how you can create an Oracle Database 11gR2 using Oracle VirtualBox and OEL. This installation should never be used for Production or…
NZOUG and LAOUC June and July Webinars (Recording)
Hi All, NZOUG (New Zealand Oracle Users Group) and LAOUC (Latin American Oracle Users Communty) is organizing a serie of webinars to Oracle Community (over 42 Webinars) with the participation of several Oracle Celebrities, and is my desire to share the first 8 webinars recorded with all Oracle Users around the world! Please find bellow all the webinars recorded…
Tip of the Month: How to have super powers using Data Pump!
A lot of people don’t know several powerful functionalities that we have available when using Data Pump (expdp/impdp), most of the people only use these tools to export and import data (in other words, only to move data), and never notice that it can be used for example to help us to do: Data Masking…
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…
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…
Installing Grid Control – Part I
By Francisco Munoz Alvarez Before you start with an installation of Grid Control, I’ll recommend you to go thru the documentation to understand all the minimum requirements and the installation process. For reference purpose, I’ll resume some important points of it here. Let’s start taking a close look in the components of the Grid Control …
LOGGING or NOLOGGING, that is the question – Part VI
By Francisco Munoz Alvarez TIPS USING NOLOGGING MODE DIRECT PATH INSERT To use Direct Path Insert use the /*+ APPEND */ hint as follow: INSERT /*+ APPEND */ into … SELECT … When direct path insert is used oracle does the following: Format the data to be inserted as oracle blocks. Insert the blocks above…
Let’s play with Oracle RAC 11g and Oracle Enterprise Linux 5- Part I
This is the first of many workshops I’ll start to post on my blog, at the end of each one I’ll post the full paper and some videos teaching step by step each workshop. Let’s start with the first one 😉 Part I – Creating the Virtual Environment Project Name Oracle Rac5/2008 Author Francisco…