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 »ORACLE
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 »How To Install Oracle Client For PostgreSQL On Centos
Oracle_client is required to connect to remote Oracle databases. For Oracle Foreign Data Wrapper, this installation needs to be done as follows. First of …
Read More »How To Increase ASM Rebalance Processing Speed
The ARBn background process starts the rebalance process automatically when you delete or insert a disk from the ASM disk groups. This process is …
Read More »How To Check Oracle ASM Instance
It is useful to check occasionally whether everything is normal in the Oracle ASM instance. To do this, some information should be collected and …
Read More »How To List Files and Sizes within an ASM Disk Group
We can see asm files in Oracle ASM disk group without asmcmd. You can run the following query to view files and sizes in …
Read More »Poor Performance Status on Exadata Cellnode Flash Disks
The status of the Exadata cellnode flash disks may occasionally be poor performance. If the error numbers are 0 (zero) or too low when …
Read More »ORA-01618: redo thread 2 is not enabled – cannot mount
When opening the database, if there is a redolog group that is not enabled for the corresponding thread, it gives an error as ORA-01618. …
Read More »How To Transfer a Database in the File System To ASM
This article describes how to move a database in the file system into ASM. First, Grid Infrastructure installation is required. We are creating two …
Read More »