Re: ASM and 4-way replication?

On 2006-11-09, Andreas Piesk <a.piesk_at_gmx.net> wrote:
> 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.

        Looks pretty nifty.

        I'd still characterize it as a "hack and workaround" though.

>
> 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
>

-- 
     If you think that an 80G disk can hold HUNDRENDS of           |||
hours of DV video then you obviously haven't used iMovie either.  / | \

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com