Read-Only Users in Oracle Enterprise Manager
Oracle Enterprise Manager is really powerful tool for database administration (and much more), which can be used by endusers which are not 100% familiar with the the Oracle architecture and the data ditionary. But if these users have too many privileges, they can cause damage to the database. How to restrict the access to Enterprise…
Pluggable Databases and “DATA_PUMP_DIR” – ORA-39087
Some days ago I ran into the issue that using the directory “DATA_PUMP_DIR”, which is created in every Oracle 12c database, cannot be using when exporting data of a PDB. This is documented in the “Utilities Guide” (Chapter „Overview of DataPump“) “The default Data Pump directory object, DATA_PUMP_DIR, does not work with PDBs. You must…
Change the OS groups for SYSDBA, SYSOPER, SYSBACKUP, SYSDG and SYSKM
Oracle 12c allows you the separate the DBA tasks backup (RMAN), DataGuard and key management (Transparent Data Encryption) between different OS users. This is not required, but can be helpful. Sometimes these groups are not available when you install the Oracle software or you decide later to separate the duties. Oracle 12c erlaubt die Aufteilung…