Exadata Cloud – Post Provisioning View of the system

Review of Exadata Deployment Once the Exadata provisioning process completes (which takes around 4-5hrs for a ½ rack).  We explore to see what gets deployed: $ cat/etc/oratab OCITEST:/u02/app/oracle/product/12.2.0/dbhome_2:Y +ASM1:/u01/app/       # line added by Agent   [grid@phxdbm-o3eja1 ~]$ olsnodes -n phxdbm-o3eja1 1 phxdbm-o3eja2 2 phxdbm-o3eja3 3 phxdbm-o3eja4 4   [grid@phxdbm-o3eja1 ~]$ cat /var/opt/oracle/creg/OCITEST.ini | grep nodelist … Continue reading »

Are You Ready to apply the July RU ???

Here’s the steps that I went thru to apply the Grid Infrastructure Jul2017 Release Update, Patch 26133434  Configuration:  2 Node RAC cluster on Kaminario K2 AFA The Grid Infrastructure Jul2017 Release Update (RU) includes updates for both the Clusterware home and Database home that can be applied in a rolling fashion. In this blog post … Continue reading »

BMCS-PeopleSoft Deployment Guide

This article illustrates a joint cookbook-approach for provisioning a PeopleSoft application on Bare Metal Cloud Services configuration; including network, compute, database, load balancing service, and storage. The second section of this paper describes the migration of an on- premise PeopleSoft Database to the Bare Metal Cloud. The following link describes this in detail.  Enjoy !! … Continue reading »

ACFS Snapshot – A Walk Through

