sybase installation

Can someone please provide me th complete steps to install sybase ASE on solaris 64 bit. solaris 10 version i have.
I need complete steps please guys...i have the ASE guide to install on solaris but i need easy and straight forward steps.
also i want to know how can we install mutliple dataservers on same unix host.
I mean i want to create 3 dataservers ..DEV, QA, and ITF on same machine , how can this be done. Will there be 3 backup servers, 3 xp servers etc. please advise.
Who is Participating?
Joe WoodhouseConnect With a Mentor Principal ConsultantCommented:
Hmm, not sure how to make it any simpler than what's in the Installation Guide! Just walk through the steps, basically all you are doing is:

1) unload the software to your disk somewhere (ie unzip, untar, etc)
2) run the installer (on Solaris this is "asecfg"). If you don't have an X-windows environment there are other options here.
3) make some decisions about sizes, paths, page sizes, network ports, etc

For your other questions, if all of these will be the same version of the software, they can live under the one directory structure. However you may want them under separate directories so you can test the effects of patching/upgrading one of them without upgrading the others. If you do that, it's best to have 3 separate Solaris logins, one for each environment, that way you can set environment variables and paths per server instance.

The main thing for multiple ASEs on the same host is to use a different network port for each instance.

You can share a single Backup Server between multiple ASEs, but as above this will limit your ability to separately patch them, separately start and shutdown, etc. If your hardware is limited, you slightly save on resources by using just one Backup Server. Again, each Sybase server must be on its own port.

A common approach is to reserve a range of port numbers per instance. You might say that each ASE instance will get a port number maybe 100 apart, and then its Backup Server will be that number + 1, XP server +2, etc:

ASE_DEV, port 5000
ASE_DEV_BS, port 5001
ASE_DEV_XP, port 5002
ASE_DEV_MS, port 5003

ASE_QA, port 5100
ASE_QA_BS, port 5101

You probably want one XP server per ASE but these don't run unless you actually start making extended stored procedure calls, in which case the ASE will start them up for you. Likewise you probably won't be using the dedicated Monitor Server.
alpmoonConnect With a Mentor Commented:
If you are going to install three instances, I suggest using a resource file rather than X-Window GUI. Then you can copy that resource file, edit it and reuse it for other instances. It is also useful, if you need to reinstall ASE servers.
Deepak_FILAuthor Commented:
Thanks Guys,
further queries :

1. Hi Joe, i dont have X windows and hence what are the options to install it on the console only. can you please provide the exact command (syntax)
2.  Lets assume i want to create 2 instances(DEV, QA) and same backup server then what should be done. Do i need a seperate XP server , monitor server for them or same can be used ? When we install the binaries when do we provide the details of creating the ASE instance.
3. Also if a resource file is to be used then could you please provide the sample resource file ?
4. If we already have the ASE instance "ITF" on a host , how can i create a new ASE instance ITF_2 on the same host ?
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Joe WoodhouseConnect With a Mentor Principal ConsultantCommented:
1. Syntax is all the Install Guide! Look at Appendix A "Alternative Installation Methods".

2. Yes, per my first answer, you'll want separate XP and MS servers for each ASE instance, but you will probably never actually run them. Just build them at setup and leave it at that. Also per my answer above, installing the binaries is a separate step from creating the Sybase servers.

3. You already have a sample resource file! :) Look in $SYBASE/$SYBASE_ASE/sample. You'll find resource files for ASE, BS, XP and MS there, or in one of its subdirectories.

4. Creating a new instance is the same whether or not there are any existing instances. Install a new instance (using a resource file, since you don't have an X environment) and make sure you pick a different network port. I like making devices go in different directories for each instance, too.
Deepak_FILAuthor Commented:
i checked in $SYBASE/$SYBASE_ASE -- but didnt find any resource file.
I checked the subdirectories too

sybase@ldnudedev:/export/home/sybase/ASE/1254/ASE-12_5/sample% ltr
total 16
-rwxr-xr-x   1 sybase   dba           42 Mar 17  2004 README
drwxr-xr-x   2 sybase   dba          512 Jan  9  2007 esp
drwxr-xr-x   5 sybase   dba          512 Jan  9  2007 Java
drwxr-xr-x   5 sybase   dba          512 Jan  9  2007 messaging
drwxr-xr-x   2 sybase   dba          512 Jan  9  2007 histserver
drwxr-xr-x   6 sybase   dba          512 Jan  9  2007 XML
drwxr-xr-x   2 sybase   dba          512 Jan  9  2007 sybmigrate
drwxr-xr-x   2 sybase   dba          512 Jan  9  2007 server

I checked the subdirectories too
Joe WoodhouseConnect With a Mentor Principal ConsultantCommented:
Sorry, I think it's actually $SYBASE/$SYBASE_ASE/init/sample_resource_files. Try there?

If that isn't it, I'm not in front of an ASE right now, but they'll be buried somewhere two levels under the main ASE directory. Worst case, run this:

find  $SYBASE/$SYBASE_ASE  -name "*.rs"
jlsilva01Connect With a Mentor Commented:
You can install using "resource files". For each server, you must to set a different name to device files, configuration file, etc...
You can install by the command "./setup -console", using the same rules above.
alpmoonConnect With a Mentor Commented:
"I think it's actually $SYBASE/$SYBASE_ASE/init/sample_resource_files. Try there?"

Good memory Joe, dir name is exactly correct.


Sample files you need are:

jlsilva01, setup is needed to load software. But, it is already there. Deepak needs srvbuildres -r

jlsilva01Connect With a Mentor Commented:
alpmoon, You're right. Just "resource files" solves this question.
Deepak_FILAuthor Commented:
ok guys it helped me....
so if i repeat the steps :
1. first time installation i need to use ./setup - console  (for command line installation) -- this will install the binaries + one ASE server ..the details will be given as per the request appearing on the console.  make some decisions about sizes, paths, page sizes, network ports, etc...right ?
2. If i need to build more servers on this machine ..i need to create resource file by looking at the sample resource file and changing the values and execute:
srvbuildres -r
srvbuildres -r
srvbuildres -r
srvbuildres -r

Please correct me if i am wrong?

Joe WoodhouseConnect With a Mentor Principal ConsultantCommented:
That looks about right, yep!
Deepak_FILAuthor Commented:
accepted all
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.

All Courses

From novice to tech pro — start learning today.