Site icon Database Tutorials

Changing Parameters From SQLPLUS While Broker Is Enabled

In today’s article, I will teach you to Changing Parameters From SQLPLUS While Broker Is Enabled.

Changing parameters from SQLPLUS while the broker is ENABLE means that the broker does not work properly / cannot perform monitoring operations.

We are testing.

[Commands run from DGMGRL are all run from Primary-1 by connecting to DGMGRL]

1. We connect to the broker and question STATUS.

2. We query the tables of the TEST scheme to be tested.

3. We connect to SQLPLUS and stop Redo-Apply in Logical Standby Database.

[Logical-2]—> ALERT LOG

4. We query the configuration from the broker.

5. We create a table under the TEST scheme to see if the change made from SQLPLUS is activated, although the configuration fails in the broker.

6. We start Redo-Apply by connecting from SQLPLUS.

[Logical-2]—>ALERT LOG

7. We check whether the table is created in Logical Standby.

8. We check whether the error is gone by querying the STATUS of the configuration from the broker.

 

Exit mobile version