-
Deleting instance from RAC cluster
Hi all,
DB:10.2.0.1 2 node RAC using ASM 64BIT
O/S: RHEL 4 64BIT
I have i have succefully deleted an instance from a 2 node RAC cluster by using dbca. However when I checked crs_stat -t i saw that some of the applications for the remaining node had changed state from ONLINE to UNKNOWN. Now I havent tried a crs_stop/start as Oracle said not to until they check the logs etc but I wanted everyones opinion on how to get the states back to online. Below is the output of crs_stat -t (mgdb2 is the live host and bof212 is only live instance)
Code:
Name Type Target State Host
------------------------------------------------------------
ora....A2.inst application OFFLINE OFFLINE
ora.DBMGA.db application OFFLINE OFFLINE
ora....12.inst application ONLINE ONLINE mgdb2
ora.bof2.db application ONLINE ONLINE mgdb2
ora....11.inst application ONLINE OFFLINE
ora....12.inst application ONLINE ONLINE mgdb2
ora.bof21.db application ONLINE ONLINE mgdb1
ora....SM1.asm application OFFLINE OFFLINE
ora....B1.lsnr application ONLINE UNKNOWN mgdb1
ora.mgdb1.gsd application ONLINE ONLINE mgdb1
ora.mgdb1.ons application ONLINE ONLINE mgdb1
ora.mgdb1.vip application ONLINE ONLINE mgdb1
ora....SM2.asm application ONLINE UNKNOWN mgdb2
ora....B2.lsnr application ONLINE UNKNOWN mgdb2
ora.mgdb2.gsd application ONLINE UNKNOWN mgdb2
ora.mgdb2.ons application ONLINE UNKNOWN mgdb2
ora.mgdb2.vip application ONLINE ONLINE mgdb2
Any advice will be highly appreciated,
Thanks,
Chucks
-
Hi
Did you remove the instance from the clusterware also ?
You need to run rcgons script from the clusterware which you want to keep
something like
$CRS_HOME/bin/racgons remove_config rac2:6100
the port number can be obtained from
$ORA_CRS_HOME/opmn/conf
and also run the rootdelte.sh from the node which you are going to remove as user root.
and again from the first node run olsnode -n and then remove the clusterware from that node
regards
Hrishy
-
Hi Hrishy,
Thanks for that. No i have not got that far yet as I was concerned that the services for the instance/node i want to *keep* are showing a state of UNKNOWN? Once i clear this then I will carry on with removing the node from the clusterware.
Thanks,
Chucks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|