I'm having trouble connecting to our Oracle database
in Matlab 7. The database is version 9.2 and the
following environment variables are set:
ORACLE_HOME=/oracle/v920
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/lib:$PATH
SHLIB_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=$ORACLE_HOME/lib
CLASSPATH=.:$ORACLE_HOME/jdbc/lib/classes12.zip
I've tested the Oracle jdbc connection with both
the thin and the oci drivers, but when I try to
connect in matlab, I get the following error:
>> conn =
database('MIP01','','','oracle.jdbc.driver.OracleDriver','jdbc:oracle:
oci8:@MIP01');
??? Java exception occurred:
java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1426)
at java.lang.Runtime.loadLibrary0(Runtime.java:772)
at java.lang.System.loadLibrary(System.java:832)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java
)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.jav
a)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
com.mathworks.toolbox.database.databaseConnect.makeDatabaseConnection(
databaseConnect.java:137).
Error in ==> database.database at 111
connectionVector = makeDatabaseConnection(conn);
>>
Thanks,
Steve Edwards