[unixODBC-support] Oracle instant client & unixODBC don't work on Fedora 4

Abdelrhman Ahmed abdo at maintelecom.com
Sun Aug 15 12:57:03 BST 2010


 Dear experts,
 Please try to fix the following problem.
 I want to connect to oracle 10g on windows XP from client that runs
Fedora 4 using ODBC.
 1. I INSTALLED ORACLE INSTANT CLIENT ON FEDORA:
 • oracle-instantclient11.2-basic-11.2.0.1.0-1.i386.rpm
 • oracle-instantclient11.2-devel-11.2.0.1.0-1.i386.rpm
 • oracle-instantclient11.2-odbc-11.2.0.1.0-1.i386.rpm
 • oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.i386.rpm
 2. SET THE FOLLOWING ENVIRONMENT VARIABLES:
 • ORACLE_HOME =/usr/lib/oracle/11.2/client
 • ORACLE_HOME_LISTNER=/usr/lib/oracle/11.2/client/bin
 • LD_LIBRARY_PATH =/usr/lib/oracle/11.2/client/lib
 • SQLPATH =/usr/lib/oracle/11.2/client/lib
 • TNS_ADMIN =/usr/lib/oracle/11.2/client/bin
 • TWO_TASK =//xxx.xxx.xxx.xxx:1521/orcl
 3. TEST CONNECTION FROM FEDORA TO WINDOWS AND IT WORKS PERFECT.
 sqlplus system/pass@//xxx.xxx.xxx.xxx:1521/orcl
 4. INTSALL UNIXODBC-2.3.0.TAR.GZ
 5. ADD ORACLE ODBC ENTRY IN ODBC.INI
 [ORCL]
 Driver = Oracle 11g ODBC driver
 ServerName = xxx.xxx.xxx.xxx
 Database = orcl
 DSN = ORCL
 Port = 1521
 6. AND THIS’S THE ORACLE ODBC DRIVER ENTRY IN ODBCINST.INI
 [Oracle 11g ODBC driver]
 Description = Oracle ODBC driver for Oracle 11g
 Driver = /usr/lib/oracle/11.2/client/lib/libsqora.so.11.1
 Driver64 = 
 Setup = 
 Setup64 = 
 UsageCount = 
 CPTimeout = 
 CPReuse = 
 FileUsage = 
 7. NOW, ISQL -V ORCL SYSTEM PASS, FAILS AND REPORTS THE FOLLOWING
ERROR:
 [S1000][unixODBC][Oracle][ODBC][Ora]ORA-12504: TNS:listener was not
given the SERVICE_NAME in CONNECT_DATA
 [ISQL]ERROR: Could not SQLConnect
 HERE’S MY TNSNAMES.ORA:
 ORCL =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
 (CONNECT_DATA =
 (SID = ORCL)
 (SERVICE_NAME = ORCL)
 )
 )
 EXTPROC_CONNECTION_DATA =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
 )
 (CONNECT_DATA =
 (SID = PLSExtProc)
 (PRESENTATION = RO)
 )
 )
 HERE’S MY LISTENER.ORA:
 SID_LIST_ORCL =
 (SID_LIST =
 (SID_DESC =
 (SID_NAME = ORCL)
 (ORACLE_HOME = /usr/lib/oracle/11.2/client)
 (GLOBAL_NAME = ORCL)
 ) 
 (SID_DESC =
 (SID_NAME = PLSExtProc)
 (ORACLE_HOME = /usr/lib/oracle/11.2/client)
 (PROGRAM = extproc)
 )
	)
 ORCL =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
 )
 )
  
 HERE’S MY SQLNET.ORA:
 SQLNET.AUTHENTICATION_SERVICES= (NTS)
 NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
 TNSNAMES.ORA, LISTENER.ORA & SQLNET.ORA ARE AT
/USR/LIB/ORACLE/11.2/CLIENT/BIN
 Please I’m waiting your help, sorry for long post.
 Best regards,

-------------------------
Msg sent via @Mail - http://atmail.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20100815/eafdbacb/attachment.html>


More information about the unixODBC-support mailing list