Re: Service de-registration after switchover question

If you are doing client-side failover your TNS entry would need to be (I think)

ABCR_USR =
  (DESCRIPTION =
  *(FAILOVER=ON)*
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = abcr-prim-scan)(PORT = 1521)) <<< This is new standby

      (ADDRESS = (PROTOCOL = TCP)(HOST = abcr-stby-scan)(PORT = 1521)) <<< This is new primary

    )
    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = ABCR_USR)

> Additional info as requested, all from the first node of the new standby
> RAC server.
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> -------------------------------------------
> db_unique_name string ABCR1
> service_names string
> ABCR_PERL,ABCR_TSAM,ABCR_USR,ABCR_WEB,ABCR1
>
> The HOST names in the following ADDRESS_LIST are DNS cnames that alias the
> scan names on each of the platforms.
>
> ABCR_USR =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = abcr-prim-scan)(PORT = 1521))
> <<< This is new standby
> (ADDRESS = (PROTOCOL = TCP)(HOST = abcr-stby-scan)(PORT = 1521))
> <<< This is new primary
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = ABCR_USR)
> )
> )
>
> Listener entries for the other ABCR_* services are identical to the
> ABCR_USR entry and have been omitted.
>
> LSNRCTL> services
> Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
> Services Summary...
> Service "ABCR1" has 1 instance(s).
> Instance "ABCR11", status READY, has 1 handler(s) for this service...
> Handler(s):
> "DEDICATED" established:1504 refused:0 state:ready
> LOCAL SERVER
> Service "ABCR1_DGB" has 1 instance(s).
> Instance "ABCR11", status READY, has 1 handler(s) for this service...
> Handler(s):
> "DEDICATED" established:1504 refused:0 state:ready
> LOCAL SERVER
> Service "ABCR1_DGMGRL" has 1 instance(s).
> Instance "ABCR11", status UNKNOWN, has 1 handler(s) for this service...
> Handler(s):
> "DEDICATED" established:32 refused:1
> LOCAL SERVER
> Service "ABCR_USR" has 1 instance(s).
> Instance "ABCR11", status READY, has 1 handler(s) for this service...
> Handler(s):
> "DEDICATED" established:1504 refused:0 state:ready
> LOCAL SERVER
> The command completed successfully
>
> On 5/16/2018 12:19 AM, Oleksandr Denysenko wrote:
>
> Hello.
>
> please, show from new standby:
>
> - show parameter db_unique_name
> - show parameter service_name
> - lsnrctl services
> - full desctiption of used TNS connection string
>
> Best Regards,
>
> Oleksandr Denysenko
>
> 16.05.2018 8:19, Doug Kushner пишет:
>
> Hi all,
>
> Please be kind as this is my first posting to this list.
>
> We have two RAC platforms with 12.2.0.1 GI and 11.2.0.4 RDBMS replicating
> with Data Guard. Switchover testing was successful using the broker with
> the roles switching successfully. Services have been configured with the
> primary role on both platforms and as expected, after switchover the
> services are stopped on the new standby and started on the new primary.
> The applications are not TAF/FAN aware, so these tests assume for the time
> being that we are shutting down the apps (external connections) and
> restarting them after the switchover.
>
> Now for the question... We expected as part of this switchover, that the
> services which were stopped would automatically be de-registered from the
> listener on the new standby side. However, they are still registered, and
> we are wondering if it is our expectations or our configuration that is at
> fault.
>
> With the services still registered on the standby side, sqlplus connection
> attempts to the service result in an ORA-01033 error, since the standby
> address is the first of the two addresses in the TNS alias.
>
> Have not been able to find any info regarding deregistration of services
> in the listener after a switchover, so thought I would ask the experts.
>
> Thanks,
> Doug
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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