MATLAB: Connecting to Oracle express

databaseDatabase Toolboxoracleoracle express

I am having troubles connecting to oracle express db. When i am trying to connect to the database i get the following error:
>> conn = database('test_db','','zxcv','Vendor','Oracle',...    
          'DriverType','oci','Server','remotehost','PortNumber',
1234)                                                           
Error using database (line 309)                                 
Java exception occurred:                                        
java.lang.UnsatisfiedLinkError: no ocijdbc11 in                 
java.library.path

Best Answer

The usage of database function is as follows:
conn = database('databasename','username','password','oracle.jdbc.driver.OracleDriver',jdbc:oracle:thin:@IP_ADDRESS_OF_DATABASE_SERVER:1521:databasename');
In the Query Builder, the database 'Name' should be the same as the suffix after the port number in the database 'URL', that is, the 'databasename' must be same as the SID parameter at the end of the 'databaseurl'. In your code, the instance parameter should be “dbname”.
Check out this link as well: http://www.mathworks.com/matlabcentral/answers/94155-why-do-i-receive-the-error-io-exception-connection-refused-with-oracle-10g-and-the-database-toolb
Related Question