sybase 12.5 install a another instance: HP-UX

Posted on 2011-09-27
Medium Priority
Last Modified: 2012-05-12

has anyone installed dual instances of sybase 12.5 on the same server? any idea of the process for this? it's on an HP-UX platform. I'm a windows MS SQL man myself, so am a little worried about going ahead with an install without the proper knowledge. I'm working my way through the Install guide, but am yet to find anything on a dual install on the same server.

any help would be much appreciated.
Question by:telliot79
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
  • 4
  • 4
LVL 24

Accepted Solution

Joe Woodhouse earned 2000 total points
ID: 36712114
If they will always run exactly the same version (ie. if you patch/upgrade one, both get patched or upgraded) then this is easy. You install as usual, and then you just create a second instance. Yep, it really is that simple. They both use the same UNIX account, which uses the same environment, paths etc.

Each server has its own RUN_SERVER file, each has its own devices etc, they get an entry each in the interfaces file.

It gets more complicated if you want them to be able to be independent. The best way there is two different directories. You'll then need some way of sourcing a different profile (to set the environment variables to the correct directory(ies)) depending on which one you want to work with.

Author Comment

ID: 36712172
they don't need to be independent, just need to be running alongside each other. you say, "you install as usual" unfortunatly, I've not installed before, so i'm still a little unsure. I've search most of google and looks like I should use srvbuildres to run this install. is this correct? i'm doing this all from command line as well which is making me realise I'm not such an IT guru.

thanks for the help.
LVL 24

Assisted Solution

by:Joe Woodhouse
Joe Woodhouse earned 2000 total points
ID: 36712209
Take a look at the install docs on the Sybase site. You use srvbuildres only for a command-line install. You have to edit a "resource file" which has all the information you'll normally be asked during an interactive install.

If you've never installed Sybase ASE before then you have a number of things to decide before you start - network ports, where the important device files will be and how large, etc.

There is a sample resource file you can copy (and then edit the copies) available at $SYBASE/init/* (I think - doing this from memory).

You really really need to read through the docs first. Forget Google, just go straight to Sybase at http://infocenter.sybase.com/help/topic/com.sybase.dc35890_1254/pdf/installhp.pdf

Note appendix A discusses how to use resource files.

I should also point out in case you're not aware that 12.5 is unsupported and has been for some time.
Independent Software Vendors: 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!


Author Comment

ID: 36712704
this is helping. you've confirmed pretty much what I had thought. i should have said, we have our initial instance of sybase installed, I've just got to create a new copy for another testing instance.

and yes, I'm aware 12.5 isn't supported. We'll be migrating to MS SQL at some point in the near future I believe.
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 36712723
"Creating a copy" also means copying databases and the ASE configuration, so you'll have a few more steps beyond simply creating a second instance. None of that is difficult, you just have to remember to do it, and do it correctly. :)

Author Comment

ID: 36712762
sounds difficult enough... i like my wizards..... next, next, finish.

let me just get my fingers in this document and then i'll award points. thanks again for the help and prompt responses.
LVL 24

Assisted Solution

by:Joe Woodhouse
Joe Woodhouse earned 2000 total points
ID: 36712771
Just to set out what a "copy" means:

- create devices the same sizes
- create databases the same sizes, created exactly the same way on the devices (same fragments, same sizes, created in the same order - not actually necessary but so much easier this way)
- dump the databases from the original instance
- load the databases into the copy
- copy the config file from the original - do this while the copy is down, and make sure you have enough resources

You don't have to copy the config but then you won't have a copy...

Good luck! Sorry to hear your site is moving to MS SQL.

Author Closing Comment

ID: 36712836
Thanks for all the help Joe.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
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…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Suggested Courses
Course of the Month9 days, 6 hours left to enroll

764 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