RE: Oracle AIX problem

From: Deas, Scott <Scott.Deas_at_lfg.com>
Date: Tue, 24 Jun 2014 13:04:10 +0000
Message-ID: <C1FB7BA65B13C542B2CB1CE5DB8F74AF16A0D191_at_NC2PWEX501.us.ad.lfg.com>

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.**

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 24 2014 - 15:04:10 CEST