Oracle Database: Tools for Monitoring (I/O, Network)
In this blog I discuss few tools which can be used for database or systems monitoring to be precisely. If you want to know what rpms you should be installing...
Friday, May 31, 2019
Oracle Database: How to relocate tablespaces to different Diskgroup (except SYS)
in this blog, I list out steps for Oracle RAC relocating tablespaces to different diskgroups with partial downtime only Step1 - backup tablespaces to new diskgroup - run { allocate...
Oracle Database: RAC - Relocate UNDO to different Diskgroup (and Standby)
In this blog I discuss steps to relocate Undotablespaces on a 2 node rac cluster. Currently tablespaces are Node 1 - undotbs1 Node 2 - undotbs2 Step 1 - Create...
Oracle Database: How much can you shrink tablespace / Size
It's one of the big questions on how much I will be able to shrink my tablespace or my datafiles. It is easy just run this and substitute the name...
Oracle Database 11g: SYSAUX Too large
SYSAUX has a lot of bugs when it comes to purging, and I had to face quite a lot of them. My SYSAUX started with this (refer end of blog...
Friday, May 10, 2019
Oracle Database: Recommended RPM's except the default ones
In this blog I list RPM's which I always recommend on a Linux installation additional to what Oracle mandates. these RPM's are helpful on operational purposes and are required by...
Tuesday, May 7, 2019
Oracle Database: Updating Grid / Oracle Inventory Manually
In this small blog, I will tell you how to update the inventory file with node names manually. This is useful in many cases 1. Inventory does not have node...
Oracle Database: VOTE Disk (Closed) / Not Available
In this blog I am going to discuss an issue which I faced during my maintenance on cluster. One of the votedisk became unavailable and was dropped from the system...
Monday, May 6, 2019
Oracle Database 19c: Grid Infrastructure / RAC Silent Installation
In this blog I will be telling you how to install Oracle 19c RAC in Silent Mode. Remember the key thing with RAC is that it requires a lot of...
