Home > Default > SAP SRM Prod with Oracle DB and AIX 5.3 Performance Issue.

SAP SRM Prod with Oracle DB and AIX 5.3 Performance Issue.

October 11Hits:0
Advertisement
Hi Basis Gurus,
Today my SAP PRD system all of a sudden was running slow and users had difficulties executing TCodes as it took minutes before the screen appeared.My system is SAP SRM 4.00, Oracle Release 11.2.0.1.0 and AIX 5.3.
From Basis point of view , we noticed that all the work process were hanged due to RFCs' occupying it.Couldnt investigate further on the system as we needed to restart asap because users needed to log on. A quick check on SICK shows no errors.What we managed to find out is that we needed to check this parameter below and set it accordingly:-
rdisp/rfc_min_wait_dia_wp:-
Definition
Number of work processes kept free for other users.
Use
This parameter is used to reserve a number of dialog work processes for dialog mode. It prevents parallel RFCs from occupying all the processes.
The parameter rdisp/wp_no_dia specifies the absolute number of dialog work processes.                               
Unit: number of dialog work processes
Default value: 1
Example
If 10 dialog work processes are configured for the instance (rdisp/wp_no_dia = 10) and the parameter rdisp/rfc_min_wait_dia_wp  = 3 is set, parallel RFCs can occupy a maximun of 7 dialog work processes. Three dialog work processes always remain free for dialog mode.
There are 20 DIA processes in our system, perhaps reserving a minimum of about 5 work processes for DIA users will be useful via the parameter.
So my first question would be is there any other suggestions besides adjusting the mentioned parameter above in order to ensure that no work processors going into hang state due to RFCs' occupying it as this issue always happens at the end of the month only when there are massive users accessing it.
When we went for a restart of the system we encountered another issue. Steps to the issue are as below:-
1) Did a proper shutdown of Oracle and SAP.
2) When we start using startsap script, it doesn't start DB so we started DB manually but listener was having problem
    so we stopped all.
3) We also did a cleanipc, it too throws below error:-
sidadm> cleanipc <systemno> remove
               exec(): 0509-036 Cannot load program cleanipc because of the following errors:
               0509-130 Symbol resolution failed for cleanipc because:
               0509-136   Symbol memmove (number 106) is not exported from
               dependent module /usr/sap/sid/SYS/exe/run/libsapu16.so.
               0509-192 Examine .loader section symbols with the
               'dump -Tv' command.
4) Also the Listener file has no contents,it's null file.
5) This is another error :-
    exec(): 0509-036 Cannot load program /oracle/sid/112_64/bin/tnslsnr because of the following errors:
    0509-150   Dependent module /oracle/sid/112_64/lib/libttsh11.so could not be loaded.
    0509-101   The module has too many section headers
    or the file is damaged
The libttsh11.so file was empty dated 25th timestamp as below in PRD:-
-rw-rr    1 sid   dba               0 Nov 25 07:12 libttsh11.so
Further checking has let me to understand this is an Oracle Bug from this link:-
http://gavinsoorma.com/2009/12/11-1-0-6-clusterware-upgrade-to-11-1-0-7/
This Oracle bug only happens in an Upgrade time and how could this happen to my Production system during a restart process.
Also this system was restarted during the last weekend's maintainance window and it came up with no issues.
6) We copied over the libttsh11.so from our QA environment to PRD and did a Startup:-
-rwxr-x---    1 sid   dba        65967496 Nov 25 07:40 libttsh11.so (This is the copied over file from QA)
7) After Startup everything has been in order till now.
My second question is what went wrong with the libttsh11.so file. How could it be 0 size in PRD when no signs of changes had happen to the PRD system. Is this a proven Oracle Bug or something else since I have never encountered anything like this before. Hope all the Gurus here could shed some light into my 2 questions as I am looking for positive answers.
Thank you.
Regards,
John

Answers

