Could you give a bit more detail about why your application is not suitable for RAC? It is disappointing about the database connections not failing over. I can seems to remember Parallel Server had transparent session failover that I (and an Oracle consultant) could never get working either.
Cheers, Craig.
At 09:04 AM 3/10/2003 -0800, you wrote:
I guess this means it is breakable ........
-----Original Message----- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:35 AM 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/[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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Johnson INET: [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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [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).
