12.2 New Feature: Automatically Synchronize Password Files in Oracle Data Guard


passwort

A new feature automatically synchronizes password files across Oracle Data Guard configurations. When the passwords of SYS, SYSDG, and so on, are changed, the password file at the primary database is updated and then the changes are propagated to all standby databases in the configuration.

 
SQL> create user dbaadmin identified by welcome1;
User created.
SQL> grant sysdba to dbaadmin;
Grant succeeded.

[oracle@server1 ]$ sqlplus dbaadmin/welcome1@stbydb as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 10 23:06:41 2017
Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL>

As we can see in the example above. As soon the User dbaadmin has granted sysdba rights, the Information was also updated on the standby site. As result, the user can immediately login to the standby site.
Advertisements

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s