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
sql shows connected.
4. The database runs smoothly for few mins and then gets disconnected throwing tns error. 12156