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

    Frequent Disconnection of database.

    0da30ecb-5fd3-4a43-a7ed-cf446f09b3d2

      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,