MATLAB: Do I receive an error when I try to connect to an Oracle database on with the Database Toolbox 3.4 (R2007b)

Database Toolboxdbjdbc

I use a 64-bit version of Windows and a 32-bit version of Oracle and MATLAB. I setup up the ODBC connection and when I run the test it works. When I try to connect to it with the Database Toolbox, I receive the following error:

 While doing connection=database(), I get an error message that says: 
 TNF: Not resolved connection, ora-12154

Best Answer

This is an issue with the ODBC driver provided with the Oracle database. A bug report from Oracle which describes the issue that you are experiencing is available at:

http://mykestin.spaces.live.com/blog/cns!BA72F2647C0F573B!607.entry

The issue is caused by the path name of the client software. The 32-bit version of MATLAB is typically in "C:\Program Files (x86)\MATLAB". Due to a bug in the Oracle driver, the "(x86)" string in the path name is causing it to fail to connect. The work around is to change the installation directory of MATLAB and Oracle so that they do not contain any parentheses. There is a bug tracker link which you may be able to use to check the status of the bug report.

Related Solutions

MATLAB: Am I having problems connecting to a remote Oracle 9.2 database using the Database Toolbox

We recommend that you use the JDBC thin drivers as they are easier to configure than OCI drivers. For JDBC thin drivers, the $MATLAB/toolbox/local/classpath.txt entry appears similar to:

 /home/username/classes111.zip

To make a connection using a JDBC thin driver specify the driver and URL as follows:

 Driver: oracle.jdbc.driver.OracleDriver
 URL: jdbc:oracle:thin:@192.171.xxx.xx:xxxx:

The Oracle OCI JDBC drivers are type 2 drivers, meaning that there is additional software beyond the base Oracle installation that must be installed. The OCI client software consists of additional libraries that the JDBC OCI drivers need in order to make the connection to Oracle. The location of these installed libraries must be included in the file $MATLAB/toolbox/local/librarypath.txt.

For example, for a UNIX system, if Oracle is installed in /oracle/ora92, the entry in librarypath.txt would appear as

 /oracle/ora92/lib32

The files in that directory are:

For Windows:

ocijdbc9.dll

ocijdbc9_g.dll

heterox.dll

heterox_g.dll

 (_g indicates debug version)

For UNIX:

Files have .lib extension, ie ocijdbc9.lib

To make a connection using a JDBC OCI driver, specify the driver and URL as follows:

 Driver: oracle.jdbc.driver.OracleDriver
 URL (example): jdbc:oracle:oci8:@fogo

Please see the information below for other possible errors with respect to connecting to database using OCI drivers and the way(s) to workaround them:

 ??? Java exception occurred: 
 java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path

This error appears if MATLAB cannot locate the libraries; to workaround this, update 'librarypath.txt' file in the location $MATLAB/toolbox/local/ as described above.

 ??? Java exception occurred: 
 java.lang.UnsatisfiedLinkError: no ocijdbc9.dll in java.library.path

This is the result of a path issue. To workaround this issue, try putting the connection script(MATLAB code) in the same directory as the OCI DLL files and run it from there.

 SEVERE: Error while registering Oracle JDBC Diagnosability MBean.
 ....

The issue would be because of incompatible java drivers. To workaround this, update java drivers

MATLAB: Do I receive a “failed connection” error when trying to connect to a database with Database Toolbox 3.0.1 (R14sp1)

This enhancement has been incorporated in Database Toolbox 3.1 (R14sp3). For previous product versions, read below for any possible workarounds:

This error message may be caused by a number of issues. If your data source cannot be found and you receive this error message, perform the following:

1. Check the list of drivers in the ODBC control panel to verify that the driver you want to use is on the list.

2. Check to see if the .mdb file for the database has been moved since creating the data source.

3. Verify that you are using the correct database name in the DATABASE command. In particular, be sure to use the database name and not the .mdb filename.

Best Answer

Related Solutions

MATLAB: Am I having problems connecting to a remote Oracle 9.2 database using the Database Toolbox

MATLAB: Do I receive a “failed connection” error when trying to connect to a database with Database Toolbox 3.0.1 (R14sp1)

Related Question