This blog explores some of the new 12.2 ACFS features.  We will walk through the ACFS snapshot process flow:   [oracle@oracle122 log]$ acfsutil snap info /acfsmounts/acfsdata/ snapshot name:               just_before_load snapshot location:           /acfsmounts/acfsdata/.ACFS/snaps/just_before_load RO snapshot or RW snapshot:  RO parent name:                 /acfsmounts/acfsdata/ snapshot creation time:      Wed Mar 22 20:36:09 2017 storage added to snapshot:   8650752   (   … Continue reading »

Grid Infrastructure and RAC 12.2 New Features – a Recap

The following list illustrates the new 12.2 Oracle RAC and Grid Infrastructure. This is a personal list which “I believe to be the most interesting.” I apologize to the RAC Dev team if I left out any features. Streamlined Grid Infrastructure Installation 12.2 Grid Infrastructure software is available as an image file for download and … Continue reading »

Clonewars – Next Gen Cloning with Oracle 12.2 Multitenancy (Part Deux)… With a Sprinkle of PDB Refresh

  This is Part 2 of the Remote [PDB] Cloning capabilities of Oracle 12.2 Mulitenant. Cloning Example 2:  Remote clone copy from an existing CBD/PDB into a local PDB (PDB->PDB).  In this example “darkside” is  CDB with darthmaul being the source/remote PDB and  yoda (PDB) is local target   SQL> select database_name from v$database; DATABASE_NAME ——————————————————– DARKSIDE … Continue reading »

Clonewars – Next Gen Cloning with Oracle 12.2 Multitenancy (Part Un)

In this blog, we will walk through Oracle 12.2 Remote Cloning of PDB feature. In Oracle 12.1, remote cloning was also available, however, this required placing the productions database (which is usually the source) in read-only mode. This makes the cloning feature very inefficient to leverage. In 12.2, it is now possible to maintain the … Continue reading »

Flex Your Inner ASM – ASM 12.2 New Features

The following article will describe at a high-level the key ASM improvements in Oracle 12.2.  Note, due to number of changes and improvements in ACFS, we cover ACFS is a separate article. Oracle ASM Flex Disk Groups and File Groups In previous releases disk group storage attributes were defined only at the disk group level, … Continue reading »

In-Memory of.. Sorry I mean 12.2 In-Memory New Features

As part our of continuing 12.2 New Feature Series we explore different areas of Oracle 12.2 In this blog we discuss the new In-Memory 12.2 features In-Memory Expressions An In-memory expression, or “hot” expression, enables frequently evaluated query expressions to be materialized in the In-Memory Column Store, for subsequent reuse. By default, the procedure DBMS_INMEMORY_ADMIN.IME_CAPTURE_EXPRESSIONS … Continue reading »

ACFS 12.2 New Features – a Recap

Oracle Automatic Storage Management Cluster File System (ACFS) made it’s debut with Oracle 11.2. Many DBAs are not aware of the vast features that are available with ACFS. With each release and update to Oracle, significant enhancements have been made. With Oracle Database 12c Release 2, new feature/functionality was made to ACFS. Snapshot Enhancements In … Continue reading »

ASR and IP Addresses on PCA/OVCA

How to determine OVCA or PCA Management Node, Compute Node, and ILOM service processor IP addresses The asr command has various switches that give information on the assets; however, the assets are generally list by ILOM address.  So how do you get the asset listing and how do you map it back to the primary … Continue reading »

Data Guard Setup …its a recap

The intent of this section is to illustrate the build of the physical standby (disaster recovery) database from a production database.  For this scenario both databases will reside on the 1 physical server. This section assumes that the Oracle Grid Infrasturcture, either Standalone or Cluster configuration is installed on both the primary host and standby … Continue reading »

iptables save

When I was working with our sysadmin person, he freaked out that when we stop/restarted iptables service, and the iptables were gone.  The iptables rules are lost upon shutdown on iptbles service or after system reboot.   What I usually do is save off my iptables rules into a save file as follows: # iptables-save … Continue reading »

Setting Round-Robin Multipathing Policy in VMware ESXi 6.0

Storage Array Type Plugins (SATP) and Path Selection Plugins (PSP) are part of the VMware APIs for Pluggable Storage Architecture (PSA). The SATP has all the knowledge of the storage array to aggregate I/Os across multiple channels and has the intelligence to send failover commands when a path has failed. The Path Selection Policy can … Continue reading »

What’s with MGTDB anyways

For those who have either upgraded or fresh-installed 12.1 (12c) Grid Infrastructure stack, will notice a new database instance (-MGMTDB) that was provisioned automagically. So what is this MGMTDB and why do I need this overhead. Si let’s recap what the DB is and what it does… Management Database is the central repository to store … Continue reading »

Setting Jumbo Frames – Portrait of a Large MTU size

There cases where we need to ensure that large packet “address-ability” exists. This is needed to verify configuration for non standard packet sizes, i.e, MTU of 9000. For example if we are deploying a NAS or backup server across the network. Setting the MTU can be done by editing the configuration script for the relevant … Continue reading »

Oracle 12c Multitentant – My Top Ten PDB Questions PartI

Q. What are my options for connecting to a Pluggable Database ? A. Connect to root, then SQL> alter session set container = nisha; Database connection using easy connect Ex: CONNECT username/password@host[:port][/service_name][:server][/instance_name] $ sqlplus test1/test123@//localhost/nisha Need to define Database connection using a net service name Example TNSNAMES.ora: ======= LISTENER_CDB1 =   (ADDRESS = (PROTOCOL = … Continue reading »

[Re-] Imaging Exadata with

 [Re-] Imaging Exadata with Introduction This document, based on Doc ID 1991376.1, specifically addresses re-imaging Exadata systems to, using standard (non-OVM) deployment via USB boot.  In this scenario, a new Exadata system was delivered with the image; however, client decided to implement the latest image ( before OEDA was executed. Scenario The … Continue reading »

Installing Oracle Linux 6.6, Prepping Linux OS for Oracle Database 12c Install, and Installing Oracle Database 12c

Installing Oracle Linux 6.6, Prepping Linux OS for Oracle Database 12c Install, and Installing Oracle Database 12c I know it seems simple to install Linux and Oracle Dtaabase. But I felt a need to standardize on how we do it internally at Viscosity. So I provided this little note to our DBA team to build … Continue reading »

Apply 12102 PSU1 (19392646) on a Standalone Cluster

We are about to apply 12102 PSU1 (19392646) on a Standalone Cluster. This patch applies the patch to RDBMS home as part of opatchauto. Here’s the output in case anyone wants to compare: [root@ol64afd OPatch]# ./opatchauto apply -analyze /mnt/hgfs/12cGridSoftware/12102-PSU1/19392646 -ocmrf ocm/bin/ocm.rsp OPatch Automation Tool Copyright (c) 2014, Oracle Corporation. All rights reserved. OPatchauto version : … Continue reading »

blktrace basics

Life of an I/O Once a user issues an I/O request, this I/O enters block layer…then the magic begins… 1. IO request is remapped atop underlying logical/aggregated device device (MD, DM). Depending on alignment, size, …, requests are split into 2 separate I/Os 2. Requests added to the request queue 3. Merged with a previous … Continue reading »