Sybase Install


Hello ,

I installed Sybase 12.5 on a new server, it is a new install have these services running:

sybdyt-msw-01% ps -fu sybase
     UID   PID  PPID  C    STIME TTY      TIME CMD
  sybase 22989     1  0 12:51:01 pts/1    0:00 sh -c /home/sybase/ASE-12_5/bin/backupserver -Ssybcps12_5t_back -e/home/sybase/
  sybase 16420 16418  0   Nov 03 pts/2    0:00 -csh
  sybase 14766 14757  0   Nov 03 ?        0:01 /usr/sbin/sshd
  sybase 22987     1  0 12:50:51 pts/1    0:00 sh -c /home/sybase/ASE-12_5/bin/dataserver -ssybcps12_5t -d/u01/master/d_master
  sybase 13332 13331  0 09:24:48 pts/4    0:00 -csh
  sybase 13331     1  0 09:24:47 ?        0:00 /usr/openwin/bin/xterm -sb -ls
  sybase 27174 16420  0 15:58:29 pts/2    0:00 ps -fu sybase
  sybase 22990 22989  0 12:51:01 pts/1    0:00 /home/sybase/ASE-12_5/bin/backupserver -Ssybcps12_5t_back -e/home/sybase/ASE-12
  sybase 16418 16416  0   Nov 03 ?        0:01 /usr/sbin/sshd
  sybase 14768 14766  0   Nov 03 pts/1    0:00 -csh
  sybase 22988 22987  0 12:50:51 ?        0:58 /home/sybase/ASE-12_5/bin/dataserver -ssybcps12_5t -d/u01/master/d_master -e/ho
  sybase 23321     1  0 13:04:23 pts/1    0:00 sh -c /home/sybase/ASE-12_5/bin/backupserver -Ssybdyt-msw-01_back -e/home/sybas
  sybase 13324 13322  0 09:24:47 ?        0:07 /usr/sbin/sshd
  sybase 23322 23321  0 13:04:23 pts/1    0:00 /home/sybase/ASE-12_5/bin/backupserver -Ssybdyt-msw-01_back -e/home/sybase/ASE-

when I start isql , it says: command not found.

thank you
Vinai
LVL 1
vijadonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CallandorCommented:
You need to add to the path the Sybase bin directory - that's where the isql executable is located.
0
alpmoonCommented:
Hi Vinai,

I agree. PATH should include home/sybase//OCS-12_5/bin directory

Btw. have you sorted out bcp problem you asked before? (If yes, you should close it)

Good luck
0
vijadonAuthor Commented:
I would need help with that please.
In Oracle we set the profile ,how or what do we do in Sybase.

Then what are the other steps to follow before I start creatring the database .

thank you for your help.

vsj
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

alpmoonCommented:
In your $SYBASE directory (I think it is home/sybase/ for you) there are SYBASE.sh, SYBASE.csh and SYBASE.env files. Run the relevant one the shell you are using.

For kourne shell:

. ./SYBASE.sh
0
vijadonAuthor Commented:
This is what i got:

sybdyt-msw-01% ./SYBASE.env
./SYBASE.env: Permission denied
sybdyt-msw-01% ./ SYBASE.sh
./: Permission denied

thanks
0
CallandorCommented:
You mean you don't have permission to access those directories?  Better call up the person who handled the Sybase install and get them to fix it.
0
vijadonAuthor Commented:
I got this resolved by sourcing the SYBASE.sh, do I have to set it every time I login in or is there a way to set in once for all time.

I sourced it and I could login thry isql ,but if I try it again it fails.

can you suggest.
thank you
Vinai
0
CallandorCommented:
Put it in your profile so that when you log in, it gets sourced.
0
alpmoonCommented:
If you are using Kourne shell you can add below line into your .profile after copying SYBASE.sh into your HOME directory:
. ./SYBASE.sh

If you are using C shell, add the content of SYBASE.csh into your .cshrc
0
vijadonAuthor Commented:
How would I add it in the profile.
What commands do I USE.

THANK YOU
VINAI
0
alpmoonCommented:
You can use any editor available, vi, emacs or whatever.
0
vijadonAuthor Commented:
I dont have a .cshrc  on my database server.
I need help,

