- You are using Smart Data Access (SDA) to connect HANA to an Oracle remote data source.
- You are using Smart Data Access (SDA) to connect HANA to remote SQL Server database.
- The database connections opened by HANA in the Oracle remote data source remain inactive after query execution and never close.
- The following error can be observed in both Oracle and the HANA indexserver trace file:
[unixODBC][Oracle][ODBC][Ora]ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
SAP HANA Database (Revision/SPS independent)
SDA, Oracle, remote_conn_idle_timeout, ORA-02391, SESSIONS_PER_USER , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.