Q

ORA-01000 errors on Windows XP

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?

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 9.2.0.6. 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.

This was first published in May 2005

Dig deeper on Oracle error messages

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close