成都网站建设设计

将想法与焦点和您一起共享

oracle11g12cdg环境SYS密码同步的问题

When password file is used for Redo Transport Authentication, the password of redo transport user should be same across primary and all its physical and snapshot standby databases. By default SYS user is used to authenticate redo transport sessions when password file is used.

创新互联-专业网站定制、快速模板网站建设、高性价比五指山网站开发、企业建站全套包干低至880元,成熟完善的模板库,直接使用。一站式五指山网站制作公司更省心,省钱,快速模板网站建设找我们,业务覆盖五指山地区。费用合理售后完善,10年实体公司更值得信赖。

Till 12cR1 Dataguard setup, if there is a change in password file of Primary database like Changes in password or Changes in admin privileges, then the password file needs to be copied from Primary database to standby database server and rename it according to standby database Instance name. If the password file of Primary and Standby databases are not same, then errors will be seen.

In 12cR2, the password file of standby database gets synchronized automatically when there is a change in Primary database password file. The password file change of Primary will be included in Redo and when the Redo is applied to standby, the synchronization happens in the background.

这里延伸几个知识点:

1 、 11g中口令文件并不能实现存放于asm共享访问,修改SYS密码,需要再每个RAC节点手动实施同步 ,同样备库的口令文件也要手动进行更新覆盖
2、12.1版本可以实现口令文件ASM共享存储,RAC中只需要一个节点执行alter user sys 就可以实现主库所有节点同步,这点是11g中无法实现。但是备库中口令文件依然需要手动同步主库的口令文件过来覆盖
3 、12.2版本oracle在口令文件ASM共享存储的前提下,实现了口令文件自动同步主备所有节点

MOS ---
Automatic Password file synchronization in 12.2 Dataguard Standby database


分享文章:oracle11g12cdg环境SYS密码同步的问题
文章起源:http://chengdu.cdxwcx.cn/article/gddshh.html