Home » Server Options » Data Guard » Data Guard Broker (10g Enterprise Edition Release 10.2.0.1.0 Linux (Rhel 4))
Data Guard Broker [message #375975] Mon, 15 December 2008 09:27 Go to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Dear friends
I am not able to configure data gurad broker this is the poing i stuck please help.
DGMGRL> create configuration 'DG' as primary database is 'node1'
connect identifier is 'dbprimary';
Configuration "DG" created with primary database "node1"
DGMGRL> add database 'node2' as connect identifier is 'dbstandby' maintained as physical;
Database "node2" added
DGMGRL> show configuration;
Configuration
Name: DG
Enabled: NO
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
node1 - Primary database
node2 - Physical standby database
Current status for "DG":
DISABLED
DGMGRL> show configuration;
Configuration
Name: DG
Enabled: NO
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
node1 - Primary database
node2 - Physical standby database
Current status for "DG":
DISABLED
After that i tried to enable configuration but it hangs and in alert logs it shows following "INSV started with pid=24, OS id=5004 NSV1 started with pid=19, OS id=5023"
Please help me out
with regds
rajnish

[Updated on: Mon, 15 December 2008 09:29]

Report message to a moderator

Re: Data Guard Broker [message #376543 is a reply to message #375975] Wed, 17 December 2008 14:05 Go to previous messageGo to next message
sonumalhi
Messages: 62
Registered: April 2008
Member
Is DG_BROKER_START parameter is enabled on standby?

Is standby working properly before creating the configuration?

Are there any errors in standby alert logs?





Re: Data Guard Broker [message #376653 is a reply to message #376543] Thu, 18 December 2008 03:17 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Dear sonumalhi
Really thanks for your reply. About two days back i have solved problem and now i am able to enable configuraiton the problem is i did't add DGMGRL with db_name in tnsnames.ora and listener.ora after adding the same problem get rectified now this is my configration. but another problem comes with this when i do
dgmgrl>switchover to node2 # node2 is standby database
Operation requires shutdown of instance "orcl" on database "orcl"
Shutting down instance "orcl"...
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "orcl" on database "orcl"
Starting instance "orcl"...
Unable to connect to database
listener.ora (on Primary)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
(GLOBAL_DBNAME = orcl_DGMGRL)
)
)
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
)
)
tnsnames.ora (on primary)
DBSTANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.232)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl_DGMGRL)
)
)

DBPRIMARY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl_DGMGRL)
)
)
RCATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora(standby)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
(GLOBAL_DBNAME = orcl_DGMGRL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.232)(PORT = 1521))
)
)
)
tnsmames.ora(standby)
DBSTANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.232)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl_DGMGRL)
)
)
DBPRIMARY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl_DGMGRL)
)
)
RCATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.232)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
with regds
rajnish

[Updated on: Thu, 18 December 2008 03:19]

Report message to a moderator

Re: Data Guard Broker [message #376662 is a reply to message #376543] Thu, 18 December 2008 03:41 Go to previous messageGo to next message
Khurram Siddiqui
Messages: 5
Registered: March 2004
Junior Member
sonumalhi

DG_BROKER_START parameter is true obvioulsy otherwise OP cannot connect to data guard broker and cannot create configuration files.Its a DMON process parameter without enable/true it ,you can no longer be connected to database data guard borker.

To OP for connectivity problem,check it with making remarks

listener.ora (on Primary)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
#(PROGRAM = extproc)<----check it after make remarks this line
)


listener.ora(standby)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
#(PROGRAM = extproc)<----check it after make remarks this line

)


Khurram

[Updated on: Thu, 18 December 2008 03:52]

Report message to a moderator

Re: Data Guard Broker [message #376800 is a reply to message #376662] Thu, 18 December 2008 10:18 Go to previous message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Dear friends
As you suggested i was commented this parameter "#(PROGRAM = extproc)" in listener.ora but still problem persist. This is the output which come at console
(I have already done Alter system set dg_broker_start=True scope=both; at primary and standby)
DGMGRL> show configuration verbose;
Configuration
Name: DG
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
node1 - Primary database
node2 - Physical standby database
Current status for "DG":
SUCCESS
DGMGRL> switchover to node2;
Performing switchover NOW, please wait...
Operation requires shutdown of instance "orcl" on database "node1"
Shutting down instance "orcl"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires shutdown of instance "orcl" on database "node2"
Shutting down instance "orcl"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "orcl" on database "node1"
Starting instance "orcl"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Failed.
You are no longer connected to ORACLE
Please connect again.
Unable to start instance "orcl"
You must start instance "orcl" manually
Operation requires startup of instance "orcl" on database "node2"
You must start instance "orcl" manually
Switchover succeeded, new primary is "node2"
with regds
rajnish

[Updated on: Thu, 18 December 2008 10:29]

Report message to a moderator

Previous Topic: Data Guard Implementation
Next Topic: Data Guard Broker CLI
Goto Forum:
  


Current Time: Sat Dec 03 20:09:54 CST 2016

Total time taken to generate the page: 0.05794 seconds