Re: Oracle AIX problem
Date: Tue, 24 Jun 2014 08:37:09 -0500
Message-ID: <CAJvnOJZdjnkzN6WqGpPABzkhnG4sEAO72EZW9BMrKfkUek_onA_at_mail.gmail.com>
There is an oracle bug that causes this, I ran into recently. I will see if I can find the number.
On Tue, Jun 24, 2014 at 8:04 AM, Deas, Scott <Scott.Deas_at_lfg.com> wrote:
> Tiran,
>
>
>
> Maybe I’m misreading your lsps output, but it doesn’t look like your swap
> space is actually being utilized (unless that output is from a time when
> the database is not running).
>
>
>
> Have you reviewed the documentation from Oracle for installing 11.2 on
> AIX, specifically, I’m wondering if your oracle user has access to the
> memory that’s been allocated on the system -
> http://docs.oracle.com/cd/E11882_01/install.112/e48740/pre_install.htm#AXDBI1184.
> We have had issues where the ulimit has not been set correctly, but we did
> not see the exact issue you’re describing. Here’s a doc from IBM on
> checking the ulimit values:
> http://publib.boulder.ibm.com/tividd/td/ITAME/SC32-1351-00/en_US/HTML/am51_perftune35.htm.
>
>
>
>
> Also, could you verify with nmon that the system is actually swapping, and
> that it’s not just the database that’s perceiving this issue?
>
>
>
> Thanks,
> Scott
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Outsider
> *Sent:* Tuesday, June 24, 2014 6:23 AM
> *To:* Oracle L
> *Subject:* Oracle AIX problem
>
>
>
> Hi Oracle - AIX experts,
>
>
>
> I am in very difficult situation. We have AIX 7.1 TL3SP1 server in
> PureFlex hardware. On this AIX we have Oracle DB 11.2.0.4.0. DB works as
> expected after startup and suddenly it goes crazy. No one can connect to
> this DB from application and there is a lot of error in alert log and also
> in AIX. So this is heavy swapping problem which I had previously in Oracle
> Linux , in that case we added memory and swap[ file also we had problem
> with low disks (actually the problem was problematic disks). Here we have
> 8G memory and 16G page space and disks also OK. The only thing in which I
> am not sure the configuration of page spaces. But I am not AIX
> specialist....
>
>
>
> Please who have same experience with this , please advise how can we solve
> this.
>
>
>
> root_at_sgp-podb201a/ # lsps -a
>
> Page Space Physical Volume Volume Group Size %Used Active Auto
> Type Chksum
>
> paging01 hdisk6 vg01 8192MB
> 1 yes yes lv 0
>
> paging00 hdisk1 vg01 8192MB
> 4 yes yes lv 0
>
> hd6 hdisk0 rootvg 512MB
> 0 no no lv 0
>
>
>
> Info
>
> MEMORY
>
> Real,MB 8192
>
> % Comp 64
>
> % Noncomp 16
>
> % Client 16
>
>
>
> PAGING SPACE
>
> Size,MB 16384
>
> % Used 2
>
> % Free 98
>
>
>
> PAGING
>
> Faults 25
>
> Steals 0
>
> PgspIn 0
>
> PgspOut 0
>
> PageIn 0
>
> PageOut 15
>
> Sios 15
>
>
>
> Alert log
>
>
>
> Tue Jun 24 08:20:32 2014
>
> WARNING: Heavy swapping observed on system in last 5 mins.
>
> pct of memory swapped in [359.98%] pct of memory swapped out [0.87%].
>
> Please make sure there is no memory pressure and the SGA and PGA
>
> are configured correctly. Look at DBRM trace file for more details.
>
> Tue Jun 24 08:37:52 2014
>
> Emon ping encountered error 4021
>
> Errors in file
> /opt/oracle/diag/rdbms/shpsgpp1dg1/SHPSGPP1/trace/SHPSGPP1_q000_20185316.trc:
>
> ORA-04021: timeout occurred while waiting to lock object
>
> Tue Jun 24 09:00:53 2014
>
> Emon ping encountered error 4021
>
> *******
>
> ORA-04021: timeout occurred while waiting to lock object
>
> Tue Jun 24 12:35:16 2014
>
> Emon timeout encountered error 4021
>
> Tue Jun 24 12:35:16 2014
>
> Emon timeout encountered error 4021
>
> **********
>
>
>
> Oracle trace file
>
>
>
> *** 2014-06-24 13:13:31.648
>
> *** SESSION ID:(478.11) 2014-06-24 13:13:31.648
>
> *** CLIENT ID:() 2014-06-24 13:13:31.648
>
> *** SERVICE NAME:(SYS$BACKGROUND) 2014-06-24 13:13:31.648
>
> *** MODULE NAME:(Streams) 2014-06-24 13:13:31.648
>
> *** ACTION NAME:(QMON Slave) 2014-06-24 13:13:31.648
>
>
>
> KSV 4021 error in slave process
>
>
>
> *** 2014-06-24 13:13:31.648
>
> ORA-04021: timeout occurred while waiting to lock object
>
> OPIRIP: Uncaught error 447. Error stack:
>
> ORA-00447: fatal error in background process
>
> ORA-04021: timeout occurred while waiting to lock object
>
>
>
>
>
> Thanks in advance.
>
>
>
>
>
> *-----------------*
>
> *Tiran*
>
>
> *Best Regards Stay in touch...*
>
> Notice of Confidentiality: **This E-mail and any of its attachments may
> contain
> Lincoln National Corporation proprietary information, which is privileged,
> confidential,
> or subject to copyright belonging to the Lincoln National Corporation
> family of
> companies. This E-mail is intended solely for the use of the individual or
> entity to
> which it is addressed. If you are not the intended recipient of this
> E-mail, you are
> hereby notified that any dissemination, distribution, copying, or action
> taken in
> relation to the contents of and attachments to this E-mail is strictly
> prohibited
> and may be unlawful. If you have received this E-mail in error, please
> notify the
> sender immediately and permanently delete the original and any copy of
> this E-mail
> and any printout. Thank You.**
>
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 24 2014 - 15:37:09 CEST