If you are using Windows 7 or Vista with Oracle version 10 or 11, you may need to change the default permissions given to the Iguana service so that Oracle will work correctly.
Note: This probably applies to other Windows version.
Oracle is not working correctly — because the Oracle DLL does not load. This is because Iguana is unable to execute the Oracle DLL.
The Iguana service must have full read and execute access to the Oracle home directory and its subdirectories and files. This will ensure that the Oracle DLL file loads properly when Iguana is started from the Services menu or from the net start Iguana command.
To change the default permissions given to the Iguana service:
- In Windows 7 or Vista, click the Start button.
- From the menu that appears, select Control Panel.
- From the Control Panel window, double-click Administrative Tools.
- From the Administrative Tools window, double-click Services.
- Double-click the iNTERFACEWARE Iguana service to open the Properties dialog box.
- Click the Log On tab.
- In the Log on as field, supply a username that is a member of the Administrative role or that has full read and execute access to the Oracle home directory and its subdirectories and files.