Solved

install sybase 15.7 over 15.0.x

Posted on 2016-10-12
2
76 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
[X]
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
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
Read our guide on how to survive being on-call.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

740 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