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 »Oracle Data Guard Architecture
Oracle Data Guard has a simple and easy operation logic. Moves the redo data in the primary database to the Standby database and applies the …
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-6740da9b4ce8f197433990/] …
Read More »ORACLE 19C NEW FEATURES AND HOW TO APPLY THEM
Automatically Run Configuration Scripts Before 19c in the oracle database software installation requires manual effort to run the root.sh scripts. But from 19c we can …
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 »Table Partitioning in PostgreSQL 11.2
This article contains information about table partitioning in PostgreSQL. We will look at the answers for the questions; What is partition in PostgreSQL What are …
Read More »Oracle Net Services
Introducing Oracle Net Services Oracle Net services are often used to enable network connections for applications or different clients to connect to databases. Allows connection …
Read More »RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)
Before 12c if one of the standby database goes out of sync with respect to the primary database we have to perform the below steps …
Read More »How To Change Instance Settings in SQL Server
In this article I will explain how to configure SQL Server Instance through SSMS. Right-click on the instance via SSMS and click properties. You will …
Read More »Multitenant Database in Oracle
What is a Multitenant Database? As of version 12.1, you can design your databases as a multitenant database (CDB). It consists of a container database, …
Read More »