Invalid SID error with large number of processes

Invalid SID error with large number of processes

Postby ismir.kamili » Thu 20 Nov 2008 08:31

I previously purchased the DBExpress driver for ORACLE from CoreLab.
I develop a CGI application using Delphi 7 that connects to ORACLE through DBExpress. The application works fine when small amount of users accessed it. But when more users accessed the application (there could be about 200 instances of the CGI process at the same time), the application failed to connect to the ORACLE and got the message 'Invalid SID'.

Is the problem caused by the ORACLE itself or from the connection library or even from the weakness of the DBExpress architecture ? For your information, my ORACLE has been fully licensed. Any suggestion for the problem ? Or may be I should buy another license from CoreLab / Devart for such application ?

Regards
ismir.kamili
 
Posts: 2
Joined: Thu 20 Nov 2008 07:55

Postby Plash » Thu 20 Nov 2008 11:24

Please specify whether you are using the driver in the Direct mode (without OCI).

If so, try to use the driver in the OCI mode. This mode can be more stable.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

How to ?

Postby ismir.kamili » Fri 21 Nov 2008 06:50

I don't really understand how to put the driver in OCI mode or direct mode. Could you please give me the information ? Is it done by setting the parameters property ? Which is the default mode, OCI or direct ? I think I'm using the default mode (cause I did not make any settings related to it)
ismir.kamili
 
Posts: 2
Joined: Thu 20 Nov 2008 07:55

Postby Plash » Fri 21 Nov 2008 11:12

This can be done by selecting an approprite driver: Oracle (Core Lab) or Oracle Direct (Core Lab).
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for Oracle