Has anyone seen anything similar to the following: After Installing SQL*Backtrack on a Solaris 2.6 box, one of the databases on that box started coming down with 7264 errors a couple of times a week. This is an 8.0.5.2.1 database and it is not the database being accessed by SQL*Backtrack.
In an effort to debug, we issued an ipcs command prior to and after executing an export via sql*backtrack. After the export of database A, the semaphore set for database B was gone, and it came tumbling down with the 7264 error Mon Jan 21 04:05:52 2002 DBW0: terminating instance due to error 7264 07264, 00000, "spwat: semop error, unable to decrement semaphore." // *Cause: Semop system call returned an error. Semaphore set may not exist. // *Action: Check errno. Semaphore ID is returned in sercose[0]. Verify // semaphore set exists. A possible cause for this error is that a // "shutdown abort" was done while this process was running. we ran the export at 4:00 and it finished at 4:01 cobra:/var/adm/sa> sar -m -f sa21 SunOS cobra 5.6 Generic_105181-29 sun4u 01/21/02 00:00:01 msg/s sema/s 03:00:01 0.00 10.20 03:15:00 0.00 13.46 03:30:00 0.00 10.05 03:45:00 0.00 10.05 04:00:00 0.00 10.03 04:15:00 0.00 16116.36 04:30:00 0.00 9.94 04:45:01 0.00 69.34 05:00:00 0.00 14.37 05:15:00 0.00 9.97 05:30:00 0.00 9.97 05:45:01 0.00 9.97 Thanks Kurt Wiegand -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
