Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALERT LOG - ORA-3136 AT 7:01 AM EVERYDAY [WARNING: inbound connection timed out (ORA-3136)]

Ran GNov 21 2013 — edited Nov 23 2013

Hello Techies,

Good day to you all.

I have a situation here in my oracle production databse environement. I see ORA-3136 error/warning every day occuring at the same time( i.e, 7:01AM ) and i do not have any scheduled jobs or tasks at that time.

May be some task which runs on my database trying to connect to DB and fails due to wrong credentials ? not sure how to find out as i tried to checkc the OS- Win task scheduler and Grid EM for any such tasks/jobs.

Even we have set, " INBOUND_CONNECT_TIMEOUT=120 " in the sqlnet.ora file to avoid inbound connection timeout errors, which we used to get a couple of months back and now we get ORA-3136 Warnings in the alert log since 10day(s) or more.

Environment- Version:

--------------------------------

OS - WINDOWS 2008R2 64 Bit

Oracle DB - 10G DB, 11G Oracle Grid configured.

Can you plz suggest me ways to trace and findout this.

Regards,

RanG.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2013

Added on Nov 21 2013

#audit, #connection, #error, #general-database-discussions, #issue

14 comments

3,798 views