Hi, My name is German and I'm using ODP.NET (Oracle Data Access Components (ODAC) 11.2.0.1.2) 32 bits with Visual Studio 2010 SP1. I am development a WCF and I'm connecting with a Oracle Database 10.2.0.5.0 and I'm pulishing it over IIS on Windows Server 2008 R2 64 bits.
Sometimes on production enviroment I catch the next error "ORA-01012: not logged on". When that happend I need reset my IIS to fix the problem and sometimes I need reset all computer.
The detail error is
Error detail:
Process ID: 0
Session ID: 217 Serial number: 25767
ORA-01012: not logged on
Process ID: 0
Session ID: 217 Serial number: 25767
What can be that ?. I don't have idea and the error happened sometimes.
I'm using this connectionstring
<add name="ConnectionStringGenerica" connectionString="DATA SOURCE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxxxxx)));USER ID=xxxxxxxr;Password=xxxxx;Min Pool Size=10;Max Pool Size=100;Connection Lifetime=120;Incr Pool Size=2;Decr Pool Size=10;" />
I checked the configuration server and the iddle time is infinite and connect time too.
The unique peculiarity on my production enviroment is that I have two WCF independent using the same user and the same conectionstring to connect with database. Each WCF live in different servers but using the same user and the same connection string.
Thanks for your help