Skip to main content

RAC and ORA-1102

Hit the following problem:

After a manual install of a database the database and its instances were not registered with the CRS.

Using srvctl I registered the database and its instances in the CRS.

Unfortunately I could not start the database or and instance. Well I could start one instance but none of the other three. Same thing happened when I used another instance (start inst1 but not inst2, inst3 and inst4, then start inst4, but not inst1, inst2, inst3).

Then I tried to start one of the other instances manually. See what happened:

SQL> startup
ORACLE instance started.

Total System Global Area 838860800 bytes
Fixed Size 2074992 bytes
Variable Size 218105488 bytes
Database Buffers 612368384 bytes
Redo Buffers 6311936 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

I found out that the culprit was an nice combination of init parameters.

CLUSTER_DATABASE_INSTANCES=4
CLUSTER_DATABASE=NO

So my explanation was that the database was willing to start one instance, but none of the other three.

So how could this happen?
Well, our partner came with its own setup tool. This is a mix of shell scripts that are governed by a collection of XML files.
As this is their first RAC environment I guess that they usually set CLUSTER_DATABASE to NO while in some other part they count the number of nodes where the instances will run. Hence the logical difference in their init parameters.

As they had pfiles on all nodes the solution was very easy. Correct the CLUSTER_DATABASE=YES, create a spfile and use that.
Labels:

Comments

jeevan said…
It worked out for me.Thanks a lot.
Jeevan
12:30 AM
Post a Comment

Popular posts from this blog

Oracle Fusion Middleware Forum in Valencia

Last week the 22nd Fusion Middleware and PaaS Partner Community Forum took place in Valencia, Spain. For me this was a very valuable experience - again as I have visited a number of #ofmForum before. Let me recap here the highlights of this meeting. After a great Welcome-Reception the evening before, where everybody had the chance to catch up with a large number of old (and soon-to-be new) friends, the conference started with a kind of the state of the union by Jürgen Kress. The community already has more than 8000 people. This - in a fact - is a tremendous achievement. Everybody agrees that this is only possible by the relentless work of Jürgen who puts a big effort into this. It shows that other areas inside the Oracle technology stack do not benefit by equivalent communities. Even other communities, when they exist at all, do not compete in the same league. So a VERY BIG THANK YOU for Jürgen is at its place here. After the opening a keynote from Alistair Hopkins showed ver...
Post a Comment
Read more

Paas Summercamp 2017 in Lisbon

So – another summer camp is over. What was the outcome of this? Was there more to it than meeting some old friends, dive into some slides, get your hands dirty on new versions and finally talk about it over a glass of Portuguese wine or beer? So let’s start at the beginning – where are we right now? In the Process Cloud Service track the global PM Nathan Angstadt kicked of the session by asking how many projects we are on that use PCS and how we get along selling the product. The outcome was somewhat predictable: about one or two participants were on PCS projects, and selling is still a big issue. We discussed the various reasons for that. The main essence was that the PCS is often positioned at previous BPM customers who still have to deal with large BPM implementations and are somewhat afraid of the new PCS-style. BPM and PCS are two different things. They target different customer issues. BPM is still useful when it comes to large scale implementation...
Post a Comment
Read more

USB2 for Logitech wireless keyboard/mouse

I have bought an Acer E17 laptop. Also I redecorated my study room - so I wanted to get rid of all the clutter, plus sharing the desk with my wife and use the big screen I have - which sat idle on my old desk. So I thought to get a docking station. Just a brief check on the underside of the Acer's (I have three now) showed me that they are not in the league of grown-ups when it comes to the point of supplying docking station slots. So I tried to use a wireless keyboard and mouse from Logitech which I bought a year ago. However there was sometime a big lag in the keyboard and also the mouse did not react that well. Looking on the internet I found a number of folks who complained about this but only little help in solving the problem. Finally I stumbled over a posting that stated that USB2 would be a better choice than USB3, as this scans more devices on more frequencies. So I put the receiver in the USB2 port and since then I am a happy computer user again, not wishing to ...
Post a Comment
Read more