Solved

Isql in Linux , where is ??

Posted on 2013-06-13
9
4,155 Views
Last Modified: 2013-06-15
I have just install sybase ASE 15.7 in CentOS, after installed, I tried with isql but it only return errors..

[root@localhost ~]# su - sybase
[sybase@localhost ~]$ pwd
/opt/sybase
[sybase@localhost ~]$
[sybase@localhost ~]$
[sybase@localhost ~]$
[sybase@localhost ~]$ isql
-bash: isql: command not found
[sybase@localhost ~]$ echo $PATH
/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/opt/sybase/bin
[sybase@localhost ~]$
0
Comment
Question by:motioneye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 39245518
"isql" is in $SYBASE/$SYBASE_OCS/bin.

Try as user "sybase":

find $SYBASE -name "*isql*"
0
 

Author Comment

by:motioneye
ID: 39245555
Tq for quick reply, do you know how I can run an isql command without needed of accessing the folder ?

when trying isql, I get error mesage again

[sybase@localhost bin]$ ./isql -Usa -PpepperRice123
CT-LIBRARY error:
      ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
[sybase@localhost bin]$


below what I have in interfaces file


LOCALHOST
      master tcp ether localhost 5000
      query tcp ether localhost 5000
0
 
LVL 68

Assisted Solution

by:woolmilkporc
woolmilkporc earned 400 total points
ID: 39245596
>> run an isql command without needed of accessing the folder <<

Add the location of isql which you got from "find" to the PATH of user "sybase".

Best "source" the file SYBASE.csh in ~/.bashrc or ~/.profile of the "sybase" user.

Add a line like this:

. /$SYBASE/SYBASE.sh

(Note the ". " (dot space) in front.

If SYBASE.sh is not in $SYBASE use "find" like above to locate it:

find $SYBASE -name "SYBASE.sh"

Are you sure that the Sybase DB is started on "localhost"?

How about specifying "-S LOCALHOST" in the isql call?
0
Docker-Compose to Simplify Multi-Container Builds

Our veteran DevOps Author takes you through how to build a multi-container environment, managed with a single utility in order to simplify your deployments.

 
LVL 7

Assisted Solution

by:dec0mpile
dec0mpile earned 100 total points
ID: 39245603
It should be located here: /db/sybase/OCS-15_0/bin/isql

So you should be able to execute commands by typing:
[sybase@localhost ~]$  /db/sybase/OCS-15_0/bin/isql command_name
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 39245607
Sorry, don't type the slash when sourcing:

Add a line like this:

.  $SYBASE/SYBASE.sh
0
 

Author Comment

by:motioneye
ID: 39247126
./isql -Usa -PpepperRice123 -SLOCALHOST

still I get below errors

CT-LIBRARY error:
      ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
[sybase@localhost bin]$
0
 
LVL 68

Assisted Solution

by:woolmilkporc
woolmilkporc earned 400 total points
ID: 39247147
0
 

Author Comment

by:motioneye
ID: 39248705
Yes,
I'm done for SYBASE.sh



When trying to connect I still get the same error, howevere I managed to start sybase

sybase    3973  3972 21 02:41 ?        00:00:32 /opt/sybase/ASE-15_0/bin/dataserver -d/opt/sybase/data/master.dat -e/opt/sybase/ASE-15_0/install/LOCALHOST.log -c/opt/sybase/ASE-15_0/LOCALHOST.cfg -M/opt/sybase/ASE-15_0 -sLOCALHOST
sybase    39
0
 
LVL 68

Accepted Solution

by:
woolmilkporc earned 400 total points
ID: 39248778
After sourcing SYBASE.sh, what are the values for $PATH, $SYBASE and $DSQUERY ?

echo $PATH
echo $SYBASE
echo $DSQUERY

Is the interfaces file  $SYBASE/interfaces ?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
Fine Tune your automatic Updates for Ubuntu / Debian
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question