Skip to Content
avatar image
Former Member

SAP on Oracle RAC 12c - How to idle connections?!

Hello experts,

i have a question ragarding SAP on Oracle RAC 12c with idle connections.

Actual configuration:

We have a SAP Netweaver 7.4 SPS 15 installation (BW/BI) on linux X86 64 bit running with an 12c Oracle Database with two members on an Oracle ExaData. We have two application servers. The first is connected with an service to the first RAC member and the second application server is connected with an service to the second RAC member.

Question:

If we have maintance, for example one RAC member gets new OS updates or patches, i would like to switch the server to other member which is still running. The switch works without any problems, but the connections are still active over a long time to the server which needs to get maintance. And because of this, we got problems with the application because the status is not correct.

Any ideas what i need to do to idle the connections after a specific time frame?! Are there any parameters for in the SAP system?!

Regards,

Sascha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 19, 2017 at 01:35 AM

    Dear Sascha,

    This looks like a integration issue not a pure db or sap issue.

    Can you attach several dev_w* traces? Those traces will show what happened on db connection.


    Also how did you switch SAP app from one node to another note?

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2017 at 05:11 AM

    Hi Sascha,

    Are you saying that the work process still trying to connect the the RAC node which was in maintenance mode? If that's the case, you may try to change the Oracle connection profile tnsname.ora on SAP application server and add the timeout parameters for example:

    (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)

    Regards,

    Michael

    Add comment
    10|10000 characters needed characters exceeded