No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

DataGuard broker configuration with service_name
Next thread: copy oracle software
Prev thread: Best way to upload Excel

Message Score Author Date
Hi, Can someone explain me how to set up the ne...... Lauri Oct 13, 2019, 18:05
Hi Lauri, Why not start with the docs: https:/...... Philip Wisse Oct 13, 2019, 20:13
Hi, Thanks for the answers. The second links d...... Lauri Oct 14, 2019, 08:26
Hi Lauri, I'm sorry, 12C link: https://oracle-b...... Philip Wisse Oct 14, 2019, 10:06
Hi Philip, Thanks for the info. Using service_...... Lauri Oct 15, 2019, 08:23
Lauri, A database is identified by SID but it c...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Oct 15, 2019, 08:43
Hi, Thanks for the answers. I have tested it...... Lauri Oct 18, 2019, 17:09

Follow up by mail Click here


Subject: DataGuard broker configuration with service_name
Author: Lauri, Netherlands
Date: Oct 13, 2019, 18:05, 37 days ago
Os info: Linux x86 64bit
Oracle info: 12cR1 and 12cR2
Message: Hi,

Can someone explain me how to set up the network connectivity listener and TNS names when configuring the DataGuard broker?
I wish to have a specific listener, LISTENER_DG with for instance port 8000, and use service_name instead of sid_name.
I am quite confused by the different configurations I have seen.

Thanks by advance for any tip.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: DataGuard broker configuration with service_name
Author: Philip Wisse, Netherlands
Date: Oct 13, 2019, 20:13, 37 days ago
Message: Hi Lauri,

Why not start with the docs:
https://docs.oracle.com/database/121/DGBKR/

Then some examples:
http://psoug.org/reference/data_guard.html

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-DataGuard broker configuration with service_name77
Author: Lauri, Netherlands
Date: Oct 14, 2019, 08:26, 36 days ago
Message: Hi,

Thanks for the answers.
The second links deals about Oracle11g and I work with Oracle12c.
Furthermore more, the article in the link makes use of the sid_name for the network connectivity.
The example in the link does not deal with the broker.

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-DataGuard broker configuration with service_name77
Author: Philip Wisse, Netherlands
Date: Oct 14, 2019, 10:06, 36 days ago
Message: Hi Lauri,

I'm sorry, 12C link: https://oracle-base.com/articles/12c/data-guard-setup-using-broker-12cr1

At first, I did't think there's a difference between using sid_name and service_name.
But it says: "Notice the use of the SID, rather than the SERVICE_NAME in the entries. This is important as the broker will need to connect to the databases when they are down, so the services will not be present."

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-DataGuard broker configuration with service_name77
Author: Lauri, Netherlands
Date: Oct 15, 2019, 08:23, 35 days ago
Message: Hi Philip,

Thanks for the info.
Using service_name is the tendancy (if I well understood), but until now I have seen only the use of sid_name.
I will get a look to that documentation.

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-DataGuard broker configuration with service_name77
Author: Philip Wisse, Netherlands
Date: Oct 15, 2019, 08:43, 35 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Lauri,

A database is identified by SID but it can have multiple services/instances/aliases.

So, if you want to connect to a database use SID.
If you want to connect to a specific service you have to specify that service.

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1508737000346067364

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-DataGuard broker configuration with service_name
Author: Lauri, Netherlands
Date: Oct 18, 2019, 17:09, 32 days ago
Message: Hi,

Thanks for the answers.

I have tested it on Oracle 12c.
The listener should be configured for both sites (to allow a role transition) with a SID list address like:

SID_LIST_LISTENER_<name> =
(SID_LIST =
(SID_DESC =
(SID_NAME = <SID name>)
(GLOBAL_DBNAME = <DB Unique Name value + domain>)
(ORACLE_HOME = <Oracle Home>)
)
(SID_DESC =
(SID_NAME = <SID name>)
(GLOBAL_DBNAME = <DB Unique Name value + _DGB.domain>) or <DB Unique Name value + _DGMGRL.domain>
(ORACLE_HOME = <Oracle Home>)
)

This last entry is used by the Broker and is not a stric necessity for manual manipulation (but must be configured).
And, for the TNS names (the same for both sites), something like:

<DB Unique name> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <server>)(PORT = <primary port>))
(CONNECT_DATA =
(SERVICE_NAME = <DB Unique name>) -> defined "automatically"
(SERVER = dedicated)
)
)

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here