Re: rac & client connection

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Tue, 20 Feb 2007 11:29:54 +0700
Message-ID: <3edcb66e0702192029m222542a7g60f7993e610cc49a@mail.gmail.com>

ok hemant, thanks. i got the solution.

but when trying TAF, still got problem.

SQL> SELECT instance_name, host_name,
  2 NULL AS failover_type,
  3 NULL AS failover_method,
  4 NULL AS failed_over
  5 FROM v$instance
  6 UNION
  7 SELECT NULL, NULL, failover_type, failover_method, failed_over   8 FROM v$session
  9 WHERE username = 'SYSTEM';

INSTANCE_NAME HOST_NAME FAILOVER_TYPE FAILOVER_M FAI

---------------- ------------------------------------------- -------------
---------- ---
racdb3           rac3pub

NONE          NONE       NO
                                                              SELECT
BASIC      YES

got error when execute this on node3 and later I shutdown abort the racdb3 instance.
select * from sh.sales;

ERROR:
ORA-25401: can not continue fetches
5085 rows selected

#tnsnames entry:

RACDB =
  (DESCRIPTION=
    (ADDRESS_LIST=
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.71)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.81)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.91)(PORT=1521))
    )
    (CONNECT_DATA=
(SERVICE_NAME=racdb)
(FAILOVER_MODE=

        (TYPE=SELECT)
        (METHOD=BASIC)
        (RETRIES=500)
        (DELAY=5)
      )

    )
  )

#as remote listener on all nodes , here i put TAF & load balance entries too LISTENERS_RACDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.71)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.91)(PORT = 1521))
(LOAD_BALANCE = yes)

    )
    (CONNECT_DATA =
(SERVICE_NAME = racdb)
(FAILOVER_MODE=

        (TYPE=SELECT)
        (METHOD=BASIC)
        (RETRIES=500)
        (DELAY=5)
      )

    )
  )

#as local listener on node1 and the rest node is similar...except ip address and name
LISTENER_RACDB1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.71)(PORT = 1521)) regards
ujang

On 2/20/07, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:

>
>
> ORA-12545 would mean that DNS lookups for rac1pub/rac2pub/rac3pub are
> failing.
> Do a command-line  "PING" to see if the Windows client can see those
> hostnames.
> Check if they are in the DNS server.
> If you errors are "random" it could just mean that the Windows client
> isn't finding
> the hostname it is attempting.  You have configured LOAD_BALANCE so the
> client
> would not always atttempt the same name "rac1pub" -- at times it would
> attempt
> "rac2pub" or "rac3pub" -- and one of them is missing from DNS lookups.
>
> If you don't use a DNS server, you'd have to hardcode those entries
> in WINNT\SYSTEM32\DRIVERS\ETC\HOSTS
>
> Hemant
> At 10:21 AM Tuesday, Ujang Jaenudin wrote:
> >ERROR:
> >ORA-12545: Connect failed because target host or object does not exist
> >
> >and this only happen on windows client, while in linux client it
> >doesn't happen.
> >
> >regards
> >ujang
> >
> >
>
>
> Hemant K Chitale
> http://web.singnet.com.sg/~hkchital
> and
> http://hemantoracledba.blogspot.com
>
>

-- 
regards
ujang

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

Received on Mon Feb 19 2007 - 22:29:54 CST