Quick Clip #2 – “How to Create a AWS RDS”

From the AWS site: Amazon RDS is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, which allows you to focus on your applications and business. Amazon RDS gives you access to the … Continue reading »

Posted in AWS.

How to handle ODA dangling job entries from a failed ODA odacli operation

odacli delete db issues On Oracle Database Appliance ODA X7-HA (12.2.1.2), I created a database call TEST database using odacli create-database command, then I ripped out the current “freshly created” datafiles and used RMAN duplicate command to restored the datafiles. It went alright without any issues. However last week, I decided to delete this TEST database … Continue reading »

How to Create a Single Instance database on ODA on a specific

Yes, this operation does deserve a Blog post, only because its so confusing.  As usual, I show the dcs-agent.log Odacli create-database for single instance on a specific node This procedure illustrates the creation of a  single instance database on ODA X7-HA 12.2.1.3 [root@vnaoda1-1 ~]# odacli create-database -n vnasi -cl oltp -dh 75a428db-d173-4ad8-bae3-021a45eeeebf -s odb1 -r … Continue reading »

ODA Patching/Upgrade Triage

This blog will define the appropriate logs, files and command output to collect when triaging ODA related patching issues Recently we attempted to upgrade from 12.2.1.2 to 12.2.1.3 on ODA X7.  We did the usual as part of the upgrade process. unzip p27648057_122130_Linux-x86-64_1of3.zip ls -l  oda-sm-12.2.1.3.0-180504-server* /opt/oracle/dcs/bin/odacli update-repository -f oda-sm-12.2.1.3.0-180504-server1of3.zip, p27648057_122130_Linux-x86-64_2of3.zip, p27648057_122130_Linux-x86-64_3of3.zip /opt/oracle/dcs/bin/odacli update-dcsagent -v 12.2.1.3.0 … Continue reading »

Hybrid DNS Configuration

The following is definition/illustration of on-premise->OCI (Hybrid) DNS configuration. Oracle Cloud Infrastructure (OCI) customers can configure DNS names for their instances in the Virtual Cloud Network (VCN) as described in DNS in Your Virtual Cloud Network. The DNS names are resolvable only within the VCN using the VCN DNS resolver available at 169.254.169.254. This IP address … Continue reading »

Exadata Cloud – Database Deployment

This is Part 3 of the Post Provisioning of Exadata Cloud Here we will create our first 12.2 database using dbaasapi utility Once the Exadata tooling has been updated, you can leverage the dbaasapi command to create or delete Exadata Oracle databases.  When creating new databases you should only use the dbaasapi to this purpose. … Continue reading »

Exadata Cloud – Post Provisioning Exadata Configuration – Part 2

This is Part 2 of the Post Provisioning of Exadata Cloud Here we will update the Tooling software necessary to support Exadata Patching. Exadata Tooling Update [root@phxdbm-o3eja1 exadbcpatch]# /var/opt/oracle/exapatch/exadbcpatchsm – list_tools INFO: non async case INFO: cmd is: /var/opt/oracle/exapatch/exadbcpatch -list_tools Starting EXADBCPATCH Logfile is /var/opt/oracle/log/exadbcpatch/exadbcpatch_2018-02- 28_22:37:23.log Config file is /var/opt/oracle/exapatch/exadbcpatch.cfg INFO: oss_container_url is not given, … Continue reading »

Exadata Cloud – Post Provisioning Exadata Configuration – Part 1

Post Provisioning Exadata Configuration – Part1 After an Exadata is provisioned, ther are several post provisioning steps that need to be executed in order to allow system automation such as patching, backups, and infrastructure updates. This document will describe these steps. All the traffic in an Exadata DB System is, by default, routed through the … Continue reading »

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/12.2.0.1/grid:N       # 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 12.2.0.1 July RU ???

Here’s the steps that I went thru to apply the Grid Infrastructure Jul2017 Release Update 12.2.0.1.170718, Patch 26133434  Configuration:  2 Node RAC cluster on Kaminario K2 AFA The Grid Infrastructure Jul2017 Release Update (RU) 12.2.0.1.170718 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 »