cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Data server connection error

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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