473,323 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

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 5172
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

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

Similar topics

1
by: David | last post by:
Hi Below is a copy of the top 5 timed events from my statspack. Don't know how to detect what enqueue waited for what. Don't understand Oracle Documentation's description on how to check...
2
by: William F. Robertson, Jr. | last post by:
Some of my users are receiving an error: Server Error in '/' Application. ---------------------------------------------------------------------------- ---- Request timed out. Description: An...
0
by: Jack Wright | last post by:
Dear All, I have a web Application "http://localhost/Web/WebForm1.aspx" that calls a WebService from "http://localhost/webserviceapp/service1.asmx"...I have set the executionTimeout to 10 secs in...
5
by: Sachin Surana | last post by:
We use HttpWebRequest to send the request at a URL. But some times the method GetResponse throws a time out exception. But when we check the IIS logs, there is no such entry. So the request never...
6
by: Daniel Walzenbach | last post by:
Hi, I have a web application which sometimes throws an “out of memory” exception. To get an idea what happens I traced some values using performance monitor and got the following values (for...
4
by: Joe | last post by:
I'm hosting my web service on a Windows 2003 box which is remotely located. When trying to add a web reference to a C# project I get an error message 'There was an error downloading...
2
by: tlan | last post by:
Hi, I got this error when I move my web service to Windows2003 server. I spent hours scouting on the internet and could find any answer. Please help!!! I the webservice is timeout between 1...
10
by: Jim Underwood | last post by:
I am having a problem with my web page timng out while retrieving a long runnign report (90-120 seconds. I have tried modifying several settings in various places and cannot get it to run for more...
3
by: nms | last post by:
I've an ASP.net web site, Since last some days, Users are experiencing problem when they try to generate reports (for a large date range) it says, Request timed out. Description: An unhandled...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shllpp 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.