Knowledge Base


GeoExpress - Knowledge Base Articles

A060803 - Trouble connecting to Oracle database after installing GeoExpress

Products:

GeoExpress 6.1

Summary:

Oracle SQL*Plus will not start when Oracle Database 10gR2 and GeoExpress 6.1 are installed on the same computer.

Cause:

GeoExpress installs the Oracle Instant Client DLL and adds its directory to the PATH environment variable. The SQL*Plus application links to some of the same DLLs and when it finds them in this path it quits running.

Another manifestation of this issue is that the iSQL*Plus system service will fail to start. You may not notice this unless it has been configured to start automatically, in which case this is the first thing you will notice.

Solution:

There are two potential solutions:

  • Remove the GeoExpress path from the PATH environment variable
  • Hide the Oracle libraries from SQL*Plus

To remove the path from the environment variable: 

  1. Right click on the My Computer icon on the desktop and select Properties.
  2. Select the Advanced tab.
  3. Click the Environment Variables button.
  4. Use the scrollbar to select the PATH environment variable in the System variables window.
  5. Click Edit.
  6. Delete the GeoExpress path that is listed as follows by default: 
    

    C:/Program Files/LizardTech/GeoExpress 6.1/bin
    

    7. 

  7. Click OK.
    8. 



If you then need to use the GeoExpress command line utilities, you can manually add the path back by entering the following on the command line:


PATH="C:/Program Files/LizardTech/GeoExpress 6.1/bin";%PATH%


You will need to do this each time you wish to use the command line utilities.


To hide the Oracle libraries from SQL*Plus: 

Move the following libraries out of the GeoExpress bin directory so that the SQL*Plus application does not find them and uses the libraries from ORACLE_HOME/bin instead. Note: this workaround may not work with versions of Oracle other than 10gR2.


oci.dll

ocijdbc10.dll

ociw32.dll

oracore10.dll

oranls10.dll

orannzsbb10.dll

oraocci10.dll

oraociicus10.dll

oraunls10.dll

orauts.dll

oraxml10.dll

															
Status:

								This issue has been reported to Oracle.															
Reference Number:

								TT-14513 															
This article was last updated or verified on 11 January 2013.