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
Administration | Oracle DBA – Tips and Techniques | Page 3
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle 12c GoldenGate Implementation Workshop online training

  • Posted by Gavin Soorma
  • On January 11, 2017
  • 1 Comments
Oracle 12c GoldenGate Implementation Workshop online training is commencing 23rd January.   This 20 hour workshop will comprise topics included in the official Oracle University GoldenGate 12c Essentials, GoldenGate Advanced Configuration and GoldenGate Tuning and Troubleshooting classes.   Use the following links to register for the  online  training classes:  7.00 to 9.00 PM IST Batch […]
Read More
 

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 RMAN DUPLICATE Database

  • Posted by Gavin Soorma
  • On September 3, 2015
  • 0 Comments
In earlier versions the RMAN DUPLICATE database command was a push-based method. One of the new features in Oracle 12c is that it has been changed to a pull-based method which has many advantages. Let us note the difference between the two methods. In the earlier push-based method, the source database transfers the required database […]
Read More
 1

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
 

PSU Patch Deployment using EM12c

  • Posted by Gavin Soorma
  • On April 17, 2015
  • 0 Comments
The Patch Deployment feature in EM12c can greatly help in automating the rolling out of patches when we have to deploy the patch on a large number of targets – this significantly reduces both the time and complexity involved in the process. Let us look at an example of deploying the JAN 2015 PSU patch […]
Read More
 

Oracle 12c Partitioning New Features

  • Posted by Gavin Soorma
  • On March 18, 2015
  • 0 Comments
Online Move Partition In Oracle 12c we can now move as well as compress partitions online while DML transactions on the partitioned table are in progress. In earlier versions we would get an error like the one shown below if we attempted to move a partition while a DML statement on the partitioned table was […]
Read More
 

Oracle 12c New Feature Real-Time Database Monitoring

  • Posted by Gavin Soorma
  • On March 6, 2015
  • 0 Comments
Real -Time Database Monitoring which is a new feature in Oracle 12c extends Real-Time SQL Monitoring which was a feature introduced in Oracle 11g. The main difference is related to the fact that SQL Monitoring only applies to a single SQL statement . Very often we run batch jobs and those batch jobs in turn […]
Read More
 1

Upgrade Grid Infrastructure 11g (11.2.0.3) to 12c (12.1.0.2)

  • Posted by Gavin Soorma
  • On March 4, 2015
  • 0 Comments
I have recently tested the upgrade to RAC Grid Infrastructure 12.1.0.2 on my test RAC Oracle Virtualbox Linux 6.5 x86-64 environment. The upgrade went very smoothly but we have to take a few things into account – some things have changed in 12.1.0.2 as compared to Grid Infrastructure 12.1.0.1. The most notable change regards the […]
Read More
 5

Oracle 12c New Feature – Privilege Analysis

  • Posted by Gavin Soorma
  • On February 26, 2015
  • 0 Comments
In many databases we find that over the course of time certain users particularly application owner schemas and developer user accounts have been granted excessive privileges – more than what they need to do their job as developers or required for the application to perform normally. Excessive privileges violate the basic security principle of least […]
Read More
 

Performing a database clone using a Data Guard Snapshot Database

  • Posted by Gavin Soorma
  • On January 28, 2015
  • 1 Comments
Some times we need to have an exact replica of the production database data to urgently test an issue encountered in production. If the production database is very large having a clone process running on the production server or taking a fresh full database backup just for the clone is also not desirable as well […]
Read More
 

EM12c Cloud Control Metric Extensions – Monitor failed DBMS SCHEDULER Jobs

  • Posted by Gavin Soorma
  • On January 13, 2015
  • 0 Comments
So what are Metric Extensions? As the name implies metric extensions enables us to extend the out-of-the-box monitoring capabilities of Enterprise Manager and customize it according to the requirements of our specific environment. Very often we may have some monitoring and alerting requirements for which metrics are not available in OEM and we are having  to […]
Read More
 

Upgrading from Oracle 11gR2 to Oracle 12c using Full Transportable Export and Import

  • Posted by Gavin Soorma
  • On December 11, 2014
  • 1 Comments
The Transportable Tablespace (TTS) feature was introduced in Oracle 8i and the Cross-Platform Transportable Tablespace (XTTS) feature was introduced in Oracle 10g. Since it only involved the copy of the data files of the tablespace at the OS level and the copy (and maybe conversion) of the data files over the network, it was potentially […]
Read More
 1

Minimal downtime database upgrade from Oracle 10g to Oracle 12c

  • Posted by Gavin Soorma
  • On December 8, 2014
  • 0 Comments
This note describes the procedure of migrating as well as upgrading an Oracle 10g Release 2 database to Oracle 12c (12.1.0.2) using a combination of RMAN Incremental backups and the new Oracle 12c command line parallel upgrade utility. This method minimises the outage required for the migration as well as database upgrade and the outage […]
Read More
 3