Re: Oracle AIX problem

Thanks , not sure but can be ...... I will ask IBM to patch , I am not allowed to do that. I tried to grep with patch name with lslpp -l command but no result. So can I guess that the patch is not installed in this system ?

*-----------------*

*Best RegardsStay in touch...*

On 24 June 2014 15:44, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> No, the one I found is *1666458.1. *
>
> *Applies to:*
>
> Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.1
> [Release 11.2 to 12.1]
> IBM AIX on POWER Systems (64-bit)
>
>
>
> On Tue, Jun 24, 2014 at 8:42 AM, Outsider <mufc01666_at_gmail.com> wrote:
>
>> Hi Andrew,
>>
>> If you meant this 13443029 bug. Oracle support tell us that "this Bug
>> 13443029 is fixed in 11.2.0.4 and since you are already on AIX 7.1 TL03
>> SP01 your issue is a different issue."
>>
>> thanks
>>
>> *-----------------*
>> *Tiran*
>>
>> *Best RegardsStay in touch...*
>>
>>
>> On 24 June 2014 15:37, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
>>
>>> 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 RegardsStay 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.'
>>>
>>
>>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>

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