Are there any known issues regarding Oracle on Windows XP? We have a system with a Win2K server on the back end...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
and an XP client. Whether using Oracle 184.108.40.206 or 220.127.116.11 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?
I would look to an error with the XP OLEDB/ADO drivers. Are you using the most current? If so, have any errors been reported to the provider of that middleware? Maybe an earlier release is required. The only Oracle bug I could find is 4263105, but it deals with the 10g release but has been shown to affect as far back as 18.104.22.168. It states that the close in the driver may not close cursors properly depending on scope. Maybe Don can find more on this.
Don Burleson adds:
"Are there any known issues regarding Oracle on Windows XP?" Yes, there are dozens of them listed on Metalink.
Dig Deeper on Oracle error messages
Related Q&A from Mike Ault
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to...continue reading
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists.continue reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.