Oracle: Alertwatch
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:
mail{To} / mail{From} / mail{Subject}
Prereqs:
File::Tail
Mail::Sendmail
(Both [...]
HowTo Rescan databases for the Grid Control Agent
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 your PATH
Run the [...]
Perl script to allocate shared memory (and annoy sysadmins)
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 [...]
HowTo Find info about Shared memory allocation
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 [...]
Gracefully bring down an Oracle RAC cluster
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 should exit soon.
There is a bug in 10g where, on [...]
