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
– 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
In this article I will describe the steps to upgrade an Oracle 188.8.131.52 Grid Infrastructure cluster on Linux to version 184.108.40.206.
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 220.127.116.11.
This patch is available on top of the base 18.104.22.168.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 22.214.171.124 the following steps are involved:
- Meet the 126.96.36.199 prerequisites
- Perform a software only installation of the base 188.8.131.52 software
- Apply latest GI PSU (184.108.40.206.3) and, if needed, some additional patches to the GI software
- Run the cluster verification utility to check the prerequisites for the upgrade
- Run the config.sh in silent mode to configure the cluster using the new 220.127.116.11 software
- Run the rootupgrade.sh to actually upgrade to version 18.104.22.168
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:
Passed the Oracle RAC 11g Release 2 and Grid Infrastructure Administration expert exam today!
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.
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:
- OpenFiler: Version 2.9
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 (22.214.171.124) 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.