AIX TL SP and oracle memory

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
LVL 11
it-rexAsked:
Who is Participating?
 
woolmilkporcCommented:
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
 
woolmilkporcCommented:
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
 
it-rexAuthor Commented:
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
 
it-rexAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.