I had recently created a 2node RAC standby database from a 2 node RAC primary database .Also configured for dataguard broker , but while checking the status of the configuration through "show configuration" it was showing the errors like
*********************************
Error stack from primary database
*********************************
[oracle@subhen-db07 ~]$ . oraenv
ORACLE_SID = [ORCL1] ? ORCL1
The Oracle base for ORACLE_HOME=/oracle/app/database/11.2.0.3/dbhome_1 is /oracle/app
[oracle@subhen-db07 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys@ORCL
Password:
Connected.
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxAvailability
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Error: ORA-16664: unable to receive the result from a database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
DGMGRL> exit
****************************
Error stack from standby database
****************************
[oracle@standby-db07 ~]$ . oraenv
ORACLE_SID = [oracle] ? ORCLB1
The Oracle base has been set to /oracle/app
[oracle@standby-db07 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys@ORCLB
Password:
Connected.
DGMGRL> show configuration
Configuration - ORCLdg
Protection Mode: MaxAvailability
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01017: invalid username/password; logon denied
ORA-16625: cannot reach database "ORCL"
DGM-17017: unable to determine configuration status
****************************
Solution for the above errors
*************************
Copy the password file from one of the primary instance hosts to other standby sites( note: don't create password files at standby host using ORAPW utility)
*****************************************************
After copying the password file from primary over to standby host
***************************************************
[oracle@subhen-db07 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys@ORCL
Password:
Connected.
DGMGRL> show configuration
Configuration - orcldg
Protection Mode: MaxAvailability
Databases:
ORCL - Primary database
ORCLB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
No comments:
Post a Comment