The MySQL root password allows the root user full access to the MySQL database. If you do not remember the root password of the mysql …
Read More »dbtut
How To Backup MySQL Databases With mysqldump
Mysql database should be backed up daily or periodically. It is possible to back up regularly with a script that we will create in the …
Read More »Diagsnap in Oracle 12c
What is Diagsnap in Oracle 12c Diagsnap is a new feature introduced in 12.1.0.2 GI, which manages the diagsnap resource, which collects additional operating system …
Read More »How To List Applied Patches in Oracle
You can list applied patches in Oracle by query except for “opatch”. You can use DBA_REGISTRY_HISTORY for databases 11g and earlier, and DBA_REGISTRY_SQLPATCH for databases …
Read More »How To Failover and Failback PostgreSQL Replication
You may want to read the following articles about replication before reading this article. “How To Install PostgreSQL Replication By using archive_command On Centos“, “How …
Read More »How To Install PostgreSQL Replication With Replication Slots
First of all, we must install PostgreSQL on Primary Server and perform initdb operations. You can find out how to do this in the article …
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 »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 »