Re: Oracle 7.2.3 lock problem on AIX 4.1.5
From: Joel Garry <joelga_at_pebble.ml.org>
Date: 1998/03/11
Message-ID: <6e7416$ig5$1_at_pebble.ml.org>#1/1
>We have been running Oracle 7.2.3 on AIX 4.1.5 in a stable state for
>some time. We are running an HA system on concurrent SSA disk. There
>are two G40 machines in the cluster. Last Friday we upgraded both
>machines from 512Mb memory to 1Gb. At the same time the Oracle
>attribute db_block_buffers was increased from 9000 to 27000. The number
>of Oracle locks remained the same but the distribution of the locks was
>changed. In the last 3 days Oracle has been crashing regularily (but
>not predictably) with the following error:
>
>> Dump file /home/oracle/admin/TRNG/bdump/lck0_24316.trc
>> Oracle7 Server Release 7.2.3.0.0 - Production Release
>> With the Parallel Server option
>> PL/SQL Release 2.2.3.0.0 - Production
>> ORACLE_HOME = /home/oracle/product/live
>> ORACLE_SID = TRNG1
>> Oracle process number: 8 Unix process id: 24316
>> System name: AIX
>> Node name:
>> Release: 1
>> Version: 4
>> Machine:
>>
>> Tue Mar 10 08:18:12 1998
>> *** SESSION ID:(8.1) 1998.03.10.08.18.12.000
>> error 50 detected in background process
>> OPIRIP: Uncaught error 447. Error stack:
>> ORA-00447: fatal error in background process
>> ORA-00050: O/S error occurred while obtaining an enqueue. See o/s
>error.
>
>We have placed calls with IBM and Oracle support. Oracle suggested to
>us that the problem is a "file table overflow" with the fix being to
>increase the number of locks, resources or processes for DLM. Your
>assistance in determining the contentious "resource" is greatly
>appreciated.
>
Date: 1998/03/11
Message-ID: <6e7416$ig5$1_at_pebble.ml.org>#1/1
In article <350622B5.4C36C8C7_at_burnt-sand.com>, Randal Kornelsen <rkornelsen_at_burnt-sand.com> wrote:
>We have been running Oracle 7.2.3 on AIX 4.1.5 in a stable state for
>some time. We are running an HA system on concurrent SSA disk. There
>are two G40 machines in the cluster. Last Friday we upgraded both
>machines from 512Mb memory to 1Gb. At the same time the Oracle
>attribute db_block_buffers was increased from 9000 to 27000. The number
>of Oracle locks remained the same but the distribution of the locks was
>changed. In the last 3 days Oracle has been crashing regularily (but
>not predictably) with the following error:
>
>> Dump file /home/oracle/admin/TRNG/bdump/lck0_24316.trc
>> Oracle7 Server Release 7.2.3.0.0 - Production Release
>> With the Parallel Server option
>> PL/SQL Release 2.2.3.0.0 - Production
>> ORACLE_HOME = /home/oracle/product/live
>> ORACLE_SID = TRNG1
>> Oracle process number: 8 Unix process id: 24316
>> System name: AIX
>> Node name:
>> Release: 1
>> Version: 4
>> Machine:
>>
>> Tue Mar 10 08:18:12 1998
>> *** SESSION ID:(8.1) 1998.03.10.08.18.12.000
>> error 50 detected in background process
>> OPIRIP: Uncaught error 447. Error stack:
>> ORA-00447: fatal error in background process
>> ORA-00050: O/S error occurred while obtaining an enqueue. See o/s
>error.
>
>We have placed calls with IBM and Oracle support. Oracle suggested to
>us that the problem is a "file table overflow" with the fix being to
>increase the number of locks, resources or processes for DLM. Your
>assistance in determining the contentious "resource" is greatly
>appreciated.
>
I no longer have access to AIX stuff, but I believe you should check your
installation guide for guidelines to setting shared memory and semaphore
kernel parameters. The file table they are referring to I believe is the
table that keeps queues straight - do a man ipcs. You may be running
out of message queues, count the number of lines ipcs -q gives you and
compare to the kernel parameters that start with SH and SE.
>thankyou,
>Randal
>--
>Randal Kornelsen email: rkornelsen_at_burnt-sand.com
>UNIX System Administrator phone: (403) 231-6264
>Burnt Sand Solutions Inc. FAX: (403) 290-0060
> web: www.burnt-sand.com
>
-- These opinions are my own and not necessarily those of Information Quest jgarry_at_eiq.com http://www.informationquest.com http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the _at_#%*& DBA!Received on Wed Mar 11 1998 - 00:00:00 CET