Hello Sonia,
you should try add the following information for both server (ITSM764_125,
ITSM764_126) in the transname.ora file
ITSM764_125 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ARS7604)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ITSM764_125)
(SERVER = DEDICATED)
)
and then you have to put individual information for server in ar.conf file
as
Server-Name: <Your_Server_Name>
Oracle-Two-Task: ITSM764_125
for both the machine your are trying to connect as in your case like
(ITSM764_125, ITSM764_126), then restart your server.
Before doing there activity take necessary back up of bothe transname.ora
and ar.conf file.
Regards,
Sanjay
On Wed, May 8, 2013 at 4:55 PM, Patrick Zandi <[email protected]> wrote:
> **
> You should be using the VIP address / racscan address as well, you don't
> normally just use any address so check with you oracle Dba/ network pugs a
> d make sure
>
>
> Sent from my iPhone
>
> On May 8, 2013, at 3:20, Mayuresh Wagh <[email protected]> wrote:
>
> **
> Hi Sonia,
>
> How to do you connect to see both the DB instances? As far as connection
> is concerned from the AR Side, AR will connect to single instance only.
> However since this is load balanced if that particular instance is down,
> then AR will retry the connection & connects to the other instance. This
> will keep your ARS up & running without any issues.
>
> Does that answer your query?
>
>
>
>
> On Wed, May 8, 2013 at 10:05 AM, Jennifer Varkey
> <[email protected]>wrote:
>
>> **
>> Hello All,
>>
>> I have the following entries in the tnsnames.ora
>>
>> ORCL =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = ITSM764_125)(PORT = 1521))
>> (ADDRESS = (PROTOCOL = TCP)(HOST = ITSM764_126)(PORT = 1521))
>> (LOAD_BALANCE = yes)
>> (CONNECT_DATA =
>> (SERVER = DEDICATED)
>> (SERVICE_NAME = orcl)
>> )
>>
>> Now, in the ar.conf the parameter for Oracle-Two-Task is "orcl".
>>
>> When I connect I get to see data from both the DB instances.
>>
>> How do I configure settings in ar.conf so that it connects to just one
>> instance in a load-balanced Oracle environment?
>>
>> Regards,
>> Sonia
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
