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.
Oracle11g giving issues when deployed in Win7
Re: Oracle11g giving issues when deployed in Win7
1. Please make sure that the schema of your Oracle user you're connecting with includes tables and sequences you're getting errors about.peddiraju wrote:it is giving few issues like table doesn't exists,sequence doesn't exist etc...
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?