What is SYSRAC SESSION?

by Danilo Neto   Last Updated May 22, 2020 22:06 PM - source

In my environment (oracle 19c) I can see several SYSRAC sessions. What is the purpose of this session?

SQL> select username,status from gv$session where type <> 'BACKGROUND';

USERNAME                       STATUS
------------------------------ ------------------------------
SYS                            INACTIVE
SYSRAC                         INACTIVE
SYSRAC                         INACTIVE
SYSRAC                         INACTIVE
SYSRAC                         INACTIVE
SOE                            ACTIVE
SYSRAC                         INACTIVE
SOE                            ACTIVE
SOE                            ACTIVE
SYS                            ACTIVE
SOE                            ACTIVE

USERNAME                       STATUS
------------------------------ ------------------------------
SOE                            ACTIVE
SYSRAC                         INACTIVE
SYSRAC                         INACTIVE

I need to know because sometimes I use a script to kill all sessions and I dont know if I always need to exclude this session of my script (where username <> 'SYSRAC')

I've already research about it, but I just found about SYSRAC role from oracle 12c r2

The following is a list of new features or enhancements provided with Oracle Database 12c Release 2 (12.2):

New Administrator Role

Oracle Database 12c Release 2 (12.2) provides support for separation of duty for Oracle Database by introducing the SYSRAC role for Oracle Real Application Clusters (Oracle RAC) management. SYSRAC, like SYSDG, SYSBACKUP, and SYSKM, enables you to enforce separation of duty and reduce reliance on the use of SYSDBA on production systems. The SYSRAC role is the default mode and is assigned only the priveleges required for connecting to the database by the clusterware agent on behalf of the Oracle RAC utilities such as srvctl.

Tags : oracle rac


Related Questions



Altering the location of Oracle-Suggested Backup

Updated July 03, 2016 08:02 AM

Ways to Schedule Rman backups

Updated February 24, 2017 12:06 PM

EMCA insists that it cannot connect to the service

Updated August 28, 2017 14:06 PM

Password for Oracle Database 18c user “system”

Updated August 02, 2018 06:06 AM