Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
12c database | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Applying the July 2019 Database Release Update Patch

  • Posted by Gavin Soorma
  • On July 24, 2019
  • 0 Comments
This note describes the steps used to apply the latest July 2019 Database Release Update Patch for Oracle 12c Release 2. The environment is single instance Multitenant database. Notes 1)Review MOS note Master Note for Database Proactive Patch Program (Doc ID 756671.1) 2)Download patch p29699168_122010_Linux-x86-64.zip – COMBO OF OJVM RU COMPONENT 12.2.0.1.190716 + 12.2.0.1.190716 DBJUL2019RU […]
Read More
 2

Oracle Database 19c Sharding Hands-On Tutorial

  • Posted by Gavin Soorma
  • On June 6, 2019
  • 0 Comments
Oracle Sharding is an architecture in which data is horizontally partitioned across a number of independent physical databases called shards. Think of it as one giant database partitioned into many small databases located on different servers – similar to the concept of one giant table being divided into a number of smaller partitions. Unlike the […]
Read More
 2

Oratop utility

  • Posted by Gavin Soorma
  • On May 16, 2018
  • 1 Comments
Oratop is a utility very similar in nature to the ‘top’ unix OS utility. It provides an almost real-time overview of both RAC as well as single-instance database performance and can be used in combination with top to get a more complete overview of system performance and identify and monitor any activity causing bottlenecks. Oratop […]
Read More
 5

Oracle 12c Release 2 (12.2.0.1.0) Grid Infrastructure Upgrade

  • Posted by Gavin Soorma
  • On March 10, 2017
  • 4 Comments
I recently performed an upgrade of an Oracle 12c Release 1 (12.1.0.2) Grid Infrastructure environment hosted on a RAC Virtual Box environment on my laptop to the latest release 12c Release 2 12.2.0.1.0 version. Here are some points to be noted related to the upgrade process: The Grid Infrastructure 12c Release 2 (12.2) software is […]
Read More
 2

Oracle Database 12c Release 2 (12.2.0.1) upgrade using DBUA

  • Posted by Gavin Soorma
  • On March 3, 2017
  • 0 Comments
Oracle 12c Release 2 (12.2.0.1) was officially released for on-premise deployment yesterday. I tested an upgrade of one of my test 12.1.0.2 databases using the Database Upgrade Assistant (DBUA) and the upgrade went smoothly. The Parallel Upgrade command line utility catctl.pl has a number of changes and enhancements as compared to 12c Release 1 and […]
Read More
 2

Oracle Database In-Memory 12c Release 2 New Features

  • Posted by Gavin Soorma
  • On March 1, 2017
  • 0 Comments
The Oracle Database In-Memory 12c Release 2 New Features  webinar conducted last week was well received by a global audience and feedback was positive. For those who missed the session you can download the slide deck from the link below. Feedback and questions are welcomed! 12.2_InMemory_new_features
Read More
 5

Oracle Exadata X5-2 Data Guard Configuration

  • Posted by Gavin Soorma
  • On November 1, 2016
  • 0 Comments
This note describes the procedure of creating an Oracle 11.2.0.4 Data Guard Physical Standby database with a two-node Real Application Cluster (RAC) Primary and Standby database on an Oracle Exadata X5-2 eight rack. The procedure will use RMAN for the creation of the Physical Standby database and will use the DUPLICATE FROM ACTIVE DATABASE method […]
Read More
 2

Oracle 12c Resource Manager – CDB and PDB resource plans

  • Posted by Gavin Soorma
  • On July 6, 2016
  • 0 Comments
In a CDB since we have multiple pluggable databases sharing a set of common resources, we can prevent multiple workloads to compete with each other for both system as well as CDB resources by using Resource Manager. Let us look at an example of managing resources for Pluggable Databases (between PDB’s) at the multitenant Container […]
Read More
 

Oracle 12c Pluggable Database Upgrade

  • Posted by Gavin Soorma
  • On August 26, 2015
  • 0 Comments
Until very recently I had really believed the marketing hype and sales pitch about how in 12c database upgrades are so much faster and easier than earlier releases – just unplug the PDB from one container and plug it in to another container and bingo you have an upgraded database! Partly true …. maybe about […]
Read More