Oracle11g giving issues when deployed in Win7

Oracle11g giving issues when deployed in Win7

Postby peddiraju » Tue 16 Nov 2010 11:32

We have developed our server in Oracle 11g.All the functionalities are working fine with windowsXP.When we are using the same for Windows 7 32 bit it is giving few issues like table doesn't exists,sequence doesn't exist etc...
Do we need to do any settings for either Win7 or Oracle11g to make it functional.Please give your suggestions.Let me know if you need further information.
peddiraju
 
Posts: 6
Joined: Fri 29 Oct 2010 05:32

Re: Oracle11g giving issues when deployed in Win7

Postby Shalex » Wed 17 Nov 2010 10:47

peddiraju wrote:it is giving few issues like table doesn't exists,sequence doesn't exist etc...

1. Please make sure that the schema of your Oracle user you're connecting with includes tables and sequences you're getting errors about.
2. Check your code: maybe tables/sequences names in your queries contain prefix with the different schema (user).
3. Try to debug your application to localize the problem by using the dbMonitor tool that performs per-component tracing of database events such as commit, rollback, SQL statement execute etc.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html
In dbMonitor you will find the SQL statement that fails to execute. Try executing the same statement using another tool (e.g., SQL Plus or OraDeveloper Studio http://www.devart.com/dbforge/oracle/studio/). Does the problem persist in this case as well?
Shalex
Devart Team
 
Posts: 7531
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle