RE: Steps to convert a RAC to a single instance.

Murali,

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/Claritas_at_claritas.com]
>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/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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Tony Johnson
> INET: Tony_Johnson_at_Trimble.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig Munday
  INET: cmunday_at_bigpond.net.au

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).