Category Archives: Oracle

New job

That’s right, I’ve finally changed jobs at Oracle and am now about to embark on supporting Solaris on Exadata in RPE (Revenue Product Engineering) when it’s released sometime next year. It was a decision I had to really think about … Continue reading

Posted in Oracle, Solaris | Leave a comment

Upgrading Oracle 10g on OpenSolaris

Ran into a problem trying to upgrade my Oracle instance from 10.2.0.1 to 10.2.0.4: “Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-07-14_10-28-22AM. Please wait …oracle@dbserver:/u04/database$ Exception in thread “main” java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-07-14_10-28-22AM/jre/1.4.2/lib i386/motif21/libmawt.so: ld.so.1: java: fatal: libXm.so.4: open failed: No such … Continue reading

Posted in Oracle | Leave a comment

Don’t forget truss for diagnosing issues

Oracle came to us via the VOSJEC channel for help in diagnosing a customer getting the following error in the alert log during various DML queries: ORA-27505: IPC error destroying a port ORA-27300: OS system dependent operation:close failed with status: … Continue reading

Posted in Oracle | Leave a comment

Capturing data on Oracle “WARNING: aiowait timed out” events

Oracle "WARNING: aiowait timed out" error messages in the alert log are always something that needs further investigation as it can indicate some kind of I/O or system resource issue that stopping valuable I/O’s down to storage. Now there could … Continue reading

Posted in Oracle | Leave a comment

Oracle parallel query performance on a T5140

Being an engineer it’s always a good feeling getting to the bottom of a problem and none so as this one. Take a T5140, create a 3 way RAID 0 LUN using the internal disks and stick Oracle on top … Continue reading

Posted in Oracle | 1 Comment