Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Isql in Linux , where is ??

Posted on 2013-06-13
9
Medium Priority
?
4,413 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 1600 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 7

Assisted Solution

by:dec0mpile
dec0mpile earned 400 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 1600 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 1600 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Network Interface Card (NIC) bonding, also known as link aggregation, NIC teaming and trunking, is an important concept to understand and implement in any environment where high availability is of concern. Using this feature, a server administrator …
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…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
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.
Suggested Courses

688 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