Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

install sybase 15.7 over 15.0.x

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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

While opting for any web-to-print solution, you need to discuss with your team and some of your end users and know their opinions about your decisions. In this article we list down some questions you need to ask yourself.
In this article, I’ll show how research, determination, and use of modern technology helped me solve a DNA mystery.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

705 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