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
最新文章
- C/C++中无条件花括号的妙用
- 恢复CRM plugin
- HDOJ(2438)几何里的三分
- 操作系统开发系列—13.e.三进程
- System.MissingMethodException: 找不到方法:
- makefile 学习(一)
- 解决windows端口被占用
- 转:Asp.Net MVC中DropDownListFor的用法
- Nginx搭建反向代理服务器过程详解(转)
- CodeForces 659F Polycarp and Hay
- tensorflow max_pool(最大池化)应用
- Linux-grep 命令和find 命令 (6)
- Navicat Premium连接各种数据库
- cmake-file
- Netty源码分析第4章(pipeline)---->;第3节: handler的删除
- http 服务器编程 适配器
- 前端 javascript 数据类型 数组 列表
- ACM输入函数测试 - scanf cin 优化的输入
- IE8按F12开发人员工具不显示
- C#后台unxi时间戳转换为前台JS时间的方法