Home » Server Options » Data Guard » Unable to issue " show configuration " while setting up the data broker setup (sun solaris 9.5 - oracle 10.g ( 10.2.0.1.0 ) )
Unable to issue " show configuration " while setting up the data broker setup [message #450565] Thu, 08 April 2010 00:33
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

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 
Previous Topic: Data Guard
Next Topic: Data Guard on RAC
Goto Forum:
  


Current Time: Wed Aug 12 19:31:09 CDT 2020