Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change location of dg_broker_config_file

YoavFeb 25 2016 — edited Feb 26 2016

Hi,

Version 12c.

I am configuring data gurad broker on 12c.

Primary and Standby are already up and running.

I have started by trying to change the location of dg_broker_config_file1+2 from file system to ASM .

Before starting configuration :

SQL> sho parameter broker

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

connection_brokers                   string      ((TYPE=DEDICATED)(BROKERS=1)),((TYPE=EMON)(BROKERS=1))

dg_broker_config_file1               string      /u01/app/oracle/product/12.1.0/dbhome_1/dbs/dr1ptk.dat

dg_broker_config_file2               string      /u01/app/oracle/product/12.1.0/dbhome_1/dbs/dr2ptk.dat

dg_broker_start                      boolean     FALSE 

use_dedicated_broker                 boolean     FALSE

Then on the primary database i have execute :

(Output from alert log)

Thu Feb 25 13:05:39 2016

ALTER SYSTEM SET dg_broker_config_file1='+data/ptk/broker/dr1ptk.dat' SCOPE=BOTH;

Thu Feb 25 13:08:07 2016

ALTER SYSTEM SET dg_broker_config_file2='+fra/ptk/broker/dr2ptk.dat' SCOPE=BOTH;

Yet , in the ASM file system the file does not exists :

ASMCMD> pwd

+data/PTK/broker

ASMCMD> cd +data/ptk/broker

ASMCMD> ls -l

ASMCMD>

I was supprised to find out that the configuration files : dr1ptk.dat+dr2ptk.dat are NOT exists on the $ORACLE_HOME/dbs as well !

Any suggestion ?

Thanks

Yoav

This post has been answered by Shivananda Rao on Feb 26 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2016
Added on Feb 25 2016
12 comments
3,920 views