Re: Service de-registration after switchover question

From: Oleksandr Denysenko <odenysenko_at_gmail.com>
Date: Wed, 16 May 2018 10:19:21 +0300
Message-ID: <b7dbcfbe-6a9f-1c85-141b-1afa55d5aa2e_at_gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 16 2018 - 09:19:21 CEST

Original text of this message