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|
| | [EMAIL PROTECTED]> |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | com |
| | |
| | |
| | 10/02/2003 03:14 |
| | PM |
| | Please respond to |
| | ORACLE-L |
| | |
|---------+----------------------------->
>--------------------------------------------------------------------------------------------------------------|
|
|
| To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
|
| 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/[EMAIL PROTECTED]
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/[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). (See
attached file: ESPN_Disclaimer.txt)
ESPN_Disclaimer.txt
Description: Binary data
