Re: 11Gr2 SCAN Listener

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sun, 17 Jan 2010 16:19:14 -0600
Message-ID: <ad3aa4c91001171419w4460e4aekbb91be0c061f2e39_at_mail.gmail.com>

Well, that is most likely the problem. I will do some work so the client can resolve the scan name.

On Sun, Jan 17, 2010 at 4:10 PM, Ghassan Salem <salem.ghassan_at_gmail.com>wrote:

> Andrew,
> what do you have in your local_listener as specified in the instances
> spfile? does your client system (where you're trying to connect) have the
> hostname specified in the listener in it's hosts file (or can ping it, by
> name)?
> In general, the client must be able to ping the each node's vip, by name
> for scan to work, in fact, scan reroutes the connection to one of the vips,
> so they must be reachable from the clients.
>
> rgds
>
> 2010/1/17 Andrew Kerber <andrew.kerber_at_gmail.com>
>
> I get connected failed because target host or object does not exist. Below
>> are the tnsnames entries. Krb1 works, connects to public ip, krb2 does not,
>> it connects to a scan ip. Tnsping works on both krb1 and krb2 .:
>>
>> KRB1 =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.1.140)(PORT = 1521))
>> (LOAD_BALANCE = yes)
>> (CONNECT_DATA =
>> (SERVER = DEDICATED)
>> (SERVICE_NAME = krbllgr2)
>> (INSTANCE_NAME = krbllgr21)
>> )
>> )
>>
>> KRB2 =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.1.148)(PORT = 1521))
>> (LOAD_BALANCE = yes)
>> (CONNECT_DATA =
>> (SERVER = DEDICATED)
>> (SERVICE_NAME = krbllgr2)
>> (INSTANCE_NAME = krbllgr21)
>> )
>> )
>>
>>
>> On Sun, Jan 17, 2010 at 10:27 AM, Ghassan Salem <salem.ghassan_at_gmail.com>wrote:
>>
>>> Yes you should be able to do so,
>>> do you get any error message? is the listener on that ip up and sevicing
>>> your dbs?
>>>
>>> rgds
>>>
>>>
>>> On Sun, Jan 17, 2010 at 4:36 PM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:
>>>
>>>> Well, after much work I finally figured out how to install 11GR2
>>>> clustered with a SCAN listener. I had the pleasure of figuring out how to
>>>> set up my own DNS on the way, which was interesting. Anyway, I managed to
>>>> successfull RAC install in VMware using openfiler for the shared storage,
>>>> and another vm for the DNS. However, when I try to attach to the database
>>>> with the 10g client, I can only connect using the Virtual or Public IP's.
>>>> The scan IP's dont work (I didnt even try to us the SCAN name, in my case
>>>> oel64n-scan). Shouldnt I be able to connect to the SCAN IP's. or am I
>>>> missing something basic here?
>>>>
>>>> --
>>>> Andrew W. Kerber
>>>>
>>>> 'If at first you dont succeed, dont take up skydiving.'
>>>>
>>>
>>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jan 17 2010 - 16:19:14 CST