Skip to Main Content

ODP.NET

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!

Connection request timed out when Network is disconnected

2833962Jan 7 2015 — edited Jan 8 2015

HI ALL,

I'm having trouble on Access to the oarcle database with odp.net.  the connection strings is as follows:

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=filesynctest2)(PORT=1521))(CONNECT_DATA=(SID=filesync1)));User Id=xjliu;Password=111111; Max Pool Size=10; Min Pool Size=1;

My program and database are on different machines,  and works ok.

but when network is disconnected, there are errors as follows:

ORA-12545: Connect failed because target host or object does not exist

Connection request timed out

Connection request timed out

Connection request timed out

...

when the network back to normal, the errors go on, and can‘t recovery itself, until i restart the program.

i use OracleConnection.ClearAllPools(), but it dose not work

can someboby help me?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2015
Added on Jan 7 2015
1 comment
1,019 views