Disclaimer

Thursday, 10 June 2021

How To Find Which Groups(OSDBA,OSASM,OSOPER,DBA) have set During Oracle Database Installation

 

What groups selected during Oracle binary installation may not be remembered after installation. 

Or it may be necessary to determine which groups are selected for binarys that someone else has set. 

This information is contained in $ORACLE_HOME/rdbms/lib/config.c.

We can determine which groups are selected during installation as follows.


1
2
3
4
5
6
7
8
9
[oracle@oradb ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@oradb lib]$ grep "define SS_" config.c
#define SS_DBA_GRP "dba"
#define SS_OPER_GRP "oper"
#define SS_ASM_GRP ""
#define SS_BKP_GRP "dba"
#define SS_DGD_GRP "dba"
#define SS_KMT_GRP "dba"
#define SS_RAC_GRP "dba"

No comments:

Post a Comment

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...