| Product(s): | MicroStation | ||
| Version(s): | 17.xx.xx.xx, 23.xx.xx.xx | ||
| Environment: | N\A | ||
| Area: | Database | ||
| Subarea: | Oracle |
Oracle Database Connection Issues.
Problem
User receives an error Unsuccessful CONNECT statement when try to connect to Oracle database.
In windows command line, I can use SQLPlus to connect to the Oracle database.
Solution
The following steps addressed the problem.
• Set configuration variable MS_ORACLE_HOME = C:\ORACLE64\PRODUCT\19.0.0\client_1\
To make sure the variable is set correctly, in MicroStation key-in window type expand echo $(MS_ORACLE_HOME)
• Register Oracle.DataAccess.dll in GAC manually according to this page: Register the Oracle.DataAccess.dll assembly
• Test with this key-in mdl load dbconmgr;dbconmgr oracle; db=user/pass@servicename
For additional details, refer to this troubleshooting Wiki Automatic direct connection to Oracle databases
See Also
To Connect to an Oracle Database from the Product Properties Dialog
Other Language Sources
| Original Author: | Leonard Jones |