Oracle Database Connection Issues.
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.
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
To Connect to an Oracle Database from the Product Properties Dialog