LFD

Information as collected from document "EBF18846_README.txt" (to be found in "EBF18846.tgz") as well as from actual experience updating a Sybase server on an internal virtual host.

Before you update to EBF 18446 you have to make sure you are on Sybase ASE ESD#4!

Status of example components described in this document
Component	Before	After
Hostname	zicklein8	zicklein8
Operating system	SLES 10 SP2	SLES 10SP2
Database server software	Sybase ASE 15.0.3 EBF 17776 ESD#4	Sybase ASE 15.0.3 (EBF 18846)
Library software	SISIS-SunRise V4.1	SISIS-SunRise V4.1

Pre-installation tasks

Obtain the appropriate software from OCLC host "newwebserver".

• for an update under SLES (32-bit) use the file "EBF18846.tgz" (MD5 sum: 68c931d779c534270b16e96e34902f37)

Verify your current Sybase ASE installation is at version 15.0.3 EBF 17776 ESD#4:

login: sisis
$ SybSQL15.0.3
Give Sybase user [sa]
1> select @@version
2> go
...
Adaptive Server Enterprise/15.0.3/EBF 17776 ESD#4/P/Linux Intel/Linux 2.6.9-42.
        ELsmp  i686/ase1503/2768/32-bit/FBO/Thu Aug 26 09:22:11 2010 

Database check

Verify that your database (here "sisis") is free of errors. To fulfill this task use the script "SYBASEcheck.sh". Due to performance reasons it is however a good idea not to perform these database checks during opening hours but at night running the script in the crontab of user "sisis". However, make sure to configure the section "MANUAL CONFIGURATION" of the script correctly!

$ SYBASEcheck.sh

Be sure to control the resulting output files under "/OCLC/backup/SYBASECHECK/infofile*"!

$ cd /OCLC/backup/SYBASECHECK
$ grep err infofile*

Backup your database

Before actually performing the actual update to EBF 18846 backup your database.

Dafür muss das Sicherungsskript bzw. eine passende SISIS-Sunrise-Version bereits installiert sein!

$ SYBASEbackup.sh -EBF17776

Which Sybase ASE version to use
 1  Sybase ASE 12.5.4
 2  Sybase ASE 15.0.3

Enter your selection [1-2] 2
Enter database name [sisis]
Enter name extension if you want [-EBF17776]
Enter backup directory [/OCLC/backup/MIGRATION-TEST] /OCLC/backup/SYBASECHECK

Backup your Sybase ASE installation

Installing this EBF will overwrite the current Sybase ASE software. Prior to installing this EBF, make sure to back up your $SYBASE directory, in case you need to roll back to the original version of the software.

Stop the running Sybase server.

# /etc/init.d/SunRiseServer stop
# /etc/init.d/sybase15.0.3 stop

Be sure to backup the following files and devices before continuing:

• the Sybase installation directory (usually "/opt/sybase/15.0.3")
• the Sybase database devices (usually "/SybaseDatabase/15.0.3")
• the Sybase transaction devices (usually "/SybaseLog/15.0.3")
• the Sybase errorlogs (usually "/var/spool/sybase/15.0.3")
• the Sybase start script "/etc/init.d/sybase15.0.3"

How and where to backup these files and devices is not part of this documentation! Nevertheless, usually it can be done as follows.

Check if there is enough space for the directories you want to backup.

# du -sh /opt/sybase \
        /SybaseDatabase/15.0.3 \
        /SybaseLog/15.0.3 \
        /var/spool/sybase/15.0.3
# df -k

Backup the needed directories.

# cd /OCLC/backup/SybaseASE-15.0.3
# for i in /opt/sybase/15.0.3 \
           /SybaseDatabase/15.0.3 \
           /SybaseLog/15.0.3 \
           /var/spool/sybase/15.0.3; \
    do tar cf - ${i} | tar xf -; done

If you don't have very much disk space, you may backup the needed directories in compressed form which may save a lot of space.

# cd /OCLC/backup/SybaseASE-15.0.3
# tar czf optsybase15.0.3.tgz /opt/sybase/15.0.3
# tar czf sybasedatabase15.0.3.tgz /SybaseDatabase/15.0.3
# tar czf sybaselog15.0.3.tgz /SybaseLog/15.0.3
# tar czf varspoolsybase15.0.3.tgz /var/spool/sybase/15.0.3

Software deployment

Updating Java Runtime Environment (JRE)

The stuff in this section has not been done yet - and there is no plan to do it

Due to security vulnerabilities that have been reported by the Java community and summarized in the Oracle/Sun Advisory at http://www.oracle.com/technetwork/topics/security/javacpufeb2011-304611.html Sybase recommends to upgrade your existing JRE version as follows.

Stop Sybase ASE as well as any Java based application such as Sybase Central, Replicator, DBISQL, Job Scheduler, etc. which uses the current JRE version in directory "/opt/sybase/15.0.3/shared".

The current JRE is stored in directory "/opt/sybase/15.0.3/shared/JRE-6_0_6_32BIT". Rename this directory in order to archive it.

login: sybase
$ cd /opt/sybase/15.0.3/shared
$ mv JRE-6_0_6_32BIT JRE-6_0_6_32BIT_obsolete

