Solved

sybase 12.5 install a another instance: HP-UX

Posted on 2011-09-27
8
454 Views
Last Modified: 2012-05-12
experts,

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.
0
Comment
Question by:telliot79
  • 4
  • 4
8 Comments
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 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.
0
 

Author Comment

by:telliot79
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.
0
 
LVL 24

Assisted Solution

by:Joe Woodhouse
Joe Woodhouse earned 500 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.
0
 

Author Comment

by:telliot79
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.
0
Highfive Gives IT Their Time Back

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!

 
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. :)
0
 

Author Comment

by:telliot79
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.
0
 
LVL 24

Assisted Solution

by:Joe Woodhouse
Joe Woodhouse earned 500 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.
0
 

Author Closing Comment

by:telliot79
ID: 36712836
Thanks for all the help Joe.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A metadevice consists of one or more devices (slices). It can be expanded by adding slices. Then, it can be grown to fill a larger space while the file system is in use. However, not all UNIX file systems (UFS) can be expanded this way. The conca…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
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…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

744 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

11 Experts available now in Live!

Get 1:1 Help Now