Tag Archives: oracle

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: [...]

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 [...]

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 KEY MODE OWNER GROUP SEGSZ Shared Memory: m 1493172237 0x32d14fb8 [...]

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 [...]