CamOra ICT

Your solution to High Availability

OOW 2012: What’s next for Oracle Database

leave a comment »

Database Consolidation challenges:

– Reduce IT costs by consolidating more servers
Reduces TCO and increase ROI

– Reduce numbers of databases

– Keep database applications isolated and unchanged

Pluggable databases

– Container database with one set of background processes and one set of memory

– Plug database (PDB) in Container databases (CDB) and shared resources

– Recommended upgrade to 12c:

Upgrade database to 12c and then migrate non-CDB to CDB. Plug individual databases in 12c container database. Completely integrated in EM12c

– Highly efficient:

Up to 6x less resources, up to 5x more scalable compared to separate databases

– Simplify Patching and upgrades

Create new CBD and plug database in new CBD, enables you to test upgraded PBD  individually

– Backup CDB as a whole and as a PDB, also for restore

– Standby database for whole CDB

– Very fast cloning of databases for Test and Development, especially in combination with copy on write filesystems

– Pluggable databases as Saas (Software as a Service) because of quick provisioning

– NO changes to applications!

– Tom Kyte, yeah! Top 12 features in 12c

1. Even better PL/SQL from SQL

2. Improved defaults, eg sequence assignment

3. Increase size limits for VARCHAR2, NVARCHAR2 and RAW Databse types up to 32K

4. Easy Top-N and pagination queries, easy clauses in sql statement

5. Row pattern matching, describe the pattern in sql with single sql statement

6. Adaptive execution plans, add extra steps in plan and adapt dynamically

7. Enhanced statistics, hybrid histograms gives good insight in skewed data

8. Temporary UNDO, undo for temporary segments, bypass redo

9. Data optimization, where are the hot and coldspots, moves data arround based on usage

10. Application Continuity, guarantee transaction, transparent to the application

11. Database security, data redaction, filter out data without influence for the application

12. Pluggable databases! No namespace collisions anymore

Database Testing Challenges

– Rigorously test all consolidated workloads

– Be able to scale teting of testing of database workloads

– Control allocation of resources across workloads

With Consolidated Replay you are able to replay captures concurrently on databases consolidated in a CDB

So you can identify problems within CDB and use resource manager, implement a resource plan on the PDB involved

Written by Hans Camu

01/10/2012 at 20:29

Posted in Uncategorized

Upgrade Grid Infrastructure from 11.2.0.2 to 11.2.0.3 on Linux

with one comment

In this article I will describe the steps to upgrade an Oracle 11.2.0.2 Grid Infrastructure cluster on Linux to version 11.2.0.3.
In this article a 2-node cluster with nodes RAC1 and RAC2 is used for this purpose.
Unlike most other articles I will not describe how to use the OUI to install the software and do the upgrade.
For this purpose I will execute a software only installation of the GI software (for which the OUI will be used, but there it ends)
and then also apply some patches before the actual upgrade. The upgrade itself will be executed using the silent option of the config.sh tool.
I will show you how to check the prerequisites to upgrade the Grid Infrastructure software.

The upgrade of the RDBMS software and the upgrade of the database will NOT be discussed here, but in a next article.

Before you start upgrading make sure patch 12539000: 11203:ASM UPGRADE FAILED ON FIRST NODE WITH ORA-03113 is installed.
Without this patch you will not be able to perform a successful upgrade to 11.2.0.3.
This patch is available on top of the base 11.2.0.2.0 version and a version is available for GI PSU 1 until GI PSU 5.
The patch is included from GI PSU 6 and above.

To upgrade to 11.2.0.3 the following steps are involved:

  1. Meet the 11.2.0.3 prerequisites
  2. Perform a software only installation of the base 11.2.0.3 software
  3. Apply latest GI PSU (11.2.0.3.3) and, if needed, some additional patches to the GI software
  4. Run the cluster verification utility to check the prerequisites for the upgrade
  5. Run the config.sh in silent mode to configure the cluster using the new 11.2.0.3 software
  6. Run the rootupgrade.sh to actually upgrade to version 11.2.0.3

Upgrade Grid Infrastructure from 11.2.0.2 to 11.2.0.3 on Linux

Written by Hans Camu

29/08/2012 at 20:14

Install Oracle VM Server 3

leave a comment »

This post will describe the installation of Oracle VM Server 3.0.3 on a new system. For this purpose I configured a very nice server with lots of memory to create several Oracle VM guest which can run simultaneous.

Because Oracle VM Server will be the operating system, no other os is installed. Some screenshots are from an installation on VMWare because I couldn’t capture the actual screen, but forgive me for this.
Follow the next steps to install Oracle VM Server:

Install Oracle VM Server 3

Written by Hans Camu

05/05/2012 at 18:47

Passed RAC 11.2 expert exam

leave a comment »

Passed the Oracle RAC 11g Release 2 and Grid Infrastructure Administration expert exam today!

Written by Hans Camu

27/04/2012 at 18:29

Posted in Uncategorized

Install Grid Infrastructure 11gR2 on OL6 and Oracle VM

with 3 comments

This article is one in a series of describing how-to install Oracle VM Server and several Oracle VM guests.
In this article I will describe how-to install Grid Infrastructure 11gR2 (GI) on 2 Oracle Virtual Machines with Oracle Linux 6 as Operating System.

The steps described in this article will be:

  • Create 2 virtual machines on the command line using a installation directory and a kickstart file
  • Configure the virtual machines to be able to successfully install GI
  • Add shared disks for the GI installations using disk local to the OVS or Openfiler NAS
  • Install Grid Infrastructure 11gR2
  • Install Oracle 11gR2 RDBMS Software
  • Create an Oracle 11gR2 RAC database

The installation will take place on virtual machines with 4GB of memory.
This guide is for testing purposes only. It is not supported to run a production environment with a setup like described in this article.

For the installation we will use Oracle Linux 6.1 64-bit with the Oracle Linux Server-uek (2.6.32-100.34.1.el6uek.x86_64) kernel.
You must be aware that this is NOT a certified Oracle Linux version and kernel at the time this article is published.
All you read in this article is for testing purposes only, and don’t hold it against me if you use it otherwise.

Install Grid Infrastructure 11gR2 on OL6 and Oracle VM

Written by Hans Camu

03/12/2011 at 20:33

Install OpenFiler 2.9 on Oracle VM

leave a comment »

I am running an Oracle VM server at home. On this Oracle VM server I am running several Oracle virtual machines. Because I am planning to Install Grid Infrastructure 11R2 using Network Attached Storage (NAS)
I looked into the possibilities of free NAS software.

For this purpose free NAS software is a good option. But I have some requirements:

  • NAS software must be free
  • VPN software must be easy to configure

After some research I ended up with the following software:

Install OpenFiler 2.9 on Oracle VM

Written by Hans Camu

02/12/2011 at 16:47

Install Oracle Enterprise Manager Cloud Control 12c on Oracle VM

with one comment

This article describes how-to install Oracle Enterprise Manager Cloud Control 12c (OEM12c) on an Oracle Virtual Machine.
The steps described in this article will be:

  • Create a virtual machine using virt-install and a kickstart file
  • Install Oracle 11g (11.2.0.3) RDBMS Software
  • Create Oracle 11gR2 database
  • Install Oracle Enterprise Manager Cloud Control 12c

The installation will take place on a virtual machine with 8GB of memory. Based on the documentation and experience this is the bare minimum.

Install Oracle Enterprise Manager Cloud Control 12c on Oracle VM

Written by Hans Camu

16/11/2011 at 21:11