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<mailto: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<mailto: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<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>> On Behalf
Of Scott Canaan
Sent: Wednesday, June 19, 2019 3:24 PM
To: Andrew Kerber <andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>>
Cc: oracle-l@xxxxxxxxxxxxx<mailto: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<mailto: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<mailto:andrew.kerber@xxxxxxxxx>>
Sent: Wednesday, June 19, 2019 3:04 PM
To: Scott Canaan <srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>>
Cc: oracle-l@xxxxxxxxxxxxx<mailto: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<mailto: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<mailto: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.'
