Oracle-L: RE: Steps to convert a RAC to a single instance.

From: <Murali_Pavuloori/Claritas_at_claritas.com>
Date: Thu, 02 Oct 2003 11:39:42 -0800
Message-ID: <F001.005D1D70.20031002113942@fatcity.com>

Raj,

we have a java application that connects to the datawarehouse that is currently setup on RAC but if for some reason one node fails, then we need to recycle the whole application server as the connection pool goes stale....Oracle product development stated that db links can't be failed over.

No use beating the dead fish (or is it the cat..anyway). I have argued and irated some folks here. we have made a decision and management wants to move forward with it.

I really appreciate any help you could provide on converting RAC to a single instance.

Thanks,
Murali.

|---------+----------------------------->


|         |           "Jamadagni,       |

|         |           Rajendra"         |

|         |           <Rajendra.Jamadagn|

|         |           i_at_espn.com>       |

|         |           Sent by:          |

|         |           ml-errors_at_fatcity.|

|         |           com               |

|         |                             |

|         |                             |

|         |           10/02/2003 03:14  |

|         |           PM                |

|         |           Please respond to |

|         |           ORACLE-L          |

|         |                             |

|---------+----------------------------->
  >--------------------------------------------------------------------------------------------------------------|
  |                                                                                                              |
  |       To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                  |
  |       cc:                                                                                                    |
  |       Subject:  RE: Steps to convert a RAC to a single instance.                                             |
  >--------------------------------------------------------------------------------------------------------------|

our (forms) application doesn't fail over, but then we look at RAC for HA .. the logic is like this ... if once instance goes down, then instead of making all 1000 users unhappy, I just make 500 (estimate) of them unhappy, and they can log back in and will work fine because 2nd instance is still servicing. And luckily each instance can handle the load without breaking a sweat.

Get my point?
Raj

-----Original Message-----
[mailto:Murali_Pavuloori/Claritas_at_claritas.com] Sent: Thursday, October 02, 2003 2:35 PM To: Multiple recipients of list ORACLE-L

Hello All:

We had purchased RAC to provide high availability of datawarehouse to our customers. We later discovered that the way our application is designed, and because database links are not failed over in the RAC environment, we have decided to abondon RAC - atleast temporarily.

Could you please list all the steps required to convert RAC to a single instance.

My understanding is that all we need to do is modify the initSID.ora to comment out RAC specific parameters like cluseter_database_instance
cluster_database

SID.instance_name
SID.instance_number
SID.thread
SID.remote_listener

What about the Oracle software? any changes required there?

Appreciate you help and suggestions in this matter.

Thanks,
Murali.

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/Claritas_at_claritas.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). (See attached file: ESPN_Disclaimer.txt)

application/octet-stream attachment: ESPN_Disclaimer.txt

Received on Thu Oct 02 2003 - 14:39:42 CDT