Skip to Content

install sybase 15.7 over 15.0.3

Dears,
kindly note we have two servers: sybase ase 15.7 and sybase 15.0.3

I need to upgrade the server which holds 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 my configures and logins, is this right??
- also are there postinstalling tasks I have to do, please advice.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 12, 2016 at 07:35 PM

    Sounds like you're doing an in-place upgrade, ie, the database devices will not be moving and will instead be used by the new ASE 15.7 instance. This would include *ALL* database devices including the 'master' device (which houses the master database) ... so no need to load the master database into the new. Under this scenario the ASE 15.0.3 instance ceases to exist once the ASE 15.7 is started up (ie, you can't run 2 instances on top of a single set of database devices.] During the initial startup of the ASE 15.7 instance, all databases (system - including master; all user databases) will be upgraded (tail the dataserver errorlog to watch messages re: individual database upgrade operations).

    If however you're planning on bringing up the ASE 15.7 instance on a different machine, or you plan on having the ASE 15.0.3 and ASE 15.7 instance available at the same time, then yeah ... loading the master database may be required. [When you start talking about copying the master database you start getting into more advanced issues - hard to tell without going into a lot more detail on your upgrade plan.]

    -----

    A couple suggestions for your upgrade ...

    1 - you mention installing 15.7 *over* 15.0.3; I take this to mean you're going to use the same $SYBASE directory (currently contains the 15.0.3 code; will be overwritten with the 15.7 code); I'd highly recommend you consider renaming/moving the 15.0.3/$SYBASE directory, then install the 15.7 code under a brand new/empty $SYBASE directory; you'll want to copy over your interfaces, sysam/$DSQUERY.properties, RUN_* and $DSQUERY.cfg files; update the RUN_* files to reference the new $SYBASE directory (if needed); this has a couple benefits:

    1a - you start with a clean install of the software, and no need to worry about any leftover/lingering files from the old 15.0.3 install

    1b - if you find that you need to go back to the 15.0.3 installation, then just move/rename the $SYBASE directories (as needed); otherwise you'll need to rerun the 'setup.bin' for the old 15.0.3 codeline

    2 - make sure you make a backup of *ALL* 15.0.3 databases (including all system database; exclude tempdb databases); in the event you have to rollback the 15.7 installation ... switch to the 15.0.3 $SYBASE directory, startup the 15.0.3 instance in single user mode, load the 15.0.3 copy of the master database, then reload all of your 15.0.3 databases

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2016 at 05:02 PM

    Dear Mark,

    Thank you for your explanation.

    kindly let me mention why I was asking for loading master db, maybe it is a special case related to me, cause the new dump for my db taken from 15.7 has some changes over my db on the 15.0.3 version, i.e there are some new objects & indexes (they will be located in master..sysobjects , master..sysindexes), so am I in the right way???

    something else I think to do after load mydb dump, is to issue update index statistics for all tables, I know the last statistics are stored in the dump, but because I load this dump on new machine, what do you advice about this point??

    As you suggested (with all thanks): I will take a backup of 15.0.3/$SYBASE directory,

    and I will install the new version over this directory (15.0.3/$SYBASE) but kindly note it is empty, because I will remove its content after taking a backup of it, so I won't need to update RUN_ file, will I ???

    please excuse me cause I am new to sybase,

    Last question, can we say this way is smoother than using the following utilities: pre-upgrade, upgrade, or this is another thing completely different???

    Thanks in Advance

    ,

    Dear Mark,

    Thank you for your explanation.

    kindly let me mention why I was asking for loading master db, maybe it is a special case related to me, cause the new dump for my db taken from 15.7 has some changes over my db on the 15.0.3 version, i.e there are some new objects & indexes (they will be located in master..sysobjects , master..sysindexes), so am I in the right way???

    something else I think to do after load mydb dump, is to issue update index statistics for all tables, I know the last statistics are stored in the dump, but because I load this dump on new machine, what do you advice about this point??

    As you suggested (with all thanks): I will take a backup of 15.0.3/$SYBASE directory,

    and I will install the new version over this directory (15.0.3/$SYBASE) but kindly note it is empty, because I will remove its content after taking a backup of it, so I won't need to update RUN_ file, will I ???

    please excuse me cause I am new to sybase,

    Last question, can we say this way is smoother than using the following utilities: pre-upgrade, upgrade, or this is another thing completely different???

    Thanks in Advance

    Add comment
    10|10000 characters needed characters exceeded

    • When you startup the dataserver the first time using the 15.7 software, the objects in the master database will be auto-magically updated by the software (eg, new system tables will be created as needed, new columns will be added to system tables as needed, new config parameters will be created, etc). Thus there's no need to load a 15.0.3 dump of the master database into the 'new' 15.7 dataserver.

      Since you're upgrading from 15.0.3 to 15.7 you shouldn't need to run update (index) stats; on the other hand it doesn't hurt anything if you go ahead and run a new set of update (index) stats ... that's your call.

      If you remove the contents of the 15.0.3/$SYBASE directory then you'll lose your current interfaces/sysam+properties/RUN*/*cfg files and will have to either a) retrieve them from the 15.0.3/$SYBASE backup, b) build a 15.7 dataserver from scratch, or c) manually reproduce said files. If you have space on your filesystem I suggest you consider renaming the 15.0.3/$SYBASE directory, install the 15.7 software under the desired $SYBASE directory, then copy these special files (interfaces, RUN*, *cfg, sysam/properties) files from the renamed 15.0.3/$SYBASE directories to the new 15.7/$SYBASE directories.

      The pre-upgrade/upgrade steps are typically used for switching between different major ASE releases (eg, ASE 12.5.x to ASE 15.x; ASE 15.x to ASE 16), or if the documentation explicitly states the need to use the pre-upgrade/upgrade steps for a given upgrade path. Having said that, it wouldn't hurt to run the pre-upgrade steps to see if any issues are reported; with the idea being to fix said issues (and verify fixed by running the pre-upgrade steps again) before bringing the dataserver up on the new 15.7 software.

  • Oct 16, 2016 at 06:57 AM

    Dear Mark,

    Thank you very much

    You have made everything clearer.

    Add comment
    10|10000 characters needed characters exceeded