0 Replies Latest reply: Dec 16, 2013 9:34 AM by 0da30ecb-5fd3-4a43-a7ed-cf446f09b3d2 RSS

    Frequent Disconnection of database.


      Hello friends,


      My job profile demands that i have to manage a database created by someone else.


      I have ten sun solaris servers and each one is holding two instances of databases.


      My problem is that one instance of database keeps getting disconnected after every 15 mins or so.


      I have done the following


      1. tnsping ----works fine.

      2. tnsnames.ora and listener.ora are correct.

      3. I am able to connect to the database using


      sqlplus /nolog

      connect control

      passwordword: control


      sql shows connected.


      4. The database runs smoothly for few mins and then gets disconnected throwing tns error. 12156


      Any suggestions,