Solved

Installation of Sybase to Linux

Posted on 2008-10-23
7
445 Views
Last Modified: 2013-12-16
I'm a newby to Linux and not quite getting it when installation instructions say simply run ./setup to install Sybase on Linux. Where exactly do you "run" these commands? I've got the files on a CD and want to install from there.
0
Comment
Question by:DARRAH
  • 4
  • 3
7 Comments
 
LVL 19

Expert Comment

by:grant300
ID: 22796451
If you have read the installation instructions from the beginning to that point, I have to believe there is other Linux stuff you are skipping over.  Like setting the SHMMAX system parameter and creating a sybase user to do the installation.

Your best bet is to get somebody (a Linux person) to sit down with you and walk you through the entire process.  There is just too much you have to know about any O/S, e.g. how to get a terminal window running, or how to connect remotely with putty or x-windows, how to create a user with a home directory and set the default shell and create the .bashrc and .bashprofile, hos to set system parameters and make those settings permanent, how to setup environment variables, how to create symbolic links, oh, and how to use vi (the default editor: yuck!), etc.

Linux is not hard; there is just a learning curve like every other O/S.  Once you get used to it, you will really like it.

Regards,
Bill
0
 

Author Comment

by:DARRAH
ID: 22796585
Point well taken. I'm willing to do that (and have done some of those, ie setting up sybase user, home directory for user), but for my own business purposes, I need to determine if something will actually work on my end before I do the heavy lifting of moving my application to Linux. Therefore, for expediency, when the instructions indicate that I need to run something, just curious where that takes place. Unlike Windows, there is no Start | Run choice in which to type.
0
 
LVL 19

Expert Comment

by:grant300
ID: 22797137
Ah, GUIs will be the end of computer people who actually know how anything works inside (general lament not aimed at you personally).

You open up a terminal window and you get something very similar to the Windows Command interface; START->RUN cmd

./ means current directory.  Typing ./setup at the command line in a terminal window will run the setup program.

Be careful.  You have to be logged in as "sybase" to do the install or you wind up with a mess.  You will also have to be able to determine how much disk space is available on what file system(s) (df -k) so you know where you can put the install and eventually the database.

If you are logged in as root, you will have to "su - sybase" to become the sybase user.  At that, you may find that you have x-windows problems because the DISPLAY environment variable probably won't be set and the x-windows server security will not be lowered.  This stuff just keeps on coming...

Best of luck,
Bill
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:DARRAH
ID: 22798010
In general, I agree with you. You have to lift the hood and get your hands dirty to really understand how things work. Unfortunately, there are times when the most practical thing to do is just make sure that the engine runs before buying the car. That's what I am faced with.
As you are being very helpful, just two more questions:
1) Just making sure of the terminology, the terminal window is that which is accessed by Ctrl+Alt+F1?
2) My install files are on a CD. How does one access a drive other than the current C: drive since ./setup points at the current drive and folder.
Thanks and that should be enough to install. (Do you recommend a good site for documentation or Linux overview?)
0
 
LVL 19

Accepted Solution

by:
grant300 earned 150 total points
ID: 22798388
The problem here is that you are trying to find out if Sybase work on Linux, I can assure it does, and very nicely at that.  It appears you are trying to do the evaluation without knowing much about the environment.  You have to have a driver's licenses before you can test drive a car...

Your question 1 makes me wonder; have you been using the GUI at the console or have you been doing everything at the command line?  What distro and version of Linux are you using?  Once you get the GUI up, things get a lot easier.

A Terminal window is a GUI terminal emulator program that runs under the window environment.  Like a terminal emulator program on Windows.  BTW, you should download and install a free copy of Putty for Windows (a good terminal emulator) and a copy of WinSCP3, a GUI SFTP/SCP client.  They will make things easier for you.

As far as getting to the CD goes, that is dependent to some extent on the distro, version, and settings.  Some default installations will automount a CD that has been inserted.  Others require you to manually mount the CD.  The MOUNT command is generally of the form "mount /dev/cdrom /media/cdrom" but, here is the catch: the /dev/cdrom can be different and the /media/cdrom is almost certainly different from what you need.  Probably have to get your local Linux guy to give you a little time.

You navigate directories just like you do in the command/DOS window of Windows.  You use the CD command.  Directories are delimited by forward slash, not back slash and there are no drive letters.  All of the storage on the system starts at the "root" directory '/'.

What version of ASE are you running on Windows?
Are you attempting to move to the same version of ASE on Linux or are you doing an upgrade to v15?

Unless you are doing something really strange, the upgrade to v15 is pretty clean; I can't think of any just plane incompatibilities off the top of my head.  There are a few performance issues, for instance, you probably want to remove the FORCE PLAN statements if you have any as v15 usually does a better job without them.  Aside from that, you need to check your schema for the new reserved words, particularly if you are running v12.0 instead of 12.5.1 or higher.

In general, you will find noticeably better performance with v15 and v12 as well..

I know you think you are saving time by not learning any Linux, however, you should be able to do an install in 40 minutes if the Linux guy sites there with you.  Heck, I could have done it for you in less time than all the typing has taken.  And  you will continue to be stymied because after you do the installation of Sybase, you are going to have to get in and deal with setting environment variables, editing the interfaces file, and starting the server.

Regards,
Bill
0
 

Author Comment

by:DARRAH
ID: 22798942
Point well taken again. I've been in development for over 20 years, and I definitely know what you are talking about. The circumstances of the current project have pretty much forced my hand.

To your questions:
I have done most everything within the GUI console. I downloaded and installed Ubuntu 8.04 LTS Desktop Edition - Supported to 2011.  ASE is v15.2. This was a first time install for both. I had used Sybase a bit about 10 years back, but primarily used Microsoft SQL Server so there isn't a huge learning curve when it comes to that. It's primarily wrapping my mind around the new Linux paradigm.

I have an application that runs in Windows environment but a potential client who runs Linux on their server with Windows client workstations. It's a Delphi app that I'm working with and just want to see what issues I might run into running it connecting to a database running on Linux server. I can install and work with Sybase in Windows to test the database connectivity issues, but wanted to check out any Linux related obstacles before committing to the project. Thus my quandry to do this quick.

0
 
LVL 19

Expert Comment

by:grant300
ID: 22804994
I understand.  You need to do a quick feasibility study to get your arms around what it would take.  For the record, even with the application trapped on Windows, I would recommend running Sybase on Linux; you get better performance, flexibility, managability, and scalability.  Linux won the server wars some time back.

You can double check but I don't believe Ubuntu is on the supported platforms list for Sybase ASE 15.  While it is the distro of choice for desktop use, it is not a server-class distro; they have another product line for that.  While it may work, you may also find you have gremlins or problems ranging from inability to install to just plain flakey behaviour when you do get it up and running.  Your real (supported by Sybase) choices are SUSE Enterprise Linux or RedHat Enterprise Linux.  The "free" solution is to use CentOS.  This is the free, debranded distro of RedHat Enterprise Linux and can be trusted to be a clean substitute for pay-to-play RedHat.

You won't have any Linux related issues as far as your application goes.  The Sybase client is completely blind to the server platform.

It sounds as if the only real issues you are going to run into with this project involve learning a new operating system.  At least that will be fun and ultimatley profitable for you.

Best of luck and don't hesitate to ask additional questions as your project progresses.  You can also find my contact information in my profile.

Regards,
Bill

0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Daily system administration tasks often require administrators to connect remote systems. But allowing these remote systems to accept passwords makes these systems vulnerable to the risk of brute-force password guessing attacks. Furthermore there ar…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
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.

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now