Create a new directory "/opt/sybase/15.0.3/shared/JRE-6_0_24_32BIT" and populate it with the JRE files from "Java SE Runtime Environment 6u24" where "6u24" means "Java Version 6 Update 24".

Recursively copy "/opt/sybase/15.0.3/shared/JRE-6_0_24_32BIT" to "/opt/sybase/15.0.3/shared/JRE-6_0_6_32BIT" since some Sybase components need the original JRE path and cannot operate with symbolic links.

Restart Sybase ASE.

Register the new JRE path with Sybase ASE by executing the following commands.

1> use sybpcidb
2> go
1> sp_jreconfig "update", "pca_jvm_module_path",
2> "shared/JRE-6_0_6_32BIT/lib/i386/server/libjvm.so",
3> "shared/JRE-6_0_24_32BIT/lib/i386/server/libjvm.so"
4> go

The new JRE requires more memory therefore, you may need to increase the value of the configuration option "pci memory size" similar to that below by executing the following commands.

1> use master
2> go
3> sp_configure "pci memory size", 65536
4> go

In your shell environment, prepend the new JRE run-time path to the existing LD_LIBRARY_PATH as shown below.

setenv LD_LIBRARY_PATH "$SYBASE/shared/JRE-6_0_24_32BIT/lib/i386/server:$SYBASE/shared/JRE-6_0_24_32BIT/lib/i386:$LD_LIBRARY_PATH"

Restart Sybase ASE.

Updating Sybase ASE

Remember you have to be on Sybase ASE 15.0.3 ESD#4! This update is not suitable other versions of Sybase ASE.

Stop the running Sybase server.

# /etc/init.d/SunRiseServer stop
# /etc/init.d/sybase15.0.3 stop

Copy the software into directory "/OCLC/software/SybaseASE-15.0.3".

# cp EBF18846.tgz /OCLC/software/SybaseASE-15.0.3

Uncompress the EBF. This will extract the files into a new directory named "ebf18846".

# cd /OCLC/software/SybaseASE-15.0.3
# tar xzf EBF18846.tgz

Recursively copy the extracted EBF directory contents to the directory "/opt/sybase/15.0.3" with the following command as user sybase.

# su sybase
$ cp -R ebf18846/* /opt/sybase/15.0.3
$ exit

Start the Sybase server.

# /etc/init.d/sybase15.0.3 start

Verify your current Sybase ASE installation is at version 15.0.3 EBF 18846 ESD#4.

Der SQL-Befehl "select @@version" zeigt idiotischerweise immer noch "EBF 17776 ESD#4" an - das ist aber korrekt!

Folgender Befehl funktioniert nur auf einem Rechner mit einer Installation von SISIS-Sunrise V4.0 oder höher!

# su - sisis
$ SybSQL15.0.3
Give Sybase user [sa]
1> select @@version
2> go
...
Adaptive Server Enterprise/15.0.3/EBF 17776 ESD#4/P/Linux Intel/Linux 2.6.9-42.
        ELsmp i686/ase1503/2768/32-bit/FBO/Thu Aug 26 09:22:11 2010

Auf einem Rechner ohne SISIS-Sunrise-Installation kann wie folgt geprüft werden.

# su - sisis
$ export LANG=de_DE.UTF-8          \
         SYBASE=/opt/sybase/15.0.3 \
         SYBASE_ASE=ASE-15_0
$ $SYBASE/OCS-15_0/bin/isql -Usa -Pxxxxxx -SsisisSYB
1> select @@version
2> go
1> quit

You will see that you're on Sybase ASE 18846 if your directory "$SYBASE" (usually "/opt/sybase/15.0.3") contains the following files.

# ls -ltr /opt/sybase/15.0.3
total 720
...
-rwxr-xr-x  1 sybase sybase   8992 Aug 16 15:57 EBF18846_README.txt
-rwxr-xr-x  1 sybase sybase  10699 Aug 16 15:57 EBF18846_README.html
-rwxr-xr-x  1 sybase sybase    514 Aug 16 15:57 EBF18846_Filelist.txt
-rwxr-xr-x  1 sybase sybase 494377 Aug 16 15:57 EBF18846_Buglist.txt
drwxr-xr-x 19 sybase sybase   4096 Aug 16 15:58 ASE-15_0

Anlegen von Sicherungen aller Datenbanken, einschliesslich der Datenbank "master", nachdem der Erfolg der Installation festgestellt wurde.

Auch die folgende Art der Sicherung funktioniert nur, wenn bereits SISIS-Sunrise V4.0 oder höher installiert wurde.

$ SYBASEbackup.sh -EBF18846

Which Sybase ASE version to use
 1  Sybase ASE 12.5.4
 2  Sybase ASE 15.0.3

Enter your selection [1-2] 2
Enter database name [sisis]
Enter name extension if you want [-EBF18846]
Enter backup directory [/OCLC/backup/MIGRATION-TEST] /OCLC/backup/SYBASECHECK

Entfernen des Installationsverzeichnisses.

# rm -rf /OCLC/software/SybaseASE-15.0.3/ebf18846

Weblinks

• http://www.sybase.ch/detail?id=1094235