Practice makes perfect, but it does not have to be difficult. Please don’t short yourself by not trying to understand what is going on.
This is my third RAC install and I got tired of doing it the hard manual way; hence, decided to script what I can.
ASM will (more...)
Instant Client Package – Basic Lite
Instant Client Package – SQL*Plus
Modify hosts file
# Copyright (c) 1993-2009 Microsoft Corp.
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
# This file contains the mappings of IP (more...)
[oracle@rac01 ~]$ tail /etc/oratab
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
CRS and Cluster, what’s the difference and which one should I use for start and stop?
CRS is Cluster Ready Service and used to manage HAS (High Availability Services)
Cluster is where the application runs on.
Stop CRS is local to the node and will shutdown local HAS – crsctl (more...)
Just completed RAC training and wanted to put into practice.
SCAN IPs MUST NOT be in the /etc/hosts file because it will result in only 1 SCAN IP for the entire cluster.
I started looking for simple DNS server to be used with RAC and came across dnsmasq.
I’ve worked on 24×7 systems for more than a decade, and I have a real dislike of downtime. For one, it can be a real pain to agree any downtime with the business, and while RAC can and does help when you do work in a rolling fashion, there is still risk.
The promise of online patching has been a long one, and it is only recently that I dipped my toe in the water with them. Unfortunately, they are not a panacea, and in this blog posting I’m going to share some of the downsides.
Of course not all (more...)
Or what happens when you don’t have node affinity.
Here’s an old, short post that was lying around unpublished.
SQL executed on the 14th on node 2, on 15th on node 1.
||Cluster Wait Time
Timings in seconds.
32625 seconds is just over 9 hours, of which 32175 is cluster wait time.
Database services and application datasource config have now been reconfigured to the extent that there is node affinity and the data required for the workload on node 1 is completely segregated (more...)
[I originally posted this over at the Pythian blog. If you're not following it, you should! Way more content, by far smarter people than lil ol' me.]
After reviewing my blog post about running EBS OVM templates in VirtualBox, two of my teammates suggested that I work on something with potentially broader appeal. Their basic message was, "This is really cool for us EBS nerds, but what about the Core DBAs?"
So how does "11gR2 RAC in an hour" sound? In this post, I'll demonstrate how to deploy the pre-built Oracle VM templates to create a two-node (more...)
Hi Guyzz, Though there is a lot of buzz on Oracle engineered systems, RAC deployments, 12c technical enablements but still certain basics and walkthrough demos appear to be quite handy and helpful for upcoming professionals in the area. In last few times, I was trying to refresh the demonstration of two node RAC database installation on … Continue reading
This is just a post ot point out that ODA Patch 2.4 is out. ODA Patch 2.4 requires 2.2 or above to install.
A couple of Highlights of this release seem to be
- Enhanced odachk 2.16
- A trace file analyzer
- The ability to now use normal (more...)
Recently I was given three virtual machines running Oracle Enterprise Linux 5 and Oracle 11gR2 RAC on Oracle VM 2.2.1, copied straight from /OVS/running_pool/. I had to get these machines up and running at my lab environment, but I found hard to setup the network. I’ve spent half day in debugging without success, but finally found a workaround, which I’ll explain here.
Just a little technical notes – Oracle VM (xen) has three main setup configurations within /etc/xen/xend-config.sxp:
Bridge Networking – this configuration is configured by default and it’s simplest to configure. Using this type of networking (more...)
As you may have guessed, applying patches on the Oracle Database Appliance can be a little bit different from your standard Oracle environment. Oracle releases a software version that covers all aspects of the ODA - firmware, operating system, and Oracle software stack (grid infrastructure, rdbms). Versions are numbered like this (image courtesy MOS note #1397680.1:
The ODA was initially released with version 18.104.22.168.0, and has seen several releases over the last year:
||CPU bugfix, 22.214.171.124.5 GI PSU5
Oracle Database Appliance Patch 2.3.0 was just released to the public it seems.
A couple of things 2.3 is not a cumulative patch if you are running 2.1 you will need to apply the 2.2.0 patch before proceeding to 2.3.0 .
if you (more...)
An investigation of a few details of the implementation of listeners in 11gR2, including the configuration of listener.ora in RAC and the role of the cluster process 'oraagent'.
11gR2 comes with several important changes and improvements to the clusterware in general and in particular the way listeners are managed. While the listener process is still the 'good old' process tnslsnr (Linux and Unix), it is now started from the grid home (as opposed to database oracle home). Moreover listeners are divided in two classes: node listeners and scan listeners, although they use the same binary for (more...)
Just Last Night i received the results of my Collaborate 12 or #C12LV presentation. This was an interesting time for me since i had not presentation at a public forum before Collaborate. I submitted my abstract in hope to share some of the things i learned and work on in (more...)
When instance fails in Oracle RAC, the services that were using this instance as a preferred instance are automatically relocated to instances marked as available for this service. But after the failed instance recovers and starts up again, the relocated services are not moved back and need manual srvctl relocate service command from administrator to move them back.
Here is a little Bash script to automate this process. Oracle Clusterware (Grid Infrastructure) can execute user callout scripts on FAN events, like INSTANCE up/down. Place this script under $GRID_HOME/racg/usrco/ and set the execute bits on the file. Then clusterware will execute (more...)
The First Oracle Database Appliance Significant version patch is now available ODA Patch 2.2.0 is a very significant patch since it upgrade the OS from 5.5 to UEK 5.8 and also upgrade the database from 126.96.36.199 to 188.8.131.52.2
As Promised Embedded below is my presentation and paper that i presented at this years Collaborate Conference. Looking for feedback from the community
Tuning has always being good fun and something like a challenge for me.
From time to time we are being asked to find out why something did run slow while you are sleeping; answering this question is, in most cases, a challenge.
My batch did run slow last night, can you let us know why? Or why did this query run slow? Are questions we, as DBAs, have to answer from time to time.
Oracle has provided us with many tools to dig out information about past operations. We have EM, AWR, ASH, dba_hist_* tables, scripts (more...)
I have extended the Undo usage scripts to include two additional indicators:
1) undo change vector size statistics
2) Used undo records/blocks
and support for RAC infrastructure, so you can spot the hungriest UNDO eaters for any given instance.
Then the script for Oracle 11g is as follows:
set pagesize 400
set linesize 140
col name for a25
col program for a50
col username for a12
col osuser for a12
SELECT a.inst_id, a.sid, c.username, c.osuser, c.program, b.name,
a.value, d.used_urec, d.used_ublk
FROM gv$sesstat a, v$statname (more...)