Hi,

My application uses OCI to access Oracle database.
Now, I came to know about the Oracle RAC failover kind of
configuration. Is OCI API for accessing an Oracle cluster is same or
different? Is my existing application works well with a cluster (taking
the advantage of failover) or do I need to do any changes in my
application?

Thanks in advance,
Ramakrishna.

On 14 Jun 2006 23:41:29 -0700, "RamaKrishna Narla" <rknarla@gmail.com>
wrote:

>Hi,
>
>My application uses OCI to access Oracle database.
>Now, I came to know about the Oracle RAC failover kind of
>configuration. Is OCI API for accessing an Oracle cluster is same or
>different? Is my existing application works well with a cluster (taking
>the advantage of failover) or do I need to do any changes in my
>application?
>
>Thanks in advance,
>Ramakrishna.


It makes no difference, unless the instance parameters are different.

--
Sybrand Bakker, Senior Oracle DBA

Sybrand Bakker wrote:
>
> It makes no difference, unless the instance parameters are different.
>
> --
> Sybrand Bakker, Senior Oracle DBA

Hi Sybrand,

Thanks for giving reply on this. Can you please elaborate your
response.
Is Instance parameters mean Global Database Name, user name and
password?

Thanks,
Ramakrishna.

On 15 Jun 2006 01:37:28 -0700, "RamaKrishna Narla" <rknarla@gmail.com>
wrote:

>
>Sybrand Bakker wrote:
>>
>> It makes no difference, unless the instance parameters are different.
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
>
>Hi Sybrand,
>
>Thanks for giving reply on this. Can you please elaborate your
>response.
>Is Instance parameters mean Global Database Name, user name and
>password?
>
>Thanks,
>Ramakrishna.


Instance parameter means
db_cache_size --> size of buffer cache
shared_pool_size -> size of shared pool
pga_aggregate_target 
optimizer* parameters
sort_area_size

ie all parameters influncing the CBO.

--
Sybrand Bakker, Senior Oracle DBA