DG修改SYS用户密码(ORA-16810,ORA-01017)
修改主库PROD1密码后,查看configuration状态看到以下报错:
[oracle@edgzrip1-PROD1 ~]$ dgmgrl sys/oracle
DGMGRL for Linux: Version 11.2.0.3.0 - Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> show configuration;
Configuration - PROD1.us.oracle.com
Protection Mode: MaxAvailability
Databases:
PROD1 - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database
DG - Physical standby database
Error: ORA-01017: invalid username/password; logon denied
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
解决方法:
1、关闭备库(DG)
2、将主库密码文件orapwPROD1传输到备库,并修改文件名为:orwpwDG
[oracle@edgzrip1-PROD1 ~]$ scp /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD1 edgzrip2:/u01/app/oracle/product/11.2.0/db_1/dbs/orapwDG
3、启动备库(DG)
4、再次查看configuration信息
[oracle@edgzrip2-DG dbs]$ dgmgrl sys/oracle
DGMGRL for Linux: Version 11.2.0.3.0 - Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> show configuration verbose;
Configuration - PROD1.us.oracle.com
Protection Mode: MaxAvailability
Databases:
PROD1 - Primary database
DG - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
2019-3-27 18:21