Tag Archives: linux

Monitoring Oracle Database Performance with Grafana – Part II

Posted on by • Posted in Linux, Oracle, Video • Tagged , , , , , , , , , , , • Leave a comment

This the second part of a blog post on using the Grafana graphing tool to create an Oracle database performance dashboard for monitoring host and database performance in real time.

In the previous blog post I created a process to read key metrics from Oracle and insert them into a PostgreSQL database. This intermediate step was necessary as the free edition of Grafana does not include the connector to read directly from Oracle.

Once the metrics were loaded into a PostgreSQL table, a second process calculated deltas for those Oracle metrics that are cumulative. The results were then read by Grafana to show host performance and also report on the number of connected Swingbench users.

In this blog post I am going to expand on that and add IO metrics to track read and write IOPs and also throughput.

There is a video for this blog

As before, all code is available from my GitHub repository.

If you have not read Part I, you can find it here

Continue reading →

Monitoring Oracle Database Performance with Grafana – Part I

Posted on by • Posted in Linux, Oracle, Video • Tagged , , , , , , , , , , , • 1 Comment

In a previous blog post I explored how we can use Oracle’s rich V$ views to monitor CPU utilization on the host on which our database is running, as well as the IO generated by all nodes of the database.

Numbers are great, but it would be even better to see the loads represented graphically on a dashboard for an immediate read on how the database and the underlying infrastructure is handling the workload.

In this blog post I will use the Grafana visualization package to create a simple performance dashboard for our Oracle database.

There is a video for this blog

All code is available on GitHub

If you are looking for Part II, you can find it here
Continue reading →

Solving INS-06006: Passwordless SSH connectivity during Oracle 19c RAC install

Posted on by • Posted in Linux, Oracle, RAC • Tagged , , , , , , • 1 Comment

I was recently installing Oracle 19c RAC on a pair of servers running OEL8 UEK.

During the install of Grid Infrastructure the installer repeatedly failed the verification check stating that:

“[INS-06006] Passwordless SSH connectivity not set up between the following nodes(s)”

It is worth remembering that Oracle offers a relatively simple method to set up passwordless ssh connections between machines, which I had used prior to trying to install RAC:

In the Grid Infrastructure directory there is a script called sshUserSetup.sh

Continue reading →

Creating a Storage Snapshot of an Oracle database using Dell Powerstore

Posted on by • Posted in ASM, Linux, Oracle, Video, VMware • Tagged , , , , , • Leave a comment

Storage level snapshot are an incredibly fast and space efficient method to create usable clones of an Oracle database. In this post we’ll create a storage-level snapshot of a Oracle database using a Dell Powerstore storage array. Our database spans two ASM diskgroups, and will be mounted to a second server.

Note: There is a video of this post.
Continue reading →

Create ASM diskgroups with Dell Powerstore

Posted on by • Posted in ASM, Linux, Oracle, Video, VMware • Tagged , , , , , , , • 1 Comment

I recently got an opportunity to do some testing with a Dell Powerstore 5000T all-flash storage array, so I thought I would share some of the notes I made during my testing, for the benefit of any DBAs who might be using one to deliver ASM disks to their Oracle databases.

This will be part of a series of posts that focus on the management of Oracle and ASM with Powerstore, so consider this post as a foundational topic. Nothing especially earth shattering, but some solid points nonetheless.

Oh, and there’s a video too

Continue reading →

11gR2 Grid install – clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file

Posted on by • Posted in ASM, Linux, Oracle • Tagged , , , , , • 3 Comments

You are installing 11gR2 11.2.0.1 Grid Infrastructure on Red Hat 6, CentOS 6 or similar Linux operating system, and right at the very end of the process, the root.sh script blows up with a really odd error:

[root@localhost oraInventory]# cd /u01/app/oracle/product/11.2.0/db_1
[root@localhost db_1]# ./root.sh
Running Oracle 11g root.sh script...

Continue reading →

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part IX

Posted on by • Posted in ASM, Linux, Oracle, RAC, VMware • Tagged , , , , , , , , • 27 Comments

Time Required: 60 minutes

Class Materials:

  • Oracle 11gR2 Grid Infrastructure software

Next we are going to install the Oracle Grid Infrastructure software.

The Grid Infrastructure will provide the Cluster software that allows the RAC nodes to communicate, as well as the ASM software to manage the shared disks.

To begin, download the zip file from the Oracle software download website and unzip on Orpheus. Make sure you are logged into Orpheus as the oracle user so that oracle owns the unzipped files.

Continue reading →

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part VIII

Posted on by • Posted in Hacking, Linux, RAC, VMware • Tagged , , , , , , • 20 Comments

Time Required: 60 minutes

Class Materials:

  • 5GB of disk space
  • an ASCII text editor

Next we are going to add some shared disk to our new freshly minted VMs

VMware Workstation makes the allocation of shared disk to VMs very simple. Shared disk has been the biggest obstacle to create Oracle RAC clusters at home, but now VMware gives us a reliable and portable solution that does not require fire-wire hacks, your own NFS server or a SCSI disk array.

Best of all this whole solution can exist on a single laptop, so you can take your RAC on the road.

Continue reading →

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part VII

Posted on by • Posted in Linux, Oracle, RAC, VMware • Tagged , , , , , • 6 Comments

Time Required: 60 minutes

Class Materials:

  • none

Next we are going to give our two new VMs identities.

As discussed in the previous section, I have decided to name my VMs Orpheus and Eurydice. In this section we will give each machine a hostname plus static IP address on the VMnet2 and VMnet3 networks we created earlier.

This will allow our two operatic lovers to communicate both publicly and privately.

Continue reading →

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part VI

Posted on by • Posted in Linux, Oracle, RAC, VMware • Tagged , , , , , • 3 Comments

Time Required: 60 minutes

Class Materials:

  • none

Next we are going to create two networks for our RAC system to talk on.

The Oracle RAC system requires at least two network connections between cluster nodes. One network will be the public IP and the second will be a private IP reserved for inter-cluster traffic.

Continue reading →