When we get the RMAN-06091 error during operations with RMAN, we need to open a new channel for maintenance. You can use the following command. …
Read More »How to Start Oracle Database Automatically When Linux Server Is Started
In this article, I will share linux scripts with you for staring database automatically when operating system is started. My environment is: Oracle 11.2.0.4 …
Read More »Oracle DB 11.2.0.4 Installation – Error in invoking target ‘agent nmhs of makefile ins_emagent.mk’
In this article, I will show you hot to solve “Error in invoking target ‘agent nmhs of makefile ins_emagent.mk” while you try to install …
Read More »SAN Infrastructure of SQL Server Servers and the Story of a Query
In this article, I will talk about how SQL Server writes data to storage and reads data from storage. I will also explain how …
Read More »Network Configuration of SQL Server Servers and Always ON Availability Group Synchronization From a Different Ethernet Card
Before reading this article, I suggest you read my article “SQL Server Always ON Availability Group” to understand the operation logic of the Availability …
Read More »ASM Disk Rebalance Error ORA-15041
After ASM disk operations, rebalance operation may end with ORA-15041 error. This error means there is not free space. When we check the ASM …
Read More »What is RAID
When choosing a RAID structure or designing storage, I strongly recommend that you do not stay away. These processes directly affect database performance. The …
Read More »Foreign Data Wrapper Between PostgreSQL and Oracle
In the article “Postgresql Foreign Data Wrapper“, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data …
Read More »How To Recreate Temp Tablespace
When temp tablespace grows uncontrollably, it may be necessary to reduce its size. For this, the temp tablespace needs to be recreated in a …
Read More »Is SQL Server Memory Enough(Memory Grants Pending)
In this article, we will examine several ways to determine if SQL Server Memory is sufficient. SQL Server tries to use all memory on …
Read More »