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

[debasisdas]

please post the exact error number with error message.

[Vini171285]

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

[vikas251074]

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

[r035198x]

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

tnsping <databasename>

?
Also is there any error displayed in SQLNET.log?

[Vini171285]

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

[r035198x]

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.