Sybase: Upgrading ASE12.5.3 to ASE12.5.4

The current version of Sybase is:

1> select @@version;
Adaptive Server Enterprise/12.5.3/EBF 12331 ESD#1/P/Sun_svr4/OS 5.8/ase1253/1900/64-bit/FBO/Tue Jan 25 08
:52:58 2005

and it needs to updated to ASE-12.5.4 ESD#3, but before the upgrade starts its essential that both the databases be and the application directory be backed up. Luckily a backup and done every week. The following will be done for this upgrade of Sybase.

  1. Backup the existing sybase directory. The sybase path is: /opt/sybase_server/ase12.5 and the backup should be done as the root user.
  2. Shutdown the Backup server. This is optional as it will have no effect on tshe upgrade.
  3. Shutdown the Sybase server.
  4. Install ASE12.5.4 and ESD#3 over the existing sybase path.
  5. Start the sybase server and verify that we have the correct version.
  6. Run the installmaster script to update stored procedures.


  1. Backup the existing sybase directory:
    bash-2.05# tar -cvf – ase12.5 | gzip -c > ase12.5.before_upgrade_to_1254esd3.tar.gz
    a ase12.5/ 0K
    a ase12.5/ASE-12_5/ 0K
    a ase12.5/ASE-12_5/SC-3_0/ 0K
    a ase12.5/ASE-12_5/SC-3_0/bin/ 0K
    a ase12.5/ASE-12_5/SC-3_0/bin/ase_monitor 2012K
    a ase12.5/ASE-12_5/SC-3_0/bin/ase_monitor_start 3K
    a ase12.5/ASE-12_5/SC-3_0/bin/ase_monitor_stop 3K
    a ase12.5/ASE-12_5/SC-3_0/bin/ase_start 13K
    a ase12.5/ASE-12_5/SC-3_0/bin/ase_stop 13K
    a ase12.5/ASE-12_5/SC-3_0/bin/ase_update 3K
    a ase12.5/ASE-12_5/SC-3_0/bin/ase_validate 13K
    …edited…
    a ase12.5/uninstall/ASESuite/uninstall.jar 3921K
    a ase12.5/uninstall/ASESuite/uninstall.dat 58K
    a ase12.5/uninstall/ASESuite/ismp.jar 419K
    a ase12.5/uninstall/ASESuite2/ 0K
    a ase12.5/uninstall/ASESuite2/uninstall 819K
    a ase12.5/uninstall/ASESuite2/uninstall.jar 5311K
    a ase12.5/uninstall/ASESuite2/uninstall.dat 59Kbash-2.05# ls
    ase12.5 ase12.5.before_upgrade_to_1254esd3.tar.gz

    bash-2.05# du -skh *.gz
    713M ase12.5.before_upgrade_to_1254esd3.tar.gz

  2. Shutdown the Backup server. This is optional as it will have no effect on the upgrade.

  3. $ ssh sybase@db_server
    $ isql -Usa -P -Sdb_server
    1> shutdown SYB_BACKUP
    2> go

  4. Shutdown the Sybase server.

  5. $ isql -Usa -P -Sdb_server
    1> shutdown

    Note: If the shutdown takes “forever” the with nowait can be appended to the shutdown command.

  6. Install ASE12.5.4 and ESD#3 over the existing sybase path.
  7. $ cd /ase12.5.4
    $ ./setup

    Follow the instructions on the GUI. When presented with the Check boxes to install a new server, make sure they are unchecked. Repeat the same for the ESD#3 patch.

  8. Start the sybase server and verify that we have the correct version.
  9. Run the “installmaster”, “install commit” and “ebf msgs”  scripts to update stored procedures.
  10. bash-2.05$ isql -Usa -P -S<DB_SERVER> -n -i installmaster -i /tmp/log/installmaster.log
    bash-2.05$ isql -Usa -P -S<DB_SERVER> -n -i installcomm -i /tmp/log/ebf.msgs.log
    bash-2.05$ isql -Usa -P -S<DB_SERVER> -n -i ebf.msgs -i /tmp/log/ebf.msgs.log

    —————————————————————————————————————————————————————————————————————————————————————
    Adaptive Server Enterprise/12.5.4/EBF 14065 ESD#3/P/Sun_svr4/OS 5.8/ase1254/203
    0/64-bit/FBO/Sat Oct 14 07:19:31 2006

    (1 row affected)
    (1 row affected)
    …edited…
    Installing sp_sysmon_dcache
    Installing sp_sysmon_pcache
    Installing sp_sysmon_memory
    Installing sp_sysmon_recovery
    Installing sp_sysmon_diskio
    (1 row affected)
    spt_sybdrv created!
    Installed sp_oledb_datatype_info

    Installed oledb_mda Stored Procedures …

Advertisements
This entry was posted in Sybase. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s