sshUserSetup.sh: Remote host reachability check failed

I had this issue while installing grid in my lab.Checked everything: ping to both nodes, ssh to both nodes both ways… all ok, but still not able to run sshUserSetup.sh: Well… what was the problem? “racnode1 racnode2” vs “racnode1 racnode2” ( the “)And now it runs ok: Post Views: 2,481

How to check how much archive logs DB is generating

You have been requested to check how much a DB is generating on archive logs, it can be for FRA size planing, standby lag analysis…. you name it. We can see here DB has the higher load during 1am to 3am. Here you can get the size it is generating per day: Post Views: 1,679

SQL: How to kill sessions in bulk

For this first post, lets start with something easy that everyone that manages a DB should know. You have been requested to kill everything that RMAN is running for whatever reason. It can be backup is no longer valid or it is generating impact in performance, which needs to be resolved right away. Do you... » read more