Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ASM and 4-way replication?

Re: ASM and 4-way replication?

From: Andreas Piesk <a.piesk_at_gmx.net>
Date: 9 Nov 2006 11:39:04 -0800
Message-ID: <1163101144.710985.10020@e3g2000cwe.googlegroups.com>


JEDIDIAH schrieb:
>
> Clients attempt to connect to a TNS name that
> includes multiple instances in a failover configuration
> and get hung up when they first try to connect to an
> instance that's in managed recovery mode.

you're referring to ORA-1033 returned by a physical standby, right? connect-time failover stops when receiving that error. some time ago i set up a demo on 2 VMware instances running Oracle 10gR2 on CentOS4 but with some minor modifications it should work on 9i too. standby was created as physical standby.

on primary:

exec dbms_service.create_service(service_name=>'APP', network_name=>'APP.test');

create or replace trigger dg_trigger
  after db_role_change on database
declare
  db_role v$database.database_role%type; begin
  select database_role into db_role from v$database;   if db_role = 'PRIMARY' then
    dbms_service.start_service('APP');
  else
    dbms_service.stop_service('APP');
  end if;
end;

tnsnames-entry:

APP.TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =

      (ADDRESS =
        (PROTOCOL = TCP)
        (HOST = dg1)
        (PORT = 1521)
      )
      (ADDRESS =
        (PROTOCOL = TCP)
        (HOST = dg2)
        (PORT = 1521)
      )

    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = APP.test)

    )
  )

a switchover from dg1 (DEMO1) to dg2 (DEMO2) logged the following:

19:55:30
instance: DEMO1
19:55:45
ORA-12514: TNS:listener does not currently know of service requested in connect
19:58:32
instance: DEMO2

seems to work but maybe i missed something.

regards,
-ap Received on Thu Nov 09 2006 - 13:39:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US