Infrastructure at your Service

All posts by Nicolas Penot

Nicolas Penot



Nicolas Penot

Migrate Oracle Database(s) and ASM diskgroups from VMWARE to Oracle VM

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

This is a step by step demonstration on how to migrate any ASM disk groups from a cluster to another. May be use, with or without virtualization and may be used with storage layer snapshot for fast environment provisioning. Step 01 – Shutdown source database(s) on VMWARE servers Shutdown all databases hosted in the targeted Disk groups for which you want consistency. Then unmount the disk groups. $ORACLE_HOME/bin/srvctl stop database -db cdb001 $ORACLE_HOME/bin/asmcmd umount FRA…

 
Read More
Nicolas Penot

Oracle Application Container: a Swiss Use case

By | Database Administration & Monitoring | No Comments

Here we want to start a business in Switzerland in 3 different areas and make it easy to start a new market area as soon as required by that business. We are going to use the Application Container feature in order to: Have a dedicated PDB for each marker with shared and local metadata and data Roll out frequently data model and code to add features in a central manner with one command We have…

 
Read More
Nicolas Penot

GoldenGate 12.2.0.2 installation in a Grid infrastructure12cR2

By | Database Administration & Monitoring | No Comments

This post is a demonstration on how to deploy a fully supported Oracle GoldenGate as cluster resources. We are going to use the Oracle Grid Infrastructure Agents, called XAG to integrate the GoldenGate instance within our cluster as a cluster managed resource. This tool is provided by Oracle in the binaries with the release 12c and later but it is recommended to download and use the last version out of the box (available here). This…

 
Read More
Nicolas Penot

Automate OVM deployment for a production ready Oracle RAC 12.2 architecture – (part 02)

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

In this post we are going to deploy a R.A.C system ready to run production load with near-zero knowledge with R.A.C, Oracle cluster nor Oracle database. We are going to use the “Deploy Cluster Tool” which is provide by Oracle to perform Oracle deployment of many kind of database architectures you may need like Oracle single instance, Oracle Restart or Oracle R.A.C. This tool permits you to choose if you want an Enterprise Edition or…

 
Read More
Nicolas Penot

Automate OVM deployment for a production ready Oracle RAC 12.2 architecture – (part 01)

By | Database management, Hardware & Storage, Operation systems, Oracle | No Comments

After having worked with OVM on various architectures I can say that it is a good technology to easily build virtualized environments for production applications. Because it is based on XEN and has simple ways to deal with existing storage (FC, ISCSI, NFS, …) and networking solution (bond, lacp, …) it is a robust and convenient way to virtualized IT infrastructures keeping “bare-metal” performance. Besides, it is an hard partitioning technology which is compliant with…

 
Read More