Re: Irritating Snapshot Standby issue. (Rant)

I have never had this issue. I've configured a number of DG setups that use snapshot standby and they work just fine with static service names. However, I almost always use a separate listener specifically for the DG services which means the DG services are dynamically registered with the primary listener but only the static services show up in the DG listener. Maybe that's why I haven't run into this issue.

The note doesn't make any sense and it looks to me like the solution only hides the symptom, but doesn't actually fix the problem. I would challenge the note if I were hitting this issue.

Seth Miller

On Wed, Apr 29, 2015 at 1:30 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> Oracle 11.2.0.3 on AIX
>
> Please pardon the rant, but this was really kind of irritating.
>
> I sometimes wonder if at Oracle, the right hand knows what the left hand
> is doing.
>
> I ran into a problem yesterday converting a snapshot standby back to a
> physical standby through dgmgrl. I received the error ORA-16541: database
> is not enabled. Which was really strange, since it had converted to a
> snapshot standby through dgmgrl without any problems.
>
> So I researched the problem on the metalink and found note 1969548.1. It
> said the cause of the error was this:
> DGConnectIdentifier broker configuration property must use a dynamically
> registered service.
>
> So, in order to convert back, we removed the static registration with the
> same service name, and were able to get it converted back to a dataguard
> standby (once we manually started the instance from sqlplus along the way).
>
> Those of you who have set data guard know that you have to use static
> registration in order for the broker to perform switchover operations. Why
> do you suppose Oracle configured this particular operation so that a
> dynamic registration is required when converting back from a snapshot
> standby, when a static registration is required for everything else?
> Obviously someone forgot to do a little QA on this one.
>
> It was really kind of a minor annoyance, but really there was no reason
> for it to happen
>
> Sent from my iPad--
> http://www.freelists.org/webpage/oracle-l
>
>
>

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