Re: Data Guard Creating Issue

From: John Thomas <jt2354_at_gmail.com>
Date: Mon, 17 Dec 2018 22:01:07 +0000
Message-ID: <CAOHpfbHjgVkvqytHZSH5QvNsJ+eY6RcONoDywJKsKBY+o7pgHQ_at_mail.gmail.com>



Mladen is right. I think the encryption behaviour changed around 11.2.0.4. Recreating the file with the same passwords is no longer enough, it must be a binary copy across all nodes.

Regards

John Thomas

On Mon, 17 Dec 2018, 17:31 Mladen Gogala <gogala.mladen_at_gmail.com wrote:

> Again, please scp it from the primary. I ran into that many times.
>
> Regards
> On 12/17/18 12:19 PM, Scott Canaan wrote:
>
> The password file was created as part of the DG creation.
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> srcdco_at_rit.edu | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *Mladen Gogala
> *Sent:* Monday, December 17, 2018 12:14 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: Data Guard Creating Issue
>
>
>
> Hi Scott,
>
> Please check whether your password file is the same on both the primary
> and standby. Oracle support claims it's a password issue:
>
> *Data Guard Broker reported ORA-16664 (Doc ID 1390892.1)*
>
> You may to scp the password file from the primary to the standby.
>
>
>
> On 12/17/18 11:11 AM, Scott Canaan wrote:
>
> I am trying to do a data guard creation via Enterprise Manager. It
> restores everything via RMAN correctly, but can’t create the data guard.
>
>
>
> I am getting an ORA-16664 and ORA-16665, but I can’t figure out what is
> causing them.
>
>
>
> This is Oracle 12.1.0.2.
>
>
>
> Unfortunately, I’m under the gun time-wise.
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> srcdco_at_rit.edu | c: (585) 339-8659
>
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>
> --
>
> Mladen Gogala
>
> Database Consultant
>
> Tel: (347) 321-1217
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 17 2018 - 23:01:07 CET

Original text of this message