ora-2396 exceeded maximum idle time, please connect again

Question

Hi All,

We have Setup a transactional replication from SQL server 2014 to Oracle. Configured the oracle network client and are able to connect  to oracle and query it, even the transactional replication works fine, however after some time if the oracle login (through which we have configured the subscriber) remains idle then the  connection get's timed out and it generates the above specified error and the replication fails.

Any help would be appreciated.

Thanks.

Answer 1

Hello,

I have seen so many issues related to the version of Oracle client, that my first suggestion cannot be other but to try a previous version or a newer version of the Oracle client, and drop the publication create it again.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Can you check the below values?

SQL> SELECT PROFILE FROM DBA_USERS WHERE USERNAME = 'xyz';

PROFILE
------------------------------
UNLIMITED_PROFILE

SQL> SELECT PROFILE, LIMIT FROM DBA_PROFILES WHERE RESOURCE_NAME = 'IDLE_TIME';

PROFILE                        LIMIT
------------------------------ ----------------------------------------
DEFAULT                        90
UNLIMITED_PROFILE              UNLIMITED

Refer the below link for more information

http://docs.oracle.com/html/A85397_01/statem13.htm

--Prashanth

Answer 3

Getting error table or view does not exists.. may be due to sysadmin privilege??

Answer 4

Please have a look at this link: 

ORA-2396 | Oracle Community - Oracle Technology Network

---

Saeid Hasani [sqldevelop]

Answer 5

Thanks, Prashant.  I checked with ORA DBA and found that the IDLE_TIME is set to 540 that is 9 hours.

Regards,

Ashif Shaikh

---

aa