Re: ORA-03114 Not Connected To Oracle problem.

On 3 Aug 2005 12:09:15 -0700, nicolas.bouchard@xxxxxxxxx wrote:

>Hello,
>
>I'm trying to solve a problem with our software. The software is
>developed using Visual C++ 6, the Oracle Server is a 8.1.7.0.0 and
>we're using the OO4O 8.1.7.3.11. The OS of the server is win2k server
>and the workstations are win2k also. The users are connected through
>Terminal Services and all the sessions are handled by one server.
>
>My problem is a ORA-03114 that popups randomly, in the middle of a
>process. The weird thing is, it is never at the same place, and always
>in the middle of the process (the systems did queries milliseconds /
>seconds before). Most of the time, the errors occur on queries and not
>on update / insert / delete.
>
>The Oralce Connection can be up for some hours at the time of the crash
>and only one connection to Oracle will fail. Network problem could be
>ruled out, only one Oracle connection is broken (even if there are
>30-50 more connections opened on the same TS server) and that user
>didn't lost his TS connection to the server.
>
>I know there are OO4O 3.15 released, but upgrading our clients require
>a great deal of problems (our customer are 24/7), I'm making pression
>to make the upgrade, but as you may guess, it's taking quite a long
>time.
>
>Do you guys have any idea or suggestion where I can look to find clues
>on the problem ? I have already looked at the Oracle TRACE generated
>by the server and by the clients, if I remember correctly, no specific
>error occured before our 03114.
>
>Thanks,
>
>Nicolas Bouchard.

ora-3114 can occur in many different cases, but most of them point to
shared pool issues. Likely this is a result from shared pool
fragmentation, caused by excessive parsing, caused in its turn by not
using bind variables.

If your customer is 24 * 7 why is he running on a fully desupported
config?


--
Sybrand Bakker, Senior Oracle DBA
.

Relevant Pages

  • [NEWS] Multiple Vulnerabilities in Oracle Database (Character Conversion, Extproc, Password Disclosu
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the (Oracle database server ... password is required to exploit this vulnerability. ...
    (Securiteam)
  • Re: Oracle connection Fails
    ... That should show you what's attempting to be sent to the server. ... to connect to the oracle database by using Oracle data provider ... from Our main server i am getting an exception. ... Connection conn, IntPtr opsErrCtx, Object src) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IDbCommand, Oracle, Select query
    ... My mission is to execute a sql statement in vb.net and retrive the data ... Using connection As New SqlConnection ... "An error has occurred while establishing a connection to the server. ... I am running a oracle server with a database I am trying to access. ...
    (microsoft.public.dotnet.general)
  • Linked server 7302 error
    ... I have a strange connection error that I believe is related to security. ... server connection through network using integrated security. ... I have installed Oracle 9i SQL*Net Client 9.0.1.1.1. ...
    (microsoft.public.sqlserver.connect)
  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
    ... I also want to mention that I have tried creating just the data connection ... I have unitstalled both IIS and the Oracle Client. ... restarted the server and then installed the Oracle Client and then restarted ... I am devoted to Microsoft ...
    (microsoft.public.inetserver.iis)