Oracle 11g 12c DG Environment sys Password Synchronization problem

Source: Internet
Author: User

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

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 is 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 is not same, then errors would be seen.

In 12cr2, the password file of standby database gets synchronized automatically when there was a change in Primary database Password file. The password file change of Primary would be included in Redo and when the Redo are applied to standby, the synchronization Happens in the background.

Here are a few points of knowledge:

1, 11g password file can not be stored in ASM shared access, modify the SYS password, you need to manually implement synchronization for each RAC node, the same library password file to manually update the overwrite
Version 2, 12.1 can implement the password file ASM shared storage, RAC only need a node to execute the ALTER user SYS to achieve the main library all node synchronization, this is not possible in 11g. However, the password file in the repository still needs to manually synchronize the password file of the main library to overwrite it.
3, 12.2 version of Oracle in the password file ASM shared storage, the implementation of the password file automatic synchronization of the primary and standby all nodes

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

Oracle 11g 12c DG Environment sys Password Synchronization problem

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.