QUESTION POSED ON: 06 May 2005
Are there any known issues regarding Oracle on Windows XP?
We have a system with a Win2K server on the back end and an XP client.
Whether using Oracle 8.1.7.4 or 9.2.0.4 on these machines, we are
running into ORA-01000 errors.
Background: Our application is written in VB, with OLEDB/ADO as
middleware talking to the Oracle database. When logging on, the application opens a number of cursors to gather
user setup information. Regardless of the server O/S, whenever we use an
XP client cursors are not being closed by Oracle until the logon process
is complete, despite the fact that our application is releasing the
cursor each time. This is leading to excessive numbers of cursors being
opened -- up to 1800 in one case.
We do not experience this problem when using a non-XP client against the
same server, and our customers have also reproduced it using an XP
client against an HP-UX server and cannot reproduce it using an NT
client against the same HP-UX server.
We have set the following initialization parameters on the server...
_CLOSE_CACHED_OPEN_CURSORS=TRUE
SESSION_CACHED_CURSORS=50
OPEN_CURSORS=1800
CURSOR_SHARING=FORCE
...without effect.
Any suggestions?
|
