Solved

install sybase 15.7 over 15.0.x

Posted on 2016-10-12
2
61 Views
Last Modified: 2016-10-18
Dears,
kindly note we have two servers: sybase ase 15.7 and sybase 15.0.3

I need to upgrade sybase ase 15.0.3 to ase 15.7, I read about that and I will do the following steps:
as I will install ase 15.7 over existing 15.0.3:
1- shut down all services: sybase sql server, sybase bck server, sybase xp server.
2- use setup.exe for 15.7
3- start the server : $SYBASE/$SYBASE_ASE/install/startserver
4- select @@version it should be 15.7

then I will load dump file for mydatabase taken from 15.7 not from 15.0.3 , so no problem with loading,
I want to  ask somethings:
- Are the steps which I listed enough, or I missed something??
- also I think I should load master db (also from 15.7) to get all configures and logins, is this right??
- also are there post install tasks I have to do, please advice.
0
Comment
Question by:suzn cas
2 Comments
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 41847833
Hello, just answered your related more detailed question.

If you meant to overwrite your old server in this way rather than leaving them side by side - i.e. exactly the same disks, devices, databases and logins, etc, it would be a lot easier to "upgrade in place" which is an option when installing. This would seamlessly take care of everything for you and all databases and the ASE itself would be brought up to ASE 15.7 as part of the upgrade, all logins and passwords would remain the same, etc.

If you don't want to do that or it's too late, I would have recommended installing the new version in a new directory. If you're doing a new install rather than upgrade it is cleaner to keep the new install completely separate.

If it's too late for that and you've already installed the new ASE in the same directory as the old it should probably all work fine. In this scenario you are upgrading database-by-database rather than the whole ASE.

Your sequence then to expand on my answer to your other question is:

  1. Install new ASE
  1. Create logins, set configuration
  1. Recreate all devices
  1. Recreate all databases
  1. Load databases from backup
  1. Bring databases online, which will upgrade them

Your life will be more complicated if you do not create all logins in exactly the same order they were in the old server (we want the "suids" or server-user IDs = login IDs) to match else there is a cleanup step you'll have to do after loading databases.

Your life will also be more complicated if you do not recreate devices and databases exactly the same as they were in the old environment. It isn't required but if they don't match exactly you can end up with strange things happening in terms of data & log being mixed when before they were separated.

The completely new install is the most powerful method and offers the most opportunity for customisation and changing things, but it is also the most demanding in terms of effort and skill. Your scenario is actually the perfect candidate for "upgrade in place".

That's doesn't mean you're out of luck, absolutely we can get you to where you need to be in your current situation also.

It's to the point where if you have a complete backup of this server I might think it was less work overall to restore to a fully working ASE 15.0.3 environment before you did anything with ASE 15.7, and then start over with upgrade-in-place. You'll find that excellently documented in the Install Guide and Config Guide manuals, available for free from sap.com, and I've also attached them here.
ASE-15.7-Installation-Guide-for-Wind.pdf
ASE-15.7-Configation-Guide-for-Windo.pdf
1
 

Author Closing Comment

by:suzn cas
ID: 41847998
Dear Joe, Thank you very much
although I have done the installation, your suggestions are still helpfully, especially cause I need to upgrade other sybase ase 15.0.3 servers to 15.7 next days,
thanks for help.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

789 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