Load Testing - Database Failover in MSCS - User sessions terminated

[Former Member]

Hi,

We are using MSCS architecture with NW 7.0 and Oracle 10.2.0.2 database.During our load testing. During load testing (batch process, dialog and

commit process) our database failed over to other node. Database came upwithin 30-45 second but all the dialog user sessions got disconnected. We are concerned about user sessions were disconnected.

I came across following two notes which exactly refers our problem.

72025 Error 024 on missing database link

24806 Database Reconnect: technical details and settings

I would like to know recommended value for profile parameter for NW 7.0 and Oracle 10.2.0.2 in MSCS environment. The profile parameters are :

rsdb/reco_trials

rsdb/reco_sleep_time

rsdb/reco_add_error_codes

Please do needful.

Thanks,

Miral

[Former Member]

Hi Miral,

Thanks for the reply,

I just brief about my setup.

We have 2 nodes with SAP Installed, with SMCS Cluster.

Software:

SAP ECC 6.0 SR2

Oracle 10g

Windows 2003 SP2.

Clusterd Instances:

1. ASCS(Instance Number 00)

2. Database Instance

Node 1:

1. CI(Instance Number 01)

Node 2:

1. Dialog Instance(Instance Number 02)

We are trying to switchover from Node 1 to Node 2,

All groups all getting trabnsfered from Node 1 to Node 2,

but, the already logged in users, (connected with instance number 01)

are getting disconnected, error message is "sapdp01 is not avaiable".

Can we overcome this problem by configuring SMLG..?

one more thing,

all enqueue locks are getting shifted to 2nd node without any problmes,

ERS is also working properly.

Please help me to resolve my problem.

Regards,

Pradeep Chanda.

[Former Member]

Hello,

I am facing the same problem,

Could any body help me, if your problem is solved?

Pradeep Chanda.

[Former Member]

Pradeep:

SAP confirmed that increasing parameter will not have any impact. We have changed parameter rsdb/reco_trials to 10.

Please update same thread if it solves your problem,

Thanks,

Miral.

[Former Member]

Hi

I would suggest the following values

rsdb/reco_trials = 3

rsdb/reco_sleep_time = 5 (only ORACLE)

rsdb/reco_add_error_codes = 12500,12571

Also refer to http://www.saptechies.com/sap-system-under-microsoft-cluster-server-mscs/

It will be useful

Rohit

[Former Member]

Thanks Rohit. We have default settings. Our problem is by the time database failovers user sessions are getting disconnected. I tried increasing rsdb/reco_trials to 10 and it is not disconnecting connection but it is giving dump which is fine rather it disconnects session.

I would like to know what are the impacts if we increase this parameter.

Thanks,

Miral.