What is pgBackRest pgBackRest is a backup/restore tool in postgresql. PostgreSQL Backup Types In Postgresql, we create backups in two ways: logical and physical. Logical …
Read More »ORA-44787: Service cannot be switched into
If you have created and enabled a new service and then created a pluggable database, you may receive this error if you want to switch …
Read More »How To Reset ILOM SP(Service Processor) of Exadata Compute and Cell Node
We can reset the ILOM SP of compute nodes and cell nodes as follows: You can connect to the Ilom IP via ssh and run …
Read More »How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c
Connect to Root Container The connection to the root container is the same as connecting to the database instance in previous versions. Connection can be …
Read More »How To Change Column’s Data Type in PostgreSQL
Suppose that we created a table in the database by following the normalization rules for our application. However, we realized that the data type of …
Read More »Exadata – Disk Scrubbing Feature
Disk scrubbing exists on Exadata cell nodes to automatically repair the failed sector of the disk when the system is idle without compromising system performance. …
Read More »FATAL: lock file already exists
You may receive this error when there are multiple IPs on the same server that use the same port. In this case, you cannot run …
Read More »Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server
In some cases, sessions are blocked in databases. There are many reasons for blocking. In this article, I will not go into details of this …
Read More »SQL Server Database Mail History Cleanup and Prevent msdb Database From Growing
If you are using SQL Server Database Mail, your msdb database can grow undesirably. We can use the msdb.dbo.sysmail_delete_mailitems_sp procedure to clear Database Mail History. …
Read More »Upgrade SQL Server
First of all, upgrade is an important task. Before upgrading, you must check your database is ready to upgrade with the help of Database Migration …
Read More »