Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

install sybase 15.7 over 15.0.x

Posted on 2016-10-12
2
Medium Priority
?
206 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 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month10 days, 21 hours left to enroll

885 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