Subscribe to Posts by Email

Subscriber Count

    703

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Managing Grid Infrastructure 12c : Creating and Testing TAF Services

Hello,

In this post we will create TAF (Transparent Application Failover) Services as such pre-11gr2 method that is available and preferred instances way.

Environment:-

1. 4 Node RAC, rac01,rac02,rac03,rac04 running orcl database and its instances.

2. A service server_taf is created, for which orcl1 is available instance and orcl2 is the preferred instance.

TAF […]

Managing Grid Infrastructure 12c : Adding a New Node in 12c RAC

In Previous post here and here we have seen deleting and adding back the deleted node to Cluster.

In this post we will see how to add a new node in the cluster

Environment, Assuming you have a new server with OS (OEL) installed and,

Phase 1. You have to install or clone the GRID […]

Managing Grid Infrastructure 12c : Adding a deleted Node

Hello

This is the continuation of previous post from the good work by Deepak.

In last post we deleted a rac04 node and here we will see how to add back the same to cluster.

 

1. Attach the home in rac04 (as you have detached home), (optional)

If you have detached the home […]

Managing Grid Infrastructure 12c : Deletion of Node

Hello Readers,

I will be running through a series of Grid Infrastructure tasks like deletion of node, addition of node, serverpools and taf in 12c.

I would like to Thanks & appreciation Mr. Deepak Kumar from Bangalore India, for his nice work in sending this screenshots.

Without his time and effort this would not be […]

Duplicate Standby : Issues & Issues all the way

Well doing,

All the DBA’s using the duplicate database to build a standby database and its proved most of the times it works. But it happens sometimes that it creates a series of issues.

Thanks to our good old DBA Basavaraju (a very long time DBA) for pointing out this series of issues and […]

difference between roothas.pl and rootcrs.pl

Hello,

I have got a question during my session with my colleagues, the difference between roothas.pl and rootcrs.pl

Both resides in $GRID_HOME/oui/bin

roothas.pl will be useful or used when you run the grid infrastructure in standalone mode (single node Cluster)

rootcrs.pl will be useful or used when you run the grid infrastructure in normal mode […]

12c Release 1 – addnode.sh is missing?

Hello,

While doing practice have been encountered this that addnode.sh is no more located in $GI_HOME/oui/bin, instead it is avaliable in separate folder at $GI_HOME/addnode/addnode.sh.

Crazy, I should also request deletenode.sh :(, where I have stumbled upon one more thing

Where in the rootcrs.pl or the roothas.pl does not contain delete option instead it contains […]

12c Database : New release is out 12.1.0.2 – some new features

For 12c, the new full release has been released i.e 12.1.0.2

The relevant note is 12.1.0.2.0 Patchset Location For “12.1 Grid Infrastructure (CRS, ASM & ACFS)” And “12.1 RDBMS (Database)”. (Doc ID 1910494.1) And the relevant pathch is Patchset 17694377.

The same can be downloaded from OTN site here

There are some important […]

OEL 6.5 Kernel Not supporting to ACFS/ADVM

We have been running into issues in a training , that OEL 6.5 Kernel not shipped with ADVM/ACFS and deliberatly I have to get back to 6.3 or lesser kernel for 12c.

acfsload start -s gives the following error

acfs-9459: advm/acfs is not supported on this os version

Once I have installed the kernel 6.3 […]

CRS Startup : Oracle ORA-21561 : OID generation failed

After long time, I have been writing back now. I will running through a series of posts from now on Grid infrastructure issues.

The first one is Oracle ORA-21561 : OID generation failed

While starting crs / Adding the node the crs alert log will show the error Oracle ORA-21561 : OID generation failed

This […]