Hi,
Firstly I would suggest you to upgrade your database from Oracle Release 11.2.0.1.0 to Oracle Release 11.2.0.2 . This is the recommended Oracle 11g database versionĀ  for SAP solutions. Many of your problem will get resolved with it.
Question 1:
So my first question would be is there any other suggestions besides adjusting the mentioned parameter above in order to ensure that no work processors going into hang state due to RFCs' occupying it as this issue always happens at the end of the month only when there are massive users accessing it.
For immediate resolution the approach you have followed is correct viz limiting number of dialog processes for RFC. Secondly you need to analyze why RFC processing takes so much time. You need check which programs are getting executed by those RFC.
Generate EarlyWatch report for more detailed view
Question 2:
My second question is what went wrong with the libttsh11.so file. How could it be 0 size in PRD when no signs of changes had happen to the PRD system. Is this a proven Oracle Bug or something else since I have never encountered anything like this before.
The libttsh11.so library cannot be found in the related directory.
Cause
The file system is mounted using CIO option, but per Note 257338.1 Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5L, an ORACLE_HOME on a filesystem mounted with "cio" option is not supported.
Such a configuration will cause, installation, relinking and other unexpected problems.
Solution
Disable the CIO option on the filesystem.
References
NOTE:257338.1 - Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5L
Hope this helps.
Regards,
Deepak Kori

Read other 3 answers

Tags:

Related Articles

  • SAP SRM Prod with Oracle DB and AIX 5.3 Performance Issue.October 11

    Hi Basis Gurus, Today my SAP PRD system all of a sudden was running slow and users had difficulties executing TCodes as it took minutes before the screen appeared.My system is SAP SRM 4.00, Oracle Release 11.2.0.1.0 and AIX 5.3. From Basis point of v

  • Oracle BPM 11.1.1.5 Performance issuesOctober 11

    Hi, I have 2 Node Cluster of Oracle SOA 11.1.1.5 installed. Have a separate cluster for SOA/BPM, BAM, OSB, WSM. Here are the OS and Java versions Java Vendor: HP Java Version: 1.6.0.14 OS: HP-UX OS Version: B.11.31 Running into an issue where Oracle

  • Database migrated from Oracle 10g to 11g Discoverer report performance issuOctober 11

    Hi All, We are now getting issue in Discoverer Report performance as the report is keep on running when database got upgrade from 10g to 11g. In database 10g the report is working fine but the same report is not working fine in 11g. The query i have

  • Oracle DRM 11.1.2.2 performance issueNovember 30

    Hi, Is there any guide to fine tune DRM performance for version 11.1.2.2.302? We are running a project DRM from version 9.3.1 to version 11.1.2.2, and we found performance issue with 11.1.2.2, which a data import that previously run under 2 hours in

  • SAP SRM UI (NXP) - Work Processes remain runningNovember 30

    Background: Shopping carts are being processed through the new SAP SRM UI (NXP). On occasion, dialog Work Processes are left in 'running' status even when there is nothing happening in the front end. It occurs for many standard programs, but when che

  • Vendor Master can not replicate from SAP R3 to SAP SRM system.October 11

    Hi All, We face one issue when we use bbpgetvd program to transfer Vendor master from SAP R3 to SAP SRM, after I check Analysis Application log, found the following issue: Error: No Bank Master Data Maintained No Bank Data Transferred Error: Name/Add

  • Oracle installation on aixOctober 11

    hello, i am on a project where i need to install oracle 10gr2 on aix 6.1. the issue i am looking at right now is this we already install oracle 10gr2 the server using a particular partition now i want to install oracle 10gr2 on the same server but a

  • Performance issue with view selection after migration from oracle to MaxDbNovember 30

    Hello, After the migration from oracle to MaxDb we have serious performance issues with a lot of our tableview selections. Does anybody know about this problem and how to solve it ?? Best regards !!! Gert-JanHello Gert-Jan, most probably you need add

  • Oracle waveset integration with SAP SRMNovember 30

    Hi All, We are planning to integrate oracle waveset8.1.1.5 to SAP SRM. Can some one please provide me the process of this integration. Thanks in advance........ClosedRead other 2 answers

  • Query on components to be used for SAP SRM InstallationOctober 11

    We have a requirement for SRM Server.. I need some help on what installation objects should I download. This is on AIX and DB2 for "EHP1 FOR SAP SRM 7.0 -> based on SAP NetWeaver 7.02" I'm sure that I'll need : 1) Installation Master 2) Expor

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.542 s.