What account is the application configured to connect ?
Can you connect using the sql plus using the same acvoubt that was not able to fetch
can you try running the queries in sqlplus ?
I am facing an issue with 10g Client. My 10g DB is residing on a RH Linux Server. My application is developed using Power Builder 12.5. The OS of client is Windows 7 Professional.
Now the issue.
I've installed 10g Client on the Windows 7 Pro Machine. Connected successfully to the Database in RHL Server.
When I log in to the Windows as Administrator, every thing is perfect. My Application is able to connect with the Server Successfully, fetch data from the server, write back to it etc.
But when I log in as a standard user in Windows, my application is able to connect with the server successfully. But not able to retrieve anything from the server. For eg:- I am not even able to collect the date from the server dual. Run as administrator option also tried. But no avail.
This is the first time I am trying to connect to an ORA DB in Linux from Windows client. Hence I am not sure about the process also.
Thanks in advance..
You report a problem but you do not show us EXACTLY what you do or how Oracle responds.
My car won't go.
tell me how to make my car go.
You post is devoid of any actionable detail.
is COPY & PASTE broken for you?
This is a case where version, not marketing label is important.
10g tells us nothing ... You actually need 10.2.0.4 or higher client on Win 7 (or was it 10.2.0.3, can't remember).
Alternatively, set local security policy on the machine to allow "create global objects" to everyone.
I think one of the software installed from administrative account, and not given permission to all users on windows.
Did you try with client tracing from Oracle client?