Search This Blog

Total Pageviews

Wednesday, 11 December 2024

Oracle Groups Role Separation (Oracle and Grid , groups and users



Description

OS Group Name

OS Users Assigned

Oracle Privilege

Oracle Group Name

Oracle Inventory/Software Group (mandatory)

oinstall

grid, oracle

 

 

Database Administrator (mandatory)

dba

oracle

SYSDBA

OSDBA

Database Operator

oper

oracle

SYSOPER

OSOPER

ASM Administration Group

asmadmin

grid

SYSASM

OSASM

ASM Database Administrator Group

asmdba

grid, oracle

SYSDBA for ASM

OSDBA for ASM

ASM Operator Group

asmoper

grid

SYSOPER for ASM

OSOPER for ASM

RMAN Management Group

backupdba

oracle

SYSBACKUP

OSBACKUPDBA

Data Guard Management Group

dgdba

oracle

SYSDG

OSDGDBA

Encryption Key Management Group

kmdba

oracle

SYSKM

OSKMDBA

RAC Management Group (from 12.2)

racdba

oracle

SYSRAC

OSRACDBA




 

































[root@oragrid rpm]# /u01/app/19.2.0/grid/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/19.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/19.2.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/oragrid/crsconfig/roothas_2024-12-10_03-50-46PM.log

2024/12/10 15:50:53 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node oragrid successfully pinned.
2024/12/10 15:51:02 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'



oragrid     2024/12/10 15:51:48     /u01/app/grid/crsdata/oragrid/olr/backup_20241210_155148.olr     724960844
2024/12/10 15:51:49 CLSRSC-327: Successfully configured Oracle Restart for a standalone server



Oracle DBA

anuj blog Archive