thanks
Vinai
0
alpmoonCommented:
It is a file in your home directory. You can see it, if you enter below commands:

% cd
% ls -la
0
vijadonAuthor Commented:
This is all I have:
drwxr-xr-x  25 sybase   sybase      1024 Nov  4 15:58 .
dr-xr-xr-x   2 root     root           2 Nov 16 03:19 ..
-rw-------   1 sybase   sybase        51 Nov  4 09:24 .Xauthority
drwxr-x---   2 sybase   sybase        96 Nov  3 13:12 12.5
drwxr-x---  16 sybase   sybase      1024 Nov  4 12:50 ASE-12_5
drwxr-x---   5 sybase   sybase        96 Nov  4 09:51 ASEP-1_0
drwxr-x---   6 sybase   sybase      1024 Nov  4 09:52 CFG-1_0
-rw-r-----   1 sybase   sybase      1570 Nov  4 13:05 Config.log
drwxr-x---   2 sybase   sybase        96 Nov  4 09:51 Host-1_0
drwxr-x---   5 sybase   sybase      1024 Nov  4 09:51 Installer
-rw-r-----   1 sybase   sybase     12389 Nov  4 15:58 Installer.log
drwxr-x---  13 sybase   sybase      1024 Nov  4 09:53 OCS-12_5
drwxr-x---   6 sybase   sybase      1024 Nov  4 09:51 SQLRemote
-rw-r-----   1 sybase   sybase       668 Nov  4 09:53 SYBASE.csh
-rw-r-----   1 sybase   sybase      3428 Nov  4 10:02 SYBASE.env
-rw-r-----   1 sybase   sybase       569 Nov  4 09:53 SYBASE.sh
drwxr-x---   6 sybase   sybase      1024 Nov  4 09:51 SYSAM-1_0
drwxr-x---  53 sybase   sybase      1024 Nov  4 09:51 charsets
drwxr-x---   4 sybase   sybase        96 Nov  4 09:51 collate
drwxr-x---   3 sybase   sybase      1024 Nov  4 09:51 config
drwxr-x---   2 sybase   sybase        96 Nov  4 10:19 configed
drwxr-x---   2 sybase   sybase        96 Nov  4 10:19 data
drwxr-x---   4 sybase   sybase        96 Nov  4 09:53 docs-45_55
drwxr-x---   2 sybase   sybase      2048 Nov  4 10:02 installed
-rw-r-----   1 sybase   sybase       408 Nov  4 12:54 interf.old
-rw-r-----   1 sybase   sybase       548 Nov  4 13:04 interfaces
drwxr-x---  10 sybase   sybase      1024 Nov  4 09:53 jConnect-4_5
drwxr-x---  10 sybase   sybase      1024 Nov  4 09:53 jConnect-5_5
drwxr-x---   5 sybase   sybase        96 Nov  4 09:52 jutils-2_0
drwxr-x---   6 sybase   sybase      1024 Nov  4 09:51 locales
drwxr-xr-x   2 sybase   sybase        96 Oct  8 09:10 lost+found
-rw-r-----   1 sybase   sybase      3480 Nov  4 13:05 repository.cfg
drwxr-xr-x   7 sybase   sybase        96 Nov  4 09:53 shared-1_0
-rw-r-----   1 sybase   sybase        45 Nov  4 09:50 studio_version.txt
drwxr-x---   4 sybase   sybase      1024 Nov  4 09:51 sybcent32
-rw-r-----   1 sybase   sybase      7295 Nov  4 12:47 sybcps12_5t.cfg

thank you for your help,

vinai
0
alpmoonCommented:
In that case you can create one:

% cp SYBASE.csh .cshrc  

But, do you want to run isql as sybase or another user? Each user has its .cshrc in his home directory.
0
vijadonAuthor Commented:
why do I need to copy it into .cshrc.
Also can I edit SYBASE.csh and put the entry source SYBASE.csh into SYBASE.csh.
when I logon to the server I connect as SYBASE user.

thanks
0
alpmoonCommented:
Actually it is strange that you don't have .cshrc. Someone must have deleted it mistakenly. That was the reason I suggested to create it by copying SYBASE.csh. After creating .cshrc you can add anything else you need.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.