Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ASM and 4-way replication?
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) )
(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