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"

Are You Ready for the Oracle Database 19c Administration Certification?

Why DBA should pass the Oracle Database 19c OCP exam?

DBA should get ready for new features & they should test themselves through latest certification.

We know that Oracle Database 19c is the latest release of the world’s most popular database.

Oracle Database 19c is the final and long term support release of the Oracle Database 12c family of products (12.2.0.3).Long term support means that Oracle Database 19c comes with 4 years of premium support (March 2023) and a minimum of 3 years extended support(March 2026).

Now from Oracle Database 19c an Oracle Certified Associate (OCA) certification path is not required.

Oracle Database Administration 2019 Certified Professional is the new certification credential for Oracle Database 19c Administrators.

For Oracle Database 19c OCP DBA needs to pass these two exams.

1-Prepare for Oracle Database Administration I | 1Z0-082

2-Prepare for Oracle Database Administration II | 1Z0-083

For Upgrade from previous database version (OCP or OCA) dba should pass only one exam.

Prepare for Oracle Database Administration II | 1Z0-083

Cheers!!!!

Oracle Database 19c New Static Data Dictionary Views

 Static Data Dictionary Views

These are new static data dictionary views which are introduce in Oracle Database Release 19c.

ALL_TRIGGERS_AE

DBA_TRIGGERS_AE

USER_TRIGGERS_AE

DBA_AUTO_INDEX_CONFIG

DBA_AUTO_STAT_EXECUTIONS

DBA_PDB_SNAPSHOTFILE

DBA_RAT_CAPTURE_SCHEMA_INFO

DBA_REGISTRY_BACKPORTS

DBA_SQL_QUARANTINE

 

ALL_TRIGGERS_AE 

1	It describes the triggers on tables accessible to the current user.

DBA_TRIGGERS_AE

1	It describes all triggers in the database.

USER_TRIGGERS_AE

1	IT describes the triggers owned by the current user.

DBA_AUTO_INDEX_CONFIG

1	IT displays the current configuration parameter settings for automatic indexing.

 DBA_AUTO_STAT_EXECUTIONS

1	IT displays information about automatic optimizer statistics collection tasks.

DBA_PDB_SNAPSHOTFILE

1	It displays the files associated with snapshots taken of pluggable databases (PDBs).

DBA_RAT_CAPTURE_SCHEMA_INFO

1	It displays the login schema and current schema that were in effect when SQL statements were recorded in a workload capture.

DBA_REGISTRY_BACKPORTS

1	It displays backported bug fixes that were applied to the database. This view displays only bug fixes that changed the data dictionary of the database.

DBA_SQL_QUARANTINE

1	It displays information about quarantine configurations.

With Best Wishes!!!!