[imp] imp 2.2.3/oci8 session error

Andrew Draskoy andrew@mun.ca
Thu, 16 Nov 2000 11:04:22 -0330


FYI for developers and anyone else who's run into this:

According to our oracle guy, the 3113 apparently occurs when accessing
oracle after it's been shut down and restarted, due to persistent connections.
He suggests that if it's encountered, the application should close and
reopen the connection.

Andrew

> ORA-03113: end-of-file on communication channel 
> Query :"SELECT val FROM active_sessions WHERE sid =
> 'f2e2cd3cee193c2280abd5f97f5657d8' AND name = 'HordeSession'"