Read and monitor Oracle related blogs and news sources, all in one place.
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...)
Download
Instant Client Package – Basic Lite
Instant Client Package – SQL*Plus
http://www.oracle.com/technetwork/topics/winsoft-085727.html
Modify hosts file
C:\Windows\System32\drivers\etc>more hosts # 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. # (more...)
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.
LINUX VERSION
(more...)
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.
| DT | SQL ID | Node | Rows | Execs | Elapsed | Cluster Wait Time |
|---|---|---|---|---|---|---|
| 15-NOV | 7287jpw5vtm8j | 1 | 4129697 | 7591 | 32625 | 32175 |
| 14-NOV | 7287jpw5vtm8j | 2 | 19703872 | 30909 | 78 | 60 |
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...)
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 2.1.0.0.0, and has seen several releases over the last year:
| Patch | Features |
|---|---|
| 2.1.0.3.0 | CPU bugfix, 11.2.0.2.5 GI PSU5 |
| 2.1.0.3.1 | (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...)
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.
The problem:
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.
The solution:
Oracle has provided us with many tools to dig out information about past operations. We have EM, AWR, ASH, dba_hist_* tables, scripts (more...)
 |  | Ver este articulo en Español |
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...)
RSS