Here’s a quick and easy (not dirty) why to get Oracle Database 19c up and running. Its based on a github repository. Once you run the oracle_19c_install command, you will essentially have the following built out: All required Linux rpms installed and parameters set A 19c Oracle DB Home installed A 19c DB created with … Continue reading
Oracle Autonomous Data Warehouse (ADW) vs AWS RedShift a side-by-side comparison..kinda or sorta Benchmark
Emerging information technology trends in the Cloud have the power to transform organizations. In the data management and analytics space, many key Cloud service offerings have arrived that touch on this theme including Amazon’s Redshift, Snowflake, Google’s Bigquery, and Oracle’s Autonomous Data Warehouse Cloud. The performance along with price, of a data warehouse or decision … Continue reading
AWS CLI setup and test
This is the second part of the CLI series. In the 1st post we covered Oracle OCI CLI install, configure and use. In this post, we’ll do the same for AWS. This is not a compartive Blog post….so no wagering please. Firstly we install PIP. PIP, is a package-management system used to install and manage … Continue reading
Oracle OCI CLI setup and basics
To be honest, this blog is really more for me, cause I cant seem to remeber how to setup OCI CLI each time I need. So effectively this is a cheat-sheet, for me and anyone else who needs it to support Oracle CLI. I will be doing a similiar post for AWS CLI. Its was … Continue reading
DbaaS/ExaCS filesystem filing up with KRB tracing
KRB tracing and background On our Exadata Cloud Service system running 18c GI and DB, we have been running into issues with /u02 filesystem filling up. This was primarily imposed and generated by one component – RMAN. As it turns out we had just enabled ExaCS automated backups via the tooling (bkup_api) . Firstly, krb.c … Continue reading
Part Deux – Diggin’ into ODA ASM Add Disk to DiskGroup operation
This is part 2 of the storage expansion of ODA. If you remember from Part1, we added a whole disk shelf and we walked thru the ASM alert.log to show how the storage gets added to the diskgroup. In this blog post, I’m just going to illustrate the process flow of the disk addition as … Continue reading
Diggin’ into ASM Add Disk to DiskGroup operation
Recently we had to add storage to our X7-HA ODA. This storage add includes a multi-step process, which is generally handled by the ODA OAK automation. We simply added the disks in the slot, and the oakd dameon and workflow takes care of the device management. The key things the oakd automation does is Instantiates … Continue reading
Part Null – Adding Disks to ODA – The Procedure
Adding Solid-State Drives (SSDs) for ODA Data Storage (non-Expansion) There are cases when customers will need to expand the initial storage of the Oracle Database Appliance [ODA]. There are two use cases for such a scenario; one, where storage will be expanded in the existing enclosure 0, second, when attaching an additional enclosure (en1). … Continue reading
Expanding /u01 filesystem on Oracle Database Appliance
vna Recently I had to expand the /u01 on our ODA because we were in the process of consolidating several new Oracle database systems, each with their own Oracle Homes (don’t ask….its what the lines of business wanted). Although lot of this is just a simple Linux LVM stuff…I feel it warrants a blog entry….since … Continue reading
ODA Component Installed Versions vs Available Versions
We recently added new storage to our ODA X7-HA (enclosure0), and noticed that the Component Installed Versions was higher than the Available Version. This seen in theodacli describe-component output, specifically for the disks. So how can the Installed Version be higher than Available and is this bad? No its not, and this can happen for … Continue reading
OCI-PeopleSoft Deployment Guide
This paper illustrates how Oracle and Platinum Partner, Viscosity North America, developed a joint cookbook-approach for provisioning a PeopleSoft application on Oracle Cloud Infrastructure 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 Oracle Cloud Infrastructure. OCI-PeopleSoft … Continue reading
Quick Clip #1 – “How to Create and Launch a Windows AMI” in AWS
The following post simply drops a video on How to Create and Launch a Windows AMI in AWS:
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
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
Exadata Cloud Deployment and Considerations
I recently did a presentation and wipe-board session on Exadata Cloud deployment. As part of that engagment, I did a small write-up on this topic. This is a series of blogs that reflects the presentation: Cloud Exadata Network and Platform Configuration Exadata DB Systems are offered in quarter rack, half rack or full rack configurations, … Continue reading
Oracle Private Cloud Appliance (PCA) – How to get an Inventory
We recently had to move our PCA. But before we did this move we needed to make sure we have everything documented, this included a detailed inventory of the computes nodes, storage attached, managment node configuration. This blog post will illustrate how to do this inventory collection. Note, that you’ll need root access to the … 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
12.2 SQLPlus History command – features and fumbles
Yes, there’s been a lot of hoopla about the HISTORY capability in 12.2 SQlPlus, and I know my friend Gokhan Atil has written about it too. So I’m just gonna share this bit for my team and my feedback on it SQLplus always lacked the history capability like U/Linux shell history. Now in 12.2 SQLPlus … 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
Dallas Oracle User Group Performance & 12.2 New Features Technical Day
Hey DFW Oracle Folks … heads up I’m speaking at the DOUG Performance & Tuning and 12.2 New Features Technical Day! Charles Kim and I be speaking on the following topic: “What to Expect .. When You are Expecting to Virtualize Your Database” – (OVM or VMware) Linux Best Practices for Oracle Database Systems Time: Thursday 20 October 2016 … 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
Uh Oh, I didnt set my Exadata core count correctly , now what?
Changing Capacity On-Demand Core Count in Exadata We recently implemented an Exadata X6 at a one of client sites (yes, we don’t Oracle ACS, we do it ourselves). However, the client failed to tell us that they had licensed only a subset of the cores per compute, after we actually had implmeneted and *migrated* production … 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
Got Containers. Linux Containers Starter Kit
Got Containers? Container Starter Kit
Adding Physical disks to Windows 2012 Server
Since I have a terrible memory for such things, I have to keep notes for myself on How-Tos. A video is at the bottom that illustrates the process (if I can’t read it, at least I’ll see it) 🙂 This blog will walk through the process flow of adding Physical disks to Windows 2012 Server. … Continue reading