Hi, Been a few years since I did this on Linux for Oracle and it was on Fedora rather than Debian/Ubuntu.
That being said, there is a tnsnames.ora file that needs to be created to identify the Oracle server sid/ip and ports, there is an entry into /etc/ld.so.conf that needs to be made and ldconfig run to update the system, as well as shell environment variables that need to be created. I found a page here: http://ggorjan.blogspot.com/2007/04/oracle-instantclient-odbc-on-debian.html by Gregor Gorjanc, who is also an R user, that you might find helpful. It is a few years old, so version numbering will likely be different but the core information, I believe, is still correct. Regards, Marc Schwartz On Oct 30, 2013, at 11:05 AM, Lee Hachadoorian <lee.hachadooria...@gmail.com> wrote: > Luis, > > Respectfully, it is not the same. Previously the message was: > > ERROR: state IM002, code 0, message [unixODBC][Driver > Manager]Data source name not found, and no default driver specified > > Now it: > > ERROR: state HY000, code 12545, message > [unixODBC][Oracle][ODBC][Ora]ORA-12545: > Connect failed because target host or object does not exist > > So it *is* finding the DSN in your odbc.ini, but not the "target host or > object". Are you sure the server is running and responding to other > requests? Again, I'm not familiar with Oracle, but perhaps you have to > specify a database name as well as a host? (I know on Postgres you do...). > > Best, > --Lee > > > On Wed, Oct 30, 2013 at 11:50 AM, Luis Ridao <luri...@gmail.com> wrote: > >> >> I followed Lee's recommendations but still the same: >> >>> library(RODBC) >>> channel <- odbcConnect(dsn='BASTA', uid='******', pwd='*******') >> Warning messages: >> 1: In odbcDriverConnect("DSN=BASTA;UID=******;PWD=**********") : >> [RODBC] ERROR: state HY000, code 12545, message >> [unixODBC][Oracle][ODBC][Ora]ORA-12545: Connect failed because target host >> or object does not exist >> >> 2: In odbcDriverConnect("DSN=BASTA;UID=luisr;PWD=juanayzakarias") : >> ODBC connection failed >> >> -------------------------------------------------------------------------------------------------- >> /etc$ sudo gedit odbcinst.ini >> [OracleODBC-11g] >> Setup = >> FileUsage = >> CPTimeout = >> CPReuse = >> >> Description = Oracle ODBC driver for Oracle 11g >> Driver = /u01/app/oracle/product/11.1.0/client_2/lib/libsqora.so.11.1 >> FileUsage = -1 >> >> -------------------------------------------------------------------------------------------------- >> /etc$ sudo gedit odbc.ini >> [BASTA] >> >> driver = OracleODBC-11g >> description = Oracle_ODBC_driver >> server = 192.168.20.10 >> port = 1521 >> user = ****** >> password = ****** >> >> logging = No >> logfile = >> enable_user_catalog = yes >> enable_synonyms = yes >> metadata_dont_change_case = no >> metadata_dont_do_schema = no >> metadata_id = no >> limit_long = 0 >> >> >> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- >> Luis Ridao Cruz >> Faroe Marine Research Institute >> Nóatún 1, P.O. Box 3051 >> FO-110 Tórshavn >> Faroe Islands >> Tel : (+298) 353900 >> Fax: : (+298) 353901 >> e-mail: lu...@hav.fo >> luri...@gmail.com >> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- >> >> >> >> On Wed, Oct 30, 2013 at 3:32 PM, Lee Hachadoorian < >> lee.hachadooria...@gmail.com> wrote: >> >>> >>> >>> >>> On Wed, Oct 30, 2013 at 9:30 AM, Luis Ridao <luri...@gmail.com> wrote: >>> >>>> You mean: >>>> >>>>> channel <- odbcConnect(dsn='BASTA', uid='*****', pwd='********') >>>> >>>> Warning messages: >>>> 1: In odbcDriverConnect("DSN=BASTA;UID=luisr;PWD=juanayzakarias") : >>>> [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver >>>> Manager]Data source name not found, and no default driver specified >>>> 2: In odbcDriverConnect("DSN=BASTA;UID=luisr;PWD=juanayzakarias") : >>>> ODBC connection failed >>>> >>>> or in the odbc.ini file: >>>> /etc$ sudo gedit odbc.ini >>>> >>>> [oracle_driver] >>>> driver = OracleODBC-11g >>>> description = Oracle_ODBC_driver >>>> server = BASTA >>>> port = 1521 >>>> sid = 192.168.20.10 >>>> user = ******** >>>> password = ********* >>>> logging = No >>>> logfile = >>>> enable_user_catalog = yes >>>> enable_synonyms = yes >>>> metadata_dont_change_case = no >>>> metadata_dont_do_schema = no >>>> metadata_id = no >>>> limit_long = 0 >>>> >>>> It keeps on failing >>>> >>>> Best, >>>> Luis >>>> >>>> >>> Luis, >>> >>> The name between the braces in odbc.ini is the DSN. You have named the >>> DSN oracle_driver, not BASTA. So either rename it in odbc.ini, or refer to >>> it as oracle_driver in the odbcConnect() call. >>> >>> Also, I'm not really familiar with Oracle, but I can't seem to find any >>> information on the sid parameter you have set in the ini. The examples I >>> see use server, servername, and/or database. See >>> http://www.almahdi.cc/linux/setup-unixodbc-on-linux-for-oracle-and-sybase/ >>> . >>> >>> Best, >>> --Lee >>> >> >> > > > -- > Lee Hachadoorian > Asst Professor of Geography, Dartmouth College > http://freecity.commons.gc.cuny.edu/ > > [[alternative HTML version deleted]] > > _______________________________________________ > R-sig-DB mailing list -- R Special Interest Group > R-sig-DB@r-project.org > https://stat.ethz.ch/mailman/listinfo/r-sig-db _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
