 | | | FYI: Turning off RAC on Windows - 10gR2 | FYI: Turning off RAC on Windows - 10gR2 2007-12-01 - By Vasu Balla
Back
Hello All,
This is just FYI post, As i found out that the solution to my problem was
not
documented any where. I tried both metalink and google.
we were trying to clone our Windows - Oracle 11i Ebusiness Suite on 10gR2
Rac to a
single node instance (Non-Rac). While trying to bring up the instance, it
failed with
ORA-29702 (See http://ORA-29702.ora-code.com): error occurred in Cluster Group Service operation
I quickly figured out thats its looking for CRS and we dont have one on this
box as its
supposed to be a single node non-RAC instance. we raised a SR on metalink
and
they came up with following solution
- Shutdown the instance which is cloned to non RAC.
- Shutdown all the listeners.
- Relink Oracle executable with rac_off option.
$ make -f ins_rdbms.mk rac_off
$ make -f ins_rdbms.mk ioracle
- Remove all the parameters from init.ora which points to second instance
and it is
on other node.
- Remove cluster_database parameter
- Remove undo_tablespace parameter which points to second instance
Sounds familiar right. Its the procedure to turning of RAC on Unix platforms
not on windows.
I updated the SR to clarify the procedure for windows, still there is no
response there.
After diving in with Sysinternal utilities (now its Microsoft) , finally
found out the solution
to my problem
just rename following file in %ORACLE_HOME%/bin directory
orarac10.dll to orarac10.dll.bak
and it disabled RAC on windows. Actually we almost started installing a
fresh 10gr2 oracle
home, but found the fix just before that.
As i don't maintain a blog, i guess this post here gets indexed by google
and helps people
trying to do this activity in future
Thanks
Vasu Balla
<div>Hello All, </div>
<div></div>
<div>This is just FYI post, As i found out that the solution to my problem was
not</div>
<div> documented any where. I tried both metalink and google. </div>
<div> </div>
<div></div>
<div>we were trying to clone our Windows - Oracle 11i Ebusiness Suite on 10gR2
Rac to a </div>
<div>single node instance (Non-Rac). While trying to bring up the instance, it
failed with </div>
<div></div>
<div>ORA-29702 (See http://ORA-29702.ora-code.com): error occurred in Cluster Group Service operation </div>
<div></div>
<div> </div>
<div>I quickly figured out thats its looking for CRS and we dont have one on
this box as its </div>
<div>supposed to be a single node non-RAC instance. we raised a SR on metalink
and </div>
<div>they came up with following solution </div>
<div></div>
<blockquote dir="ltr" style="MARGIN-RIGHT: 0px">
<div> </div>
<div><font face="courier new,monospace">- Shutdown the instance which is cloned
to non RAC. </font></div>
<div><font face="courier new,monospace">- Shutdown all the listeners. </font><
/div>
<div><font face="courier new,monospace">- Relink Oracle executable with rac_off
option. </font></div>
<div><font face="courier new,monospace">$ make -f ins_rdbms.mk rac_off </font><
/div>
<div><font face="courier new,monospace">$ make -f ins_rdbms.mk ioracle </font><
/div>
<div><font face="courier new,monospace"></font></div>
<div><font face="courier new,monospace">- Remove all the parameters from init
.ora which points to second instance and it is </font></div>
<div><font face="courier new,monospace">on other node. </font></div>
<div><font face="courier new,monospace">- Remove cluster_database parameter <
/font></div>
<div><font face="courier new,monospace">- Remove undo_tablespace parameter
which points to second instance</font> </div>
<div> </div></blockquote>
<div dir="ltr">Sounds familiar right. Its the procedure to turning of RAC on
Unix platforms not on windows.</div>
<div dir="ltr">I updated the SR to clarify the procedure for windows, still
there is no response there.</div>
<div dir="ltr"> </div>
<div dir="ltr">After diving in with Sysinternal utilities (now its Microsoft) ,
finally found out the solution</div>
<div dir="ltr">to my problem</div>
<div dir="ltr"> </div>
<div dir="ltr">just rename following file in %ORACLE_HOME%/bin directory</div>
<div dir="ltr"> </div>
<div dir="ltr">orarac10.dll to orarac10.dll.bak</div>
<div dir="ltr"> </div>
<div dir="ltr">and it disabled RAC on windows. Actually we almost started
installing a fresh 10gr2 oracle </div>
<div dir="ltr">home, but found the fix just before that.</div>
<div dir="ltr"> </div>
<div dir="ltr">As i don't maintain a blog, i guess this post here gets
indexed by google and helps people</div>
<div dir="ltr">trying to do this activity in future</div>
<div dir="ltr"> </div>
<div dir="ltr">Thanks</div>
<div dir="ltr">Vasu Balla</div>
<div dir="ltr"> </div>
<div dir="ltr"> </div>
<div></div>
<div></div>
|
|
|