Yes, I have seen that one before. You can put in a bad value for the broker
files, and Oracle wont say anything until the broker tries to create them.
And even in RAC, they will default to a local file system location despite
the fact that they need to be in shared storage for RAC data guard.
On Wed, Jun 19, 2019 at 2:37 PM Scott Canaan <srcdco@xxxxxxx> wrote:
Ok, I got it. I had to do the “alter system set dg_broker_start = FALSE”
first. Then I could change the parameter and change it back to true. Once
I did that, I could enable the configuration and all is good again.
*Scott Canaan ‘88*
*Sr Database Administrator *Information & Technology Services
Finance & Administration
*Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
*srcdco@xxxxxxx <srcdco@xxxxxxx>* | 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:* Scott Canaan <srcdco@xxxxxxx>
*Sent:* Wednesday, June 19, 2019 3:31 PM
*To:* Scott Canaan <srcdco@xxxxxxx>; Andrew Kerber <
andrew.kerber@xxxxxxxxx>
*Cc:* oracle-l@xxxxxxxxxxxxx
*Subject:* RE: Data Guard Question
I think I found my problem. We don’t want the data guard configuration
files in their default location, so we move them. In changing the
dg_broker_config_file2 setting, I had a typo for the standby.
Unfortunately, it won’t let me fix it. It keeps telling me:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16573: attempt to change or access configuration file for an enabled
broker configuration
When I try to disable the broker configuration, I get:
ORA-16525: The Oracle Data Guard broker is not yet available.
Configuration details cannot be determined by DGMGRL
How do I fix this?
*Scott Canaan ‘88*
*Sr Database Administrator *Information & Technology Services
Finance & Administration
*Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
*srcdco@xxxxxxx <srcdco@xxxxxxx>* | 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> *On
Behalf Of *Scott Canaan
*Sent:* Wednesday, June 19, 2019 3:24 PM
*To:* Andrew Kerber <andrew.kerber@xxxxxxxxx>
*Cc:* oracle-l@xxxxxxxxxxxxx
*Subject:* RE: Data Guard Question
I have not tried to drop and recreate the configuration.
I got the database to be recognized by CC by deleting it from CC and
re-adding it. At least now it knows it’s up. When I go to Availability,
It only displays “Add Standby Database”. If I click on that, then hit
cancel on the next page, it will take me to the Data Guard status page,
which shows it is in error.
The DG log file on the primary node has rows and rows of: Site DGRDTSTB
returned ORA-16733.
I looked that error up and all I can find is to “install logical standby
packages and re-issue the request”. Not exactly helpful.
*Scott Canaan ‘88*
*Sr Database Administrator *Information & Technology Services
Finance & Administration
*Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
*srcdco@xxxxxxx <srcdco@xxxxxxx>* | 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 <andrew.kerber@xxxxxxxxx>
*Sent:* Wednesday, June 19, 2019 3:04 PM
*To:* Scott Canaan <srcdco@xxxxxxx>
*Cc:* oracle-l@xxxxxxxxxxxxx
*Subject:* Re: Data Guard Question
Did you go into dgmgrl and drop and re-create the configuration? What does
the log for the cc agent say? Can you see anything in the alert log for
the primary or standby database that shows anything? Is there anything in
the data guard broker log on either the primary or standby? Does the data
guard configuration work without using the broker?
On Wed, Jun 19, 2019 at 1:50 PM Scott Canaan <srcdco@xxxxxxx> wrote:
I just created a new database and use Cloud Control 13c to create a data
guard database and configuration. All seemed to work until the data guard
job completed and now my primary database is messed up in CC. It is giving
the error:
Metric evaluation error start - Get dynamic property error,Computation of
a critical dynamic property failed. Retries Completed.
And I can’t get the data guard configuration to work in dgmgrl. It says
that it has a stale configuration. I’ve tried everything I can find online
to fix these issues (I believe they are related), with no success.
On the server that houses CC, I tried using:
emctl reload agent dynamicproperties <dbname>:oracle_database
and it just comes back with a message saying the database doesn’t exist.
How can adding a standby database screw this up? I can’t figure out how
to fix it without starting over. This is the sixth attempt at doing this
and each time something goes wrong – I’ve run across two bugs and have the
workarounds for those. It’s getting very frustrating.
The database version is 12.1.0.2 on Linux.
*Scott Canaan ‘88 *
*Sr Database Administrator *Information & Technology Services
Finance & Administration
*Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
*srcdco@xxxxxxx <srcdco@xxxxxxx>* | 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.'
