Rac

Leave a comment Posted on Oracle, Oracle Dba, Rac

The Good , the bad and the Gui Listener

Introduction

Sometimes it is almost funny how old habits indeed seldom die.  At the Customers site where I am working there still seems to be a culture in which it is not that common to use Gui solutions offered by Oracle to do day-to-day jobs. In Dutch there is an  expression telling unknown things  makes things disliked. Well this week i came across nice behavior of the NETCA tool in an environment where Grid Infrastructure 11.2.0.3 is running and I must say I really liked it.

My environment is a four Node Cluster on Redhat Linux 5.5, my Grid Infra structure is 11.2.0.3.0.

Continue reading →

1 Comment Posted on Oracle, Oracle Dba, Rac

Rman Recovery of a Rac Database

Introduction:

As part of a QA  process I am restoring a Rac database.  Rman as a back-up recovery that  has been around some time now (I started working with it as from Oracle 8) will be used for it.  Even though I am aware of debates that this could be done much easier via the Gui I am still tempted to use command line ( scripting for it).  This is the general information about the  environment where this will happen today: The 2 Instance Rac Database is on Linux servers on two nodes. Backups are performed to tape directly using Rman. We are using Networker for that. The environment  i am working with is a 11.2.3.0 with ASM. As part of sharing information below are the steps I performed with some add-on comment.

Continue reading →

Leave a comment Posted on Oracle, Oracle Dba, Rac

Oracle Database Wrap-up from Oracle OpenWorld 2012

Oracle Database Wrap-up from Oracle OpenWorld 2012

Maybe  you have missed this on the web  i do like it a lot cause it gives us a nice insight in the direction Oracle is moving  to . Three  brilliant speakers will give you a great insight in the way of the future:

Very exciting information to see and listen too also cause  it will tell you more about Oracle release 12C.

Happy watching and reading,

Mathijs

2 Comments Posted on Oracle, Oracle Dba, Rac

Return of the Acfs , October 2012 PSU Patch (14275572) for GI and RDBMS

Introduction,

This week i have patched a preproduction environment with latest PSU patch at this moment ( October 2012). Next week will do the same on the production machines In it self this action is not a big  issue when applying it to the Grid infra structure and RDBMS, but  ACFS is in use on those boxes. Since I hope this will make an interesting note, I have gathered my steps and want to share them with you.

Continue reading →

Leave a comment Posted on Oracle, Oracle Dba, Rac

First encounters of the ACFS kind

Introduction:

This weeks challenge has become to set up ACFS on two new to be implemented Real Application Clusters. As with any tooling first question will be , what is your goal if you want to start using it. My purpose is to start using ACFS as a shared mountpoint between the servers, nodes in the cluster in order to have each instance do its logging (ADR), audit and listener log  on that mount.

This blog will tell you about my setting it up,  the  issues i came across and the way it is implemented in a working way.

To share the plot of the story:  After implementing I  had the issue that  right after cluster reboot all services where launched automatiocally BUT  the instances would NOT start automatically. In the end i ended up with ACFS being defined as  a shared home for an Oracle RDBMS installation. And it worked/works after cluster reboot  cause all resources are happy and online now.

Continue reading →

Leave a comment Posted on Oracle, Oracle Dba, Rac

Configuring Active- Passive Clustering Oracle Databases in Grid Infrastructure.

Introduction:

For a billing environment I have been asked to change the current Real application solution to a HA solution with an Active – Passive Database in the Cluster ware of Oracle (Grid Infrastructure) (11.2.0.2.0). Even though I have had / seen examples of this working in 11gr1 the fact we use 11Gr2 allowed us to  skip steps needed in the 11gr1 environment  (such as a dedicated virtual Ip address, able to  fail over and a listener that has to come along with that as well). This solution is based on the fact that in this project we have set up scan listener(s) and also that we connect via a Service (taf). Also it should be said that the parameters for the cluster ware have changed again between Oracle 11gr1 and 11gr2. So it was a nice challenge to see, adapt and solve the issues

It is my estimate that a maintenance window of app 1 Hour  per Database will be needed, doing the analyses,  the changes,  the removal and adding it back to the cluster and  do relocate tests.

Ps  i have marked specific  cluster commands in yellow.

Happy Reading.

Continue reading →

Leave a comment Posted on Oracle, Oracle Dba, Rac

Migration to 11gr2 Cluster ware (Moving from 11.1.7 Crs to 11.2.0.3.0 Grid Infra structure)

Introduction:

Always a challenge patching a Real application cluster. My assignment,  goal in this is to bring Oracle Clusterware ( 11.1.0.7.0)  (without any PSU patches installed) to 11.2.0.3.0.  Grid Infrastructure. This will be performed in two steps , in two maintenance windows in order to minimize the change of breaching SLA of maintenance windows.

Happy reading ,

Mathijs

Continue reading →

Leave a comment Posted on Oracle, Oracle Dba, Rac

Upgraders Nightmare Gridinfrastructure (1120.3.0) Install locked out all Connections

Introduction

This week I have had the challenge to finally install the Grid infrastructure Software 11.2.0.3.0 on a 4 Node production Real application cluster on Linux. I had followed all the guidelines and came well prepared because more than a month ago I had done the same on the preproduction cluster.

Continue reading →

Leave a comment Posted on Oracle, Oracle Dba, Rac

A project leaders challenge: Linux Upgrade and Consequences for Grid Infrastructure

Introduction

After building the complete  Infra structure for Oracle (Grid Infra with Asm) and Rdbms in 11.2.0.2.0. version this Database Administrator is now facing a new challenge made by his Project leader. Please investigate the consequences of a  Operating  Upgrade from Red Hat Linux 5 ( 5.6) to (5.7) and change your Oracle environment to adapt to the changed Operating system. As they say often say  in the Netherlands the Customer is King  so this Admin was on his way. And of course set up a plan in which this will be done one step at the time , starting with a Test box. Because even with Kings the Dba should consider a Quote  of one of the Oracle gurus (Arup Nanda :   What’s more important guts or caution?” I would say pragmatism, bordering on caution; not guts.  And i do believe the Guru is right in this matter.

Happy reading,

Mathijs

Continue reading →