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…
Oracle 12c: SYSBACKUP, SYSDG and OS-Authentication
As we all know, Oracle 12c allows role separation by for database administration in general, Backup & Recovery and DataGuard-Administration. You can define different OS groups for these task at installation time. Mostly these groups are named DBA, BACKUPDBA and DGDBA. Even if you do not want to introduce role separation in the first step,…