isql command not working in Linux 64bit

 
Thread Tools Search this Thread
Operating Systems Linux Red Hat isql command not working in Linux 64bit
# 1  
Old 04-04-2012
isql command not working in Linux 64bit

I am using Linux RHEL5 64 bit and installed oracle 11g.
I want to check ODBC connection , i had modified odbc.ini file
when i use this command -isql
I am getting following error .
bash: isql: command not found

Kindly help
# 2  
Old 04-04-2012
You PATH environment would not appear to be correct. Can you show us the output from:-
Code:
$ echo $PATH
$ find / -name isql 2>/dev/null

That should start us off. Of course, I'm assuming that you have read access to the directories that contain it, and indeed that it is installed. Being Oracle, is it not sqlplus ? Just a thought, I don't have an Oracle version that new!



Robin
Liverpool/Blackburn
UK
# 3  
Old 04-04-2012
now I am able to use this command , there was some problem with the installation.
but at present I am unable to do connectivity to oracle 11g using ODBC.

I had set all env variables ,PATH,ORACLE_HOME , ORACLE_SID ,LD_LIBRARY_PATH ,TNS_ADMIN
and tnsnames.ora also
still I am getting the error as

[S1000][unixODBC][Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Kindly help
# 4  
Old 04-04-2012
The server where the Oracle database runs, has to have a network listner (port 1521) and a configuration file to recognise your request.

You will need to talk to the person who set up the new Oracle database on the remote server. If this is actually the same server, then don't connect with ODBC anyway. You environment variables should be enough.

Can you elaborate on what is local, what is remote and what is in the TNS Listener config file - and is it running (netstat -na|grep 1521)




Robin
Liverpool/Blackburn
UK

Last edited by rbatte1; 04-04-2012 at 10:41 AM.. Reason: Forgot signature
# 5  
Old 04-04-2012
One of the product required ODBC connectivity and netstat is working fine
where can I finf this tns listener config file . r u talking of listener.ora
# 6  
Old 04-04-2012
Yes, listener.ora is the usual file. How is your database defiend within there? If you call it as SID DB, does your tnsnames.ora send you to the right place and is the other end listening for your call.

You could try:-
Code:
tnsping DB

and see if that connects to the right place. That will at least validate part of tnsnames.ora, is pointing to the correct server and shows that port 1521 is open.


Does that get you any nearer? If not, please paste the output and we'll have a think.



Robin
Liverpool/Blackburn
UK
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Simple sed command not working; could be a Mac/Linux vs. PC/Linux issue

Hello, I am on a Mac and trying to clean up some monthly files with a very simple SED: sed '3,10d;/<ACROSS>/,$d' input.txt > output.txt (from the input, delete lines 3 - 10; then delete from the line containing <ACROSS> to the end of the file) then output to output.txt Even when I try... (2 Replies)
Discussion started by: verbatim
2 Replies

2. Shell Programming and Scripting

At command for Linux job not working from php

I have a script .sh with a curl command in it: curl --digest "http://xxxxxxx.xxx/mail.php?email=xxxx@xxx.xx"; from terminal this works good : ./script.sh //(mail arrives in my box) from php this works good: shell_exec('./phpsc.sh'); // (mail arrives in my box) from terminal this... (13 Replies)
Discussion started by: extra93
13 Replies

3. UNIX for Dummies Questions & Answers

SWAP command not working on Linux machine

Hi I am working on linux machine and swap command is not working Linux Machine On Solaris machine it is working fine: uname -a SunOS rgsm01 5.9 Generic_118558-03 sun4u sparc SUNW,Sun-Fire-V440 swap -s total: 6596320k bytes allocated + 1035968k reserved = 7632288k used, 38893408k available ... (5 Replies)
Discussion started by: Basant Mishra
5 Replies

4. Shell Programming and Scripting

AWK command working different in Linux

Hi All I have fired a command in linux table=`echo ${file_name} | awk '{FS="/"; print $NF}' | awk '{FS="."; print $1}'` where file_name has /data/ds/dpr_ebicm_uat/backfill/temp/etl_app_info.csv /data/ds/dpr_ebicm_uat/backfill/temp/etl_app_jobs.csv ... (10 Replies)
Discussion started by: vee_789
10 Replies

5. Shell Programming and Scripting

sed command working different in linux environment.

Hi I tried running the code scrname=`whence $0 | sed -e 's/\.\///g'` where $0 is substituted by cm_dsjobrun.sh in unix env then the value it returns me is SCRNAME=/data/ds/dpr_ebicm_uat/etl/cm3_0/scripts/shell/cm_dsjobrun.sh whereas i ran the same code on linux env The value... (9 Replies)
Discussion started by: vee_789
9 Replies

6. Shell Programming and Scripting

ITcl :: try_eval command not working in Linux 5.4

Hi, My code uses try_eval block to do some code execution. This piece of code does not work on RHEL 5.4. The program just hangs at the try_eval block and does not throw any errors either. The same program however works in other Linux boxes that we have. I have written a simple program that... (0 Replies)
Discussion started by: archana485
0 Replies

7. Programming

cos() command not working in Linux

Hi, I have written a c program to find cos() of a value , its not working, I am getting value of "val " as 0000. #include<stdio.h> #include<math.h> main() { float val; val = cosf( 1.570796); printf("\nval = %f",val); } (9 Replies)
Discussion started by: shashi
9 Replies

8. Linux

Linux version v.s. 32bit/64bit

Where can I get a list that maps the each Linux version to corresponding 32/64 bits model? e.g. OS -> Model (ILP32, LP64, ...) RHLE3 -> ? RHLE4 -> ? RHLE5 -> ? ... It would be better if there is such a list that contains most of current UNIX OS versions. ... (1 Reply)
Discussion started by: princelinux
1 Replies

9. Linux

Linux 32bit or 64bit

Hi, I want to know what is command to know which will tell wheather linux is 32 or 64 bit (5 Replies)
Discussion started by: manoj.solaris
5 Replies

10. Linux

Oracle and 64bit Linux

Hello All, Does anybody installed the subj? How it works? Any troubles/problems? M (1 Reply)
Discussion started by: mg`
1 Replies
Login or Register to Ask a Question