Solved

install sybase 15.7 over 15.0.x

Posted on 2016-10-12
2
22 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

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

Suggested Solutions

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
A Short Story about the Best File Recovery Software – Acronis True Image 2017
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 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

19 Experts available now in Live!

Get 1:1 Help Now