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

[Former Member]

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

[former_member205280]

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

[JamesZ]

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