469,278 Members | 2,318 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,278 developers. It's quick & easy.

Timed Out Error in Oracle.

Vini171285
Hi,
In my project,i have created a database in Oracle..
but the problem is ,now it is showing Timed Out Error..
Can anyone tell exactly what the problem is??
and how it can be solved??
Also when this error occurs programs doesnt't run and i cant even open the database..
Should i have to create the database again??
Thanx..
May 21 '08 #1
6 4954
debasisdas
8,127 Expert 4TB
please post the exact error number with error message.
May 22 '08 #2
Hi,

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12535: TNS:operation timed out
/indent1/FirstPage.asp, line 347

This is the error :timed out
Please Help

Thanx !!
Jun 10 '08 #3
vikas251074
198 100+
I think your processing takes longer than the session time set for processing. Increase the session time. But check this code in SQL editor, how long it takes?

Thanks and regards,
Vikas
Jun 10 '08 #4
r035198x
13,262 8TB
Hi,

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12535: TNS:operation timed out
/indent1/FirstPage.asp, line 347

This is the error :timed out
Please Help

Thanx !!
What's the output of
Expand|Select|Wrap|Line Numbers
  1. tnsping <databasename> 
?
Also is there any error displayed in SQLNET.log?
Jun 10 '08 #5
Hi,
We have not set any value for Session Timeout.
and can you please tell where to check the sqlnet log..
and what this sqlnet log is??
Thanx..
Jun 11 '08 #6
r035198x
13,262 8TB
Hi,
We have not set any value for Session Timeout.
and can you please tell where to check the sqlnet log..
and what this sqlnet log is??
Thanx..
Mine is in $ORACLE_HOME/network/log/
You can search for it on your computer. Don't forget to post the output of the tnsping command above.
Jun 11 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by David | last post: by
2 posts views Thread by William F. Robertson, Jr. | last post: by
5 posts views Thread by Sachin Surana | last post: by
6 posts views Thread by Daniel Walzenbach | last post: by
10 posts views Thread by Jim Underwood | last post: by
3 posts views Thread by nms | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.