SQL*Backtrack, semaphores, and 7264's
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, 0, 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 sun4u01/21/02 00:00:01 msg/s sema/s 03:00:010.00 10.20 03:15:000.00 13.46 03:30:000.00 10.05 03:45:000.00 10.05 04:00:000.00 10.03 04:15:000.00 16116.36 04:30:000.009.94 04:45:010.00 69.34 05:00:000.00 14.37 05:15:000.009.97 05:30:000.009.97 05:45:010.009.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).
SEMAPHORES AND ORACLE
Hi listers, AIX 4.3.3.0, Oracle 8.1.7 I have been recieving ORA-01041on some clients with Hostdef extension doesn't exist I searched Metalink looking for some answers and all the info points to semaphores configuration vrs oracle processes. Oracle processes is set to 500, but I don't know where to look at semaphores parameters. I found some info that says I should look at SEMMNS kernel parameter, but can't find where and how to look for it. I will appreciate any info on this topic, thanks! Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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).
Re: SEMAPHORES AND ORACLE
Veronica, Oracle on AIX doesn't use semaphores, as AIX has it's own post-wait driver and Oracle doesn't need it's own, hence no semaphores. Details: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=15566.1 Any other errors, stuff in the alert.log, etc? Jared On Monday 03 September 2001 10:55, Veronica Levin wrote: Hi listers, AIX 4.3.3.0, Oracle 8.1.7 I have been recieving ORA-01041on some clients with Hostdef extension doesn't exist I searched Metalink looking for some answers and all the info points to semaphores configuration vrs oracle processes. Oracle processes is set to 500, but I don't know where to look at semaphores parameters. I found some info that says I should look at SEMMNS kernel parameter, but can't find where and how to look for it. I will appreciate any info on this topic, thanks! Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
Re: SEMAPHORES AND ORACLE
If you're on 8.1.7.0.0 it may be a bug. Apply the latest patch. [EMAIL PROTECTED] 09/03/01 16:10 PM Veronica, Oracle on AIX doesn't use semaphores, as AIX has it's own post-wait driver and Oracle doesn't need it's own, hence no semaphores. Details: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=15566.1 Any other errors, stuff in the alert.log, etc? Jared On Monday 03 September 2001 10:55, Veronica Levin wrote: Hi listers, AIX 4.3.3.0, Oracle 8.1.7 I have been recieving ORA-01041on some clients with Hostdef extension doesn't exist I searched Metalink looking for some answers and all the info points to semaphores configuration vrs oracle processes. Oracle processes is set to 500, but I don't know where to look at semaphores parameters. I found some info that says I should look at SEMMNS kernel parameter, but can't find where and how to look for it. I will appreciate any info on this topic, thanks! Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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 commandfor other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mario Alberto Ramos Arellano 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).
Re: Semaphores
Hi KM ipcs -smb will give you avtive semaphores with sizes inside oracle use ORADEBUG ipc Cheers , RS --- Kimberly Smith [EMAIL PROTECTED] wrote: Does any one know how to monitor semaphore usage in HPUX 11? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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). with sizes __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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).
Semaphores
Does any one know how to monitor semaphore usage in HPUX 11? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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).
Re: Semaphores
try: man ipcs to get details of the command. --Scott Kimberly Smith wrote: Does any one know how to monitor semaphore usage in HPUX 11? _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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).
Semaphores
Oracle Financials 11i asks for 14000 semaphores: When I do the calculation as per the Oracle Guide I come to about 1000. Anybody know why the disparate nature of these numbers. Can semaphores be set to such high levels. I can RTFM, but wonder what lists comments are before Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts 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).
Fantastic Information on Sun Semaphores
My sys admin found the following document on a Sun Bulletin Board. It is by far the most comprehensive writeup I've seen on the topic. File this one away. It'll come in helpful sometime. Enjoy, Cherie Machler Gelco Information Network INFODOC ID: 2270 SYNOPSIS: Understanding semaphores, seminfo_ semaphore info DETAIL DESCRIPTION: The Solaris 2.X kernel comes configured with defaults for semaphore parameters which may not be large enough for certain applications. Care is warranted in altering them, as these changes will effect any program which makes semaphore system service calls. This document provides the default and maximum values for the semaphore tunable parameters, and supplies a description of each of them. In most cases, the listed maxima is the largest value which will fit in the data type of the parameter; they are not intended as suggested settings. Specific maxima can not be provided in a general document, as they are dependant upon the hardware resources available on the system being tuned, and on the application(s) making use of them. Some parameters list more than one value in the 'Max' column. This indicates that the maximum value for the tunable parameter does not match the maximum value which is supported by other elements of the system. In these instances, the first number is the limit imposed by the parameter data type, while the second number is the limit imposed by the parameters usage; where supplied, the usage value must be considered the upper limit for tuning. Unless otherwise noted, setting a parameter to a value larger than the specified usage limit will not return an error, but will result in indeterministic behavior. NameDefault Max Brief Description -- --- -- - semmap 10 2147483647 Number of entries in semaphore map semmni 10 65535 Number of semaphore sets (identifiers) semmns 60 2147483647 Number of semaphores in the system 65535 (usage) semmnu 30 2147483647 Number of "undo" structures in the system semmsl 25 2147483647 Max number of semaphores, per semaphore id 65535 (usage) semopm 10 2147483647 Max number of operations, per semaphore call semume 10 2147483647 Max number of "undo" entries, per process semusz 96 *see below* Size in bytes of "undo" structure semvmx 32767 2147483647 Semaphore maximum value 65535 (usage) semaem 16384 2147483647 Adjust on exit maximum value 32767 (usage) Detailed Descriptions - semmap Defines the size of the semaphore resource map; each block of available, contiguous semaphores requires one entry in this map. This is the pool from which semget(2) acquires semaphore sets. When a semaphore set is removed (deleted), if the block of semaphores to be freed is adjacent to a block of semaphores already in the resource map, the semaphores in the set being removed are added to the existing map entry; no new map entry is required. If the semaphores in the removed set are not adjacent to those in an existing map entry, then a new map entry is required to track these semaphores; if there are no more map entries available, the system has to discard an entry, 'permanently' losing a block of semaphores (permanence is relative; a reboot fixes the problem). If this should occur, a WARNING will be generated, the text of which will be something like "rmallocmap: rmap overflow, lost ...". The end result is that a user could later get ENOSPC errors from semget(2) even though it doesn't look like all the semaphores are allocated. semmni Defines the number of semaphore sets (identifiers), system wide. Every semaphore set in the system has a unique indentifier and control structure. The system pre-allocates kernel memory for semmni control structures; each control structure is 84 bytes. If no more identifiers are available, semget(2) returns ENOSPC. Attempting to set semmni to a value greater than 65535 will result in generation of a WARNING, and the value will be set to 65535. semmns Defines the number of semaphores in the system; 16 bytes of kernel memory is pre-allocated for each semaphores. If there is not a large enough block of contiguous semaphores in the resource map (see semmap) to satisfy the request, semget(2) returns ENOSPC. Fragmentation of the semaphore map will result in ENOSPC errors, even though there may appear to be ample free semaphores. Despite attempts by the system to merge free sets (see semmap), the size of the clusters of free semaphores generally decreases over time. For this reason, semmns frequently must be set higher than the actual number of semaphores required. semmnu Defines the number of semaphore undo structures in the system. semusz (see below) bytes of kernel memory a
RE: What parameters affect the relationship between semaphores and
Hi Cherie, You may not have exited from the session that was used to shutdown one of those database. If so, the corresponding IPC resources would remain marked for deletion, but not yet free for reuse. Another possible explanation is that on some platforms the semaphores need to be allocated contiguously in a single semaphore set. That is why my book says, "If the semaphore clients are not always shut down and started up in strict sequence, then an extra allowance at least equal to the largest single requirement is recommended." @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Thursday, 15 February 2001 6:56 To: Multiple recipients of list ORACLE-L I was under the impression that you need at least one semaphore per process. On one of our boxes, we are short of semaphores. We took down one 7.3.4 database with 200 processes, and two 8.1.5 databases with 100 processes each and temporarily bumped up the number of processes in the QA database by 400. At that point, we were unable to start up the QA database due to a shortage of semaphores. Why is it that we could distribute those 400 processes among four databases and they would all come up at once but when I consolidated them in a single database, it would not come up? I figure it must be a difference in the init.ora file of the QA database. What things might affect the ratio between processes and semaphores. Short of increasing the semaphores in /etc/system and bouncing the box (which is not a great option), what else might we try tweaking in the QA database to enable it to come up in the current operating system environment. Thanks in advance, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams 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).