If you enable the unified audit feature announced with 12c, all audit records will be in the UNIFIED_AUDIT_TRAIL table. Logon failure records will not be …
Read More »dbtut
SYSAUX Tablespace Usage
What is the SYSAUX Tablespace and What is it used for? In Oracle databases, SYSAUX tablespace is an auxiliary storage space for SYSTEM tablespace. Most …
Read More »Blank screen issue When You Run Runinstaller for Oracle 19c Installation
When runinstaller for Oracle 19c database installation is run in Linux environments, a blank screen appears due to problems with fonts. The same problem occurs …
Read More »Principle of Least Privilege in Oracle Databases
The principle of least privilege (POLP) is an important concept in computer security, is to restrict users’ privileges to the minimum level they need to …
Read More »Oracle Cloud Free Tier
What is Oracle Cloud Free Tier? Oracle Cloud Free Tier is a free service that allows you to use Oracle Autonomous Database and Oracle Cloud …
Read More »ORA-19633: control file record is out of sync with recovery catalog
This error occurs due to problems during the upgrade process of databases from 11g to 12c. If the Upgrade is not completed and 11g continues …
Read More »ORA-12911: permanent tablespace cannot be temporary tablespace
After upgrading to 12.2 databases, the temporary temp tablespace of some users is set to SYSTEM due to bug number 23715518. In this case, when …
Read More »Read Oracle alert log From SQL
It is possible to query the contents of the alertSID.log file in Oracle databases, such as a table in the database. To do this, you …
Read More »ORA-39143: dump file may be an original export dump file
When importing with Data Pump, errors occur as follows due to the creation of the relevant dump file with the traditional export (exp) command. [crayon-67402d100b1f0761897243/] …
Read More »Pluggable Database Creation Methods and Tools
There are various methods and different tools for creating a pluggable database within a container database (CDB). The methods and tools to create a pluggable …
Read More »