Tuesday 8 November 2011

UPGRADE FROM ASE-15.0.2 to ASE-15.0.3

Step for UPGRADE FROM ASE-15.0.2 to ASE-15.0.3


1) HAVE SA INSTALL ASE 15.0.3 Binaries in seperate partition

2) HAVE SA point link '150' in /optware/sybase to ase1503a

3)TAKE BACKUP OF USER DATABASES and MASTER

dump database userdb1 , master  model below mentioned :-

"/sybdump/ASE_PRI/BACKUP_DONT_DELETE/userdb1.dmp"

"/sybdump/ASE_PRI/BACKUP_DONT_DELETE/master.dmp"

"/sybdump/ASE_PRI/BACKUP_DONT_DELETE/model.dmp"

5)TAKE BCP OUT OF BELOW TABLES:-

COPY BELOW FILES AS MENTIONED
cp $SYBASE/interfaces  /optware/sybase/ase1503a
cp $SYBASE/$SYBASE_ASE/ASE_PRI.cfg  /optware/sybase/ase1503a/ASE-15*
cp $SYBASE/$SYBASE_OCS/config/libtcl.cfg /optware/sybase/ase1503a/$SYBASE_OCS/config/
cp $SYBASE/SYSAM-2_0/licenses/*.lic       /optware/sybase/ase1503a/SYSAM-2_0/licenses/
cp /optware/sybase/150/ASE-15_0/install/RUN_*    /optware/sybase/ase1503a/ASE-15_0/install/

5) ENSURE THAT $SYBASE IS POINTING TO NEW BINARIES

6)SHUTDOWN OLD 15.0.2 SERVER

7)START Server from NEW $SYBASE.

8)VERIFY SERVER VERSION

9)EXECUTE BELOW COMMANDS:-

isql -Usa -SASE_PRI -iinstallmaster -oinstallmaster.out
isql -Usa -SASE_PRI -iinstallcommit -oinstallcommit.out
isql -Usa -SASE_PRI -iinstallmsgsvss -oinstallmsgsvss.out

10) Generate License from SPDC and place it in appropriate dir

11) RESTART SERVER

No comments:

Post a Comment