I’ve been evaluating PostgreSQL clustering options for my current project. The reason I’m looking at clustering is that the DB server will be handling a large number of users and any downtime is catastrophic. So reliability comes before any performance or administrative concerns in a clustering solution. My platform is PostgreSQL 8.3 and SLES Linux. [...]

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