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

ASM Flex Disk Groups, Quota Groups and ASM Split Mirror Cloning

  • Posted by Gavin Soorma
  • On June 7, 2019
  • 0 Comments
In earlier releases we could create an ASM Disk Group which could potentially contain the data files of a number of databases. The issue was that we could not perform any storage management at the database level. If the Disk Group redundancy was set to say HIGH (which is 3-way mirroring), then that applied to […]
Read More
 

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

Oracle 18c New Feature Pluggable Database Switchover

  • Posted by Gavin Soorma
  • On November 7, 2018
  • 0 Comments
In earlier releases prior to Oracle 18c, while we could enable Data Guard for a Multitenant Container/Pluggable database environment, we were restricted when it came to performing a Switchover or Failover – it had to be performed at the Container Database (CDB) level. This meant that a database role reversal would affect each and every […]
Read More
 1

Oracle 18c New Feature Read-Only Oracle Homes

  • Posted by Gavin Soorma
  • On November 5, 2018
  • 0 Comments
One of the new features of Oracle Database 18c is that we can now configure an Oracle Home in read-only mode. In a read-only Oracle home, all the configuration files like database init.ora, password files, listener.ora, tnsnames.ora as well as related log files reside outside of the read-only Oracle home. This feature allows us to […]
Read More
 

Oracle 18c RPM Based Software Installation

  • Posted by Gavin Soorma
  • On November 1, 2018
  • 0 Comments
One of the (many) new features in Oracle Database 18c enables us to install a single-instance Oracle Database software (no support for Grid Infrastructure as yet) using an RPM package. So say as part of say provisioning a new Linux server, the system administrator can also provide the Oracle 18c software already pre-installed and ready […]
Read More
 1

Oracle 18c Grid Infrastructure Upgrade

  • Posted by Gavin Soorma
  • On July 30, 2018
  • 1 Comments
Upgrade Oracle 12.1.0.2 Grid Infrastructure to 18c Download the 18c Grid Infrastructure software (18.3) https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html     Prerequisites Apply the patch 21255373 to the 12.1.0.2 Grid Infrastructure software home Edit the /etc/security/limits.conf file and add the lines: oracle soft stack 10240 grid   soft stack 10240   Notes Need to have at least 10 GB of […]
Read More