ArcSDE Direct Connect and ArcSDE maximum connections number.

[MichaelGinzburg]

Hello,

We have ArcSDE 9.3 on Oracle 10g Windows 2003 32 bit box.

The same SDE is used by AGS 10 installation on Windows 2008 64 bit box.

Adding new services to AGS caused Maximum connections exceeded SDE error (we need 68 connections instead of default 48).

I increased maximum connections number by sdeconfig but then (as it was predicted by some posts) I ran into Oracle problems, ORA-12640 (Authentication adapter initialisation failed).

Our DBA checked the DB and said that Oracle problems are caused by SDE overload. Indeed, after restarting the SDE service everything works for some time.

Trying to reduce overload, I switched AGS services to Direct Connect.

I still see connections in sdemon since as Jake Skinner explained in his answer below, sdemon counts direct connections also.

The question is: should I expect reduce in SDE overload because of switching to Direct Connect.

As I know, with Direct Connect spatial procedures are made at the client (in my case - AGS box which is more powerful).

P.S. ArcSDE 9.3 is used for compatibility with another older GIS reasons.

Thanks in advance,

Michael

[VinceAngelo · Accepted solution]

The 48 connection limit was set as the default because application server connections overtopped the Windows desktop heap.  Direct Connect does not produce the same issue , so you can run the CONNECTIONS count higher.

You really need to join the current decade in terms of Windows, ArcSDE and Oracle install.  None of those products are currently supported, which is a huge security risk.

- V