Usage: alertwatch.pl /path/to/alert.log Info: alertwatch is a perl program to monitor your oracle alert log. No need to loop this with a cron, just start it in the background and let it run, the second an ORA- error is written to the alert.log it will be mailed to the DBA. Configuration: Make sure to change: [...]

If you create a new database, listener, etc. on a machine that has an existing Grid Control Agent on it, you may need to tell the agent to “rescan” the system to pick up the new database (to have the DB show up in OEM). Set your agent home AGENT_HOME=/opt/app/oracle/agent10g Make sure $AGENT_HOME/bin is in [...]

I once ran into an instance where the Unix admins didn’t believe me that i was running out of shared memory despite the errors, I was showing them. I wrote this perl script to allocate chunks of shared memory until it failed to prove to them that yes, regardless of what you have the global [...]

Sometimes you may see core dumps, etc related to lack of shared memory. To check to see how much is currently being used you can use the below command: kerrd@vexbert<10> ipcs -bm IPC status from as of Thu Oct 30 10:42:06 PDT 2008 T ID KEY MODE OWNER GROUP SEGSZ Shared Memory: m 1493172237 0x32d14fb8 [...]

Stop the databases on all nodes Run the following command to bring down the oracle CRS sudo /etc/init.d/init.crs stop sudo /etc/init.d/init.crs stop Shutting down Oracle Cluster Ready Services (CRS): Stopping resources. This could take several minutes. Successfully stopped CRS resources. Stopping CSSD. Shutting down CSS daemon. Shutdown request successfully issued. Shutdown has begun. The daemons [...]