When creating a new warehouse connection to an Oracle Object Model Read-Only or Oracle Object Model Read-Write data server an error message is displayed stating "The GDO Object OracleORW.GDatabase is not registered correctly. Please reinstall the application to ensure proper registration."
This error occurs when GeoMedia is unable to access the oci.dll file in the oracle_home\bin directory.
1.Ensure that the %oracle_home%\bin directory is present in the path.
2.Ensure the oci.dll file is found in the %oracle_home%\bin directory. If it is not present, then it must be installed using oracle universal installer.
1.Ensure the oci.dll file is found in the %oracle_home%\bin directory. If it is not present, then it must be installed using oracle universal installer.
2.Ensure the %oracle_home%\bin directory is present in the path.
To test this,
a. Ensure the sqlplus.exe file is present in the %oracle_home%\bin directory.
b. Open a command prompt window and from any path other than %oracle_home%\bin, attempt execution of sqlplus.
c:\> sqlplus /nolog
If the system cannot find the sqlplus executable this indicates that there is a problem with the path. If this successfully takes you to a SQL> prompt then the path is likely not the problem.
3.Make sure the oracle_home environment variable is set to a valid path that is one level higher than the bin directory where the oci.dll resides.
To test this,
a. From a command prompt window, issue the set oracle_home command to view the current value for the variable
c:\> set oracle_home
b. If the oracle_home variable is set to a value (not null), attempt to cd to the oracle_home\bin directory
c:\> cd %oracle_home%\bin
If this fails, there is an error in the value set for the oracle_home environment variable.
4.Edit the permissions on the oracle folder to remove then re-add read/write permission. Then reboot the machine.