Re: More Data Guard Issues

We use DG and TDE for pretty much every production environment and I have not run into this.

Is the oracle_home / tns_admin the same on both primary and standby?

Is the encryption wallet location explicitly defined in sqlnet.ora on both?

Oracle GBU Cloud Services
Stephan Uzzell | Sr. Database Engineer
Oracle GBU Cloud Services | Cloud Database Operations Mobile: +1 410.227.6732
Swarthmore, PA | US
On 3/6/19 2:10 PM, Scott Canaan wrote:
>
> TNS_ADMIN is defined the way we want it:
>
> echo $TNS_ADMIN
>
> /var/opt/oracle
>
> cd /var/opt/oracle
>
> oracle_at_clawstgea2:CLAWSTGA>ls
>
> listener.bak listener.ora  sqlnet.ora    tnsnames.ora_bak
>
> listener.bak2 oratab        tnsnames.ora
>
> oracle_at_clawstgea2:CLAWSTGA>pwd
>
> /oracle/app/product
>
> oracle_at_clawstgea2:CLAWSTGA>ls
>
> 12.1.0.2 agent12c  agent13c
>
> find . -name sqlnet.ora -print
>
> ./12.1.0.2/network/admin/samples/sqlnet.ora
>
> oracle_at_clawstgea2:CLAWSTGA>
>
> There is only one Oracle home on the server.
>
> *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 <mailto: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:*Andrew Kerber [mailto:andrew.kerber_at_gmail.com]
> *Sent:* Wednesday, March 06, 2019 2:06 PM
> *To:* Scott Canaan
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: More Data Guard Issues
>
> Did you verify you dont have TNS_ADMIN defined?  And no other Oracle
> homes on the system?
>
> On Wed, Mar 6, 2019 at 12:53 PM Scott Canaan <srcdco_at_rit.edu
> <mailto:srcdco_at_rit.edu>> wrote:
>
> The wallet is in that location and only in that location.  The
> only other sqlnet.ora file is in $ORACLE_HOME/network/admin/samples.
>
> *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 <mailto: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:*Andrew Kerber [mailto:andrew.kerber_at_gmail.com
> <mailto:andrew.kerber_at_gmail.com>]
> *Sent:* Wednesday, March 06, 2019 1:38 PM
> *To:* Scott Canaan
> *Cc:* oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
> *Subject:* Re: More Data Guard Issues
>
> So that would probably mean that its not finding the wallet in the
> location defined in sqlnet.ora. Do you have a second sqlnet.ora
> out there that doesnt have the wallet location defined in it? I
> have seen strange issues in behavior with oracle GI (ASM?)
> installed, where sometimes the standby uses the sqlnet.ora in the
> db home, and sometimes it uses the sqlnet.ora in the GI home.  I
> started using softlinks or TNS_ADMIN to resolve that.
>
> On Wed, Mar 6, 2019 at 12:27 PM Scott Canaan <srcdco_at_rit.edu
> <mailto:srcdco_at_rit.edu>> wrote:
>
> We are using data guard in a test environment in Oracle
> 12.1.0.2.  Along with that, we are using tablespace
> encryption.  This is causing some problems.  When we do a
> switchover, the new secondary doesn’t work because it is
> getting the error “ORA-28365: wallet is not open” when data
> guard attempts to apply the logs.  Once that error is
> encountered, the log apply process stops (gives up?).
>
> If you go into the secondary database in SQL*Plus, it says
> that the wallet is open. After a couple of minutes, we can do 
> a data guard reset and it works.  This is not acceptable to
> the customer.  How do we get around this?  Someone must have
> run into this.
>
> Thank you,
>
> *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 <mailto: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.
>
>
>
> --
>
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
>
> --
>
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

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