Solved

AIX TL SP and oracle memory

Posted on 2014-02-14
4
1,026 Views
Last Modified: 2014-02-15
We had a severe memory issues in one of our Oracle prod servers(7.1 ),which we could not reproduce in another lpar(7.1 ) with higher oslevel.
we were wondering if we can list the difference(not sure what what is it called in AIX packs,TL's,SP's) and look which ones are related to memory issues with oracle or any RDBMS.

about the 2 lpras

1st lpar prod with lower oslevel that had sever memory issues when memory increased from
150 Gb to 300 and Oracle SGA from 60 to 160 GB.

lslpp -l bos.mp64
  Fileset                      Level  State      Description        
  ----------------------------------------------------------------------------
Path: /usr/lib/objrepos
  bos.mp64                   7.1.0.2  COMMITTED  Base Operating System 64-bit
                                                 Multiprocessor Runtime

Path: /etc/objrepos
  bos.mp64                   7.1.0.2  COMMITTED  Base Operating System 64-bit
                                                 Multiprocessor Runtime



oslevel -sq
Known Service Packs
-------------------
7100-00-03-1115
7100-00-02-1041
7100-00-01-1037
7100-00-00-0000
=======================================================================
2nd lpar with higher Oslevel that we could not reproduce issue

lslpp -l bos.mp64
  Fileset                      Level  State      Description        
  ----------------------------------------------------------------------------
Path: /usr/lib/objrepos
  bos.mp64                  7.1.2.16  COMMITTED  Base Operating System 64-bit
                                                 Multiprocessor Runtime

Path: /etc/objrepos
  bos.mp64                  7.1.2.16  COMMITTED  Base Operating System 64-bit
                                                 Multiprocessor Runtime

oslevel -sq
Known Service Packs
-------------------
7100-02-03-1334
7100-02-02-1316
7100-02-01-1245
7100-02-00-0000
7100-01-08-1334
7100-01-07-1316
7100-01-06-1241
7100-01-05-1228
7100-01-04-1216
7100-01-03-1207
7100-01-02-1150
7100-01-01-1141
7100-00-10-1334
7100-00-09-1316
7100-00-08-1241
7100-00-07-1228
7100-00-06-1216
7100-00-05-1207
7100-00-04-1140
7100-00-03-1115
7100-00-02-1041
7100-00-01-1037
0
Comment
Question by:it-rex
  • 2
  • 2
4 Comments
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 39861290
It doesn't make any sense to search for filesets which might be responsible for such issues!

What if we really found them (which I doubt)?

You generally cannot simply uninstall or install a single fileset upgrade!
(Well, sometimes it's possible, but only with filesets without or with only few dependencies - those are very, very rare.)

Instead of wasting time with useless detective work rather take care to bring your systems to a good, complete, preferrably recent service level (see or other case)!

FYI:

You can list installed fileset updates pertaining to a certain service pack (e.g. 7100-02-01-1245) with

instfix -ick  71-02-011245_SP

No filesets displayed: Level skipped or not installed. If installed you'll see 85-100 filesets.

To list installed fileset updates pertaining to a certain technology level (e.g. 7100-02):

instfix -ick 7100-02_AIX_ML

No filesets displayed: Level not installed. If installed you'll see 405-600 filesets.

You can imagine that it won't be much fun searching through all these to find out which one might be responsible for Oracle memory issues.

By the way, does

vmo -aF

show the same on both LPARs? Please compare!
0
 
LVL 11

Author Comment

by:it-rex
ID: 39861734
I agree .no intention to install or install single file updates or anything like that..
We just needed to know if for a specific level of higher OS level there is a like an IBM description of fixed issues to memory and what not that is all...
Of course if it is possible..
I will seek vmo comparison soon
0
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 500 total points
ID: 39861875
If you still have the downloaded filesets which belong to a certain TL or SP all in one directory (repository) you can run

inutoc /path/to/repository
instfix -T -d /path/to/repository


to display the entire list of fixes present on the media. You will see the APAR numbers along with their descriptions.

The above works for single filesets too. Example:

instfix -T -d /path/to/repository/bos.mp64.7.1.1.1.U

Sample output:
IV00151 incorrect trusted execution kernel flag checks
IV00177 Potential security issue.
IV00178 Fix cpu time issue during WPAR mobility
IV00182 Crash at evm_ldcw
IV00210 PAGING 4K PAGES BECAUSE OF LACK OF 64K PAGE DEMOTIONS
IV00218 kdb wp command shows signed decimal cant_chkpt field
IV00565 Unable to set frag_mask using errctrl
IV00573 PANIC OCCURS IF NFS CLIENT RUN "AUDIT SHUTDOWN" WHEN SERVER DOWN
IV00574 system crash while enabling domain RBAC
IV00588 System crash in procfsGetattrCwdRoot
IV00857 crash at abend_trap
...
...
If you don't have the downloaded stuff anymore or if you want to list fixes before downloading use Fix Central.

https://www-933.ibm.com/support/fixcentral/

Select Product Group: IBM Operating Systems, select from IBM Operating Systems: AIX, select Version: 7.1, select Function: Fix Packs, click Continue.

Scroll down to the desired Service Pack or Technology Level and click "Fix Details".

You'll see the paragraphs "New Enhancement APARs", "New security APARs", "New High Impact for Highly Pervasive APARs", "New APARs resolving PEs" (PE = PTF in Error) and "All Other New APARs"

Sample output (7.1 TL 3 SP 1):
IV50175        Add binaries to break disk reservation to minimal spot
IV50834       Missing posting event to head driver after log in.
IV50836       AIX diagnostics command line download previous microcode fails
IV50869       Add sissasraidmgr to the minimal SPOT
IV51300       REMOVE LDAP SERVICES OPTION FROM /ETC/NETSVC.CONF
IV51318       Add binaries to break disk reservation to minimal spot
IV51319       WPAR mobility not supported with multiple_semid_lists enabled
IV51470       Usability problems in savesecconf command.
IV51483       No RDMA traffic after EEH error
IV51485       old systems with small memory configs may fail to boot
...
...
...
In any case it's a lot of output. Have fun!
0
 
LVL 11

Author Closing Comment

by:it-rex
ID: 39861904
Thank you
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

A metadevice consists of one or more devices (slices). It can be expanded by adding slices. Then, it can be grown to fill a larger space while the file system is in use. However, not all UNIX file systems (UFS) can be expanded this way. The conca…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now