Dear sir / madam,
iam creating a test standby database and doing broker setup.
dataguard setup done without any error and iam able to receive files in DR and MRP able to apply the same in DR site.
now iam doing BROKER setup.
As a first step, i did the configuration, and attached DR database with this configuration. Now iam trying to enable configuraiton, where it is getting hanged.
[code]$ dgmgrl
DGMGRL for Solaris: Version 10.2.0.1.0 - 64bit Production
Copyright (c) 2000, 2005, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/**********
Connected.
DGMGRL> show configuration
Configuration
Name: PRODCONF
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
PRIM - Primary database
stdby - Physical standby database
Current status for "PRODCONF":[/code]
(ii) and iam getting below error from data guard broker log:
[code]bash-2.05$ tail -f dr*
DG 2010-04-07-12:57:58 0 2 0 NSV0: Failed to connect to remote database P
RIM. Error is ORA-12514
DG 2010-04-07-12:57:58 0 2 0 NSV0: Message is dropped.
DG 2010-04-07-12:57:58 0 2 0 DMON: Database PRIM returned ORA-12514
DG 2010-04-07-12:57:58 0 2 0 for opcode = CTL_ENABLE, phase = END,
req_id = 1.1.715625201
DG 2010-04-07-15:10:52 0 2 715696591 DMON: ENUM_DRC: success. (len = 635)
DG 2010-04-07-15:10:52 0 2 715696591 DMON: ENUM_DRC operation completed
DG 2010-04-07-15:11:09 0 2 715696592 DMON: ENUM_DRC: success. (len = 635)
DG 2010-04-07-15:11:09 0 2 715696592 DMON: ENUM_DRC operation completed
DG 2010-04-07-15:11:09 1000 2 715696593 DMON: MON_PROPERTY operation complet
ed
DG 2010-04-07-15:11:09 1000 2 715696594 DMON: MON_VERIFY forwarded to site P
RIM for processing
^C[/code]
fyi, iam able to ping PR & DR tnsnames without any error.
please guide me to proceed further.
Thank you
kesavan sundaram