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-----
From: Murali_Pavuloori/[EMAIL PROTECTED]
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]]
Sent: Thursday, October 02, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Steps to convert a RAC to a single instance.
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/[EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
