Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Problem of SYS password synchronization in oracle 11g 12c dg environment

2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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.

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.

Here are a few points of knowledge:

1. The password file in 11g cannot be stored in the asm share to access. To change the SYS password, you need to manually synchronize each RAC node. Similarly, the password file of the slave library should also be updated and overwritten manually.

2. Version 12.1 can realize password file ASM shared storage, and only one node in RAC needs to execute alter user sys to synchronize all nodes in the main library, which cannot be realized in 11g. However, the password file in the standby library still needs to be overwritten by manually synchronizing the password file of the main library.

3. Version 12.2 oracle realizes automatic synchronization of password files on all master and standby nodes under the premise of ASM sharing and storage of password files.

MOS

Automatic Password file synchronization in 12.2 Dataguard Standby database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report