If you have DBA privileges, you can connect with that user without knowing a user’s password, then you can set the old password. In …
Read More »ORACLE
RMAN-06091: no channel allocated for maintenance
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 »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 »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 »Oracle Restore Point Creation and Usage
Restore Point is used to create a return point when flashback is active in Oracle 11g and above databases. While the flashback feature of …
Read More »How To Recreate the Enterprise Manager Repository
Mostly, Enterprise Manager has problems with repository. Because it takes a long time to detect and resolve problems, it will be shorter to recreate. …
Read More »How To Recreate Exadata Flashdisk and Flashcache
You can drop and re-create flash disks and flash cache on Exadata cellnodes online. You will need this process if the flash cache is …
Read More »Effects of Very Frequent Growth and Shrink Operations on Automatic Memory Management(AMM)
In Oracle databases, when the Automatic Memory Management (AMM) is active, if the memory values grow and shrink too frequently, wait events can be …
Read More »