on 07-15-2009 8:10 AM
Hi,
we have problem in Data server connection with Oracle. Usually we have scheduled backup take and restart of SAP and Oracle server on every sunday night. After restarting Oracle service, data server in MII not connecting with Oracle server. we are usually reset the connection. It will affect the operation if someone working.
Is there any other way to do this automatically through transaction or code?
Regards,
Senthil
Senthil,
we are also using Oracle DBs. I have populated the field "ValidationQuery" in the data server definition of the Oracle DB with a SQL statement: "SELECT 'Validation' FROM dual". MII then automatically tries to reconnect to the DB if the connection is lost.
Have you set the field? If not, give it a try.
Regards
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.