• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Oracle Database 12c New Feature: SYSRAC administrative privilege

by admin

Separation of Duty for Administering Oracle Real Application Clusters.

Starting with Oracle Database 12c Release 2, Oracle Database provides support for separation of duty best practices when administering Oracle RAC by introducing the SYSRAC administrative privilege for the clusterware agent. This feature removes the need to use the powerful SYSDBA administrative privilege for Oracle RAC.

SYSRAC, like SYSDG, SYSBACKUP and SYSKM, helps enforce separation of duties and reduce reliance on the use of SYSDBA on production systems. This administrative privilege is the default mode for connecting to the database by the clusterware agent on behalf of the Oracle RAC utilities, such as SRVCTL.

The SYSRAC administrative privilege is the default mode of connecting to the database by the Oracle Clusterware agent on behalf of Oracle RAC utilities, such as SRVCTL, meaning that no SYSDBA connections to the database are necessary for the everyday administration of Oracle RAC database clusters.

Note: The SYSRAC privilege only allows OS authentication by the Oracle agent of Oracle Clusterware. Password files and strong authentication cannot be used with the SYSRAC privilege.

Summary:

– Separation of duty best practices when administering Oracle RAC is supported by the SYSRAC administrative privilege.
– This feature eliminates the need to use the powerful SYSDBA administrative privilege for Oracle RAC.
– SYSRAC is the default mode for connecting to the database by the clusterware agent on behalf of RAC utilities, like SRVCTL.
– No SYSDBA connections to the database are necessary for the everyday administration of Oracle RAC database clusters.
– Connecting as SYSRAC:

SQL> CONNECT / AS SYSRAC
SQL> CONNECT /@db1 as SYSRAC
SQL> CONNECT /@db2 as SYSRAC

Filed Under: oracle, oracle 12c, RAC

Some more articles you might also be interested in …

  1. What Is Oracle Key Vault
  2. How to Change default Oracle database listener port (1521)
  3. Managing Rollback/Undo Segments in AUM (Automatic Undo Management)
  4. How to rename database and then move datafile online in Oracle Database 12.2
  5. Oracle Database 18c New Feature – Memoptimized Rowstore
  6. How to use Privilege Analysis in Oracle Database
  7. How to Drop/Truncate Multiple Partitions in Oracle 12C
  8. How to Clone PDB With Oracle Key Vault (OKV)
  9. How does the RMAN Retention Policy Obsolete Incremental Backupsets
  10. ORA-38760 while starting One of the Oracle RAC Instances

You May Also Like

Primary Sidebar

Recent Posts

  • nixos-rebuild Command Examples in Linux
  • nixos-option: Command Examples in Linux
  • nixos-container : Command Examples in Linux
  • nitrogen Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright