Login or Register to Ask a Question and Join Our Community


Red Hat

Unix ODBC Issues

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Linux Red Hat Unix ODBC Issues
# 1  
Old 10-11-2011
Unix ODBC Issues
Hello,


I'm trying to get an ODBC connection to Oracle 10g database by following the below steps:

1. Downloaded UnixODBC 2.2.14 binary and extracted the contents
2. Added the following lines to /etc/profile:
Code:
LD_LIBRARY_PATH="/optware/unixODBC/lib/"
export LD_LIBRARY_PATH
ORACLE_HOME="/optware/oraClient/10.2.0.4"
export ORACLE_HOME
TNS_ADMIN="${ORACLE_HOME}/network/admin"
export TNS_ADMIN
NLS_LANG="AMERICAN_AMERICA.UTF8"
export NLS_LANG

3. Executed /optware/oraClient/10.2.0.4/odbc/utl/
Code:
./odbc_update_ini.sh /optware/unixODBC/

4. Following odbc.ini are created:
Code:
[ODBC Data Sources]
DEVDB
[DEVDB]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = /optware/oraClient/10.2.0.4/lib/libsqora.so.10.1
DSN =  DEVDB
ServerName = devdb2d
Login=qslatam
password=g00gl8
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MaxLargeData = 0
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
Database = //devdb2d.nam.nsroot.net:1900/DEVDB
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
UserID =
StatementCache=F
CacheBufferSize=20
Trace                     = Yes
TraceFile              = /tmp/Trace.txt

5. odbcinst.ini
Code:
[Oracle 10g ODBC driver]
Description     = Oracle 10g ODBC driver
Driver          = /optware/oraClient/10.2.0.4/lib/libsqora.so.10.1
Setup           =
FileUsage       =
CPTimeout       =
CPReuse         =


My Operating system is :
Code:
Linux amlmap2d 2.6.9-89.35.1.ELsmp #1 SMP Tue Jan 4 22:29:01 EST 2011 x86_64 x86_64 x86_64 GNU/Linux

When i check the odbc ocnnectivity following error was thrown :
Code:
isql -v DEVDB
[S1000][unixODBC][Oracle][ODBC][Ora]ORA-12541: TNS:no listener
[ISQL]ERROR: Could not SQLConnect

When i do a tnsping devdb following message is received.

Code:
TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 04-OCT-2011 17:03:13

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
)SERVICE_NAME = DEVDB )P )(HOST = devdb2dhost.net)(PORT = 1900 ))
OK (10 msec)



If anyone has come across similar issue, please share your experience.

Regards
Viswa

Moderator's Comments:
Mod Comment Video tutorial on how to use code tags
Last edited by pludi; 10-11-2011 at 06:47 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

UNIX directory creation issues

Hi All, I am facing a strange scenario. I upgraded my server version to new version of linux. After the when I create a directory it is created with . in the the permission . What is the reason and how to fix . $ mkdir test $ ls -l total 0 drwxr-xr-x. 2 uk01 users 6 Dec 7 03:49 test ... (1 Reply)
Discussion started by: arunkumar_mca
1 Replies

2. Shell Programming and Scripting

Unix bash script (mv issues);

Hey guys, I've registered here as I need urgent help. This is assignment for school and as you can see below I've completed the work. I'm simply stuck on one area. :wall: This script takes the first parameter (which is to be the new extension) and each parameter after that is a file... (1 Reply)
Discussion started by: Cynosure
1 Replies

3. UNIX for Dummies Questions & Answers

DNS on Unix box issues

Hi Guys, Just wanted to seek your assistance on an issue encountered with one of our client DNS server query. we have 2 sets of DNS servers.. internal and external. For Internal to reach the external DNS server (DMZ) it has to go through 2 FWs. Current settings: - FW rules for Internal... (3 Replies)
Discussion started by: Hotshot8259
3 Replies

4. Shell Programming and Scripting

Windows to UNIX issues

Hi, a script was used on Windows using MKS Toolkit. I'm trying to move it to a unix machine but it gets all errors. At first I had things like: syntax error: `in^M' unexpected I still get these but I've been building it up slowly to try and find/remove problems. The current is: syntax error:... (10 Replies)
Discussion started by: Dird
10 Replies

5. Shell Programming and Scripting

Connecting to Oracle by using ODBC on UNIX

Hi All, I have a requirement where I need to connect to Oracle database which is installed on WINDOWS machine. I dont have Oracle client installed on my AIX so i can't use SQLPLUS command. But ODBC to connect to Oracle is configured on my UNIX server. Can any one help me with the steps of... (1 Reply)
Discussion started by: Raamc
1 Replies

6. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies

7. UNIX for Dummies Questions & Answers

ODBC on UNIX

I see several questions regarding setting up ODBC on UNIX machines but I don't see any replies. I always thought ODBC was only possible on Windows machines, but I've recently heard drivers do exist for ODBC on UNIX. Does anyone know any more details about this: How to set up ODBC on UNIX, web sites... (1 Reply)
Discussion started by: ggmar
1 Replies

8. UNIX for Dummies Questions & Answers

ODBC Driver for UNIX

I have no experiance in Unix and I am trying to help our DBAs set up a connection from a Unix Oracle box to a DB2 database on an AS400 server. Does anyone know where I might find a good generic ODBC driver for Unix that should be able to connect to AS400? Any links to sites that would help would... (0 Replies)
Discussion started by: doctorofstyle
0 Replies

9. SCO

Sco Unix network issues

I have got a Sco Unix Server, i want to connect some windows workstations. What configurations do i need to make on server and or workstation? (1 Reply)
Discussion started by: tpurazi1
1 Replies

10. UNIX for Advanced & Expert Users

Unix environment issues

I'm having a problem with AIX 4.3.3 and I figured someone here might be able to help me. I'm running a program 24/7 and I want to handle the day light savings issue without restarting the program since my users won't like it. I don't have the option of setting the time for the DLS in advance,... (4 Replies)
Discussion started by: Eff
4 Replies
Login or Register to Ask a Question