EBF10431をあてるとASE12.5.0.1 ESD#2になる for Linux
EBF10431をあてるとASE12.5.0.1 ESD#2になる for Linux
0.改訂履歴
- 2002.09.22 新規作成
- 2002.09.27 重大な間違いがあったので修正.
- 2002.09.28 エラーがでる場合の対処方法を追加.
1.はじめに
このドキュメントでは,Linux版ASE12.5に,EBF10431というパッチを適用し,ASE12.5.0.1ESD#2というバージョンにするための手順を説明する.
なお,使用しているSybaseは,RedHat Linux 7.2上で稼働しているASE12.5である.
2.ASEの状態の確認
bash-2.05$ isql -Usa -Psybase -Spoweredge -Jsjis -zus_english
1> select @@version
2> go
---------------------------------------------------------------------------------
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
----------
Adaptive Server Enterprise/12.5/SWR 9617 GA/P/Linux Intel/Linux 2.2.14-5.0smp i6
86/main/1647/32-bit/OPT/Fri Jun 1 15:04:59 2001
(1 row affected)
1> quit
bash-2.05$
|
- パッチのあたっていない12.5.
- ASEをシャットダウンする.
bash-2.05$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
sybase 32073 0.0 4.0 50996 41664 ? S 18:45 0:04 /opt/sybase-12.5/ASE/bin
/dataserver -spoweredge -d/opt/sybase-12.5/database/sysdevice/master.dat -e/opt/sybase-
12.5/database/log/sqlserver.log -c/opt/sybase-12.5/ASE/poweredge.cfg -M/opt/sybase-12.5
/ASE
sybase 32075 0.0 0.5 8856 5500 ? S 18:45 0:00 /opt/sybase-12.5/ASE/bin
/backupserver -Spoweredge_back -e/opt/sybase-12.5/database/log/backup.log -Ljapanese -
Jsjis -N25 -C20 -M/opt/sybase-12.5/ASE/bin/sybmultbuf
bash-2.05$ syb_shutdown.sh
Msg 2401, Level 11, State 2:
Server 'poweredge':
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
Due to previous errors, the language for this session is being forced to
'us_english'.
Backup Server: 3.48.1.1: The Backup Server will go down immediately.
Terminating sessions.
Server SHUTDOWN by request.
The SQL Server is terminating this process.
CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library
operation terminated due to disconnect
bash-2.05$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
bash-2.05$
|
3.OS等の環境を確かめる
bash-2.05$ rpm -qa | grep kernel-2
kernel-2.4.7-10
bash-2.05$
|
bash-2.05$ rpm -qa | grep glibc-2
glibc-2.2.4-13
bash-2.05$
|
4.パッチをみる
bash-2.05$ ls -la
total 347704
drwxr-xr-x 2 sybase sybase 4096 Sep 22 19:49 .
drwxrwxr-x 20 sybase sybase 4096 Sep 22 19:49 ..
-rw-r--r-- 1 sybase sybase 252293 Sep 22 19:49 ebf10431.ltr
-rw-r--r-- 1 sybase sybase 355427001 Sep 22 19:51 ebf10431.tgz
bash-2.05$
|
bash-2.05$ gunzip -S .tgz ebf10431.tgz
bash-2.05$
|
bash-2.05$ ls -la
total 491216
drwxr-xr-x 2 sybase sybase 4096 Sep 22 20:02 .
drwxrwxr-x 20 sybase sybase 4096 Sep 22 19:49 ..
-rw-r--r-- 1 sybase sybase 252293 Sep 22 19:49 ebf10431.ltr
-rw-r--r-- 1 sybase sybase 502241280 Sep 22 19:51 ebf10431.tar
bash-2.05$
|
[root@poweredge opt]# tar xf ebf10431.tar
[root@poweredge opt]#
|
bash-2.05$ du -sk ebf10431
492068 ebf10431
bash-2.05$
|
bash-2.05$ cd ebf10431
bash-2.05$ ls -al
total 272
drwxr-xr-x 5 sybase sybase 4096 Aug 10 09:18 .
drwxr-xr-x 3 sybase sybase 4096 Sep 22 20:06 ..
-rw-r--r-- 1 sybase sybase 252293 Aug 10 00:44 Cover.ROLL.10431
drwxr-xr-x 10 sybase sybase 4096 Mar 13 2002 PC-Client
drwxr-xr-x 5 sybase sybase 4096 Aug 10 09:16 PDF
drwxr-xr-x 2 sybase sybase 4096 Aug 10 09:03 RPMS
bash-2.05$ cd RPMS
bash-2.05$ ls -la
total 255508
drwxr-xr-x 2 sybase sybase 4096 Aug 10 09:03 .
drwxr-xr-x 5 sybase sybase 4096 Aug 10 09:18 ..
-rw-r--r-- 1 sybase sybase 51295495 Aug 10 07:36 sybase-ase-12.5.0.1-3.i386.rpm
-r--r--r-- 1 sybase sybase 807230 May 31 06:14 sybase-chinese-12.5.0.1-2.i386.rpm
-rw-r--r-- 1 sybase sybase 73793899 Aug 10 07:18 sybase-common-12.5.0.1-5.i386.rpm
-rw-r--r-- 1 sybase sybase 59168329 Aug 10 09:24 sybase-doc-12.5.0.1-3.i386.rpm
-r--r--r-- 1 sybase sybase 58733344 May 22 06:07 sybase-efts-12.5.0.1-2.i386.rpm
-r--r--r-- 1 sybase sybase 3300716 May 31 06:13 sybase-french-12.5.0.1-2.i386.rpm
-r--r--r-- 1 sybase sybase 3456509 May 31 06:14 sybase-german-12.5.0.1-2.i386.rpm
-r--r--r-- 1 sybase sybase 1696908 May 31 06:14 sybase-japanese-12.5.0.1-2.i386.rpm
-r--r--r-- 1 sybase sybase 843098 May 31 06:14 sybase-korean-12.5.0.1-2.i386.rpm
-r--r--r-- 1 sybase sybase 1042984 May 31 06:14 sybase-polish-12.5.0.1-2.i386.rpm
-r--r--r-- 1 sybase sybase 3218588 May 31 06:15 sybase-portuguese-12.5.0.1-2.i386.rpm
-r--r--r-- 1 sybase sybase 3181764 May 31 06:15 sybase-spanish-12.5.0.1-2.i386.rpm
-r--r--r-- 1 sybase sybase 767019 May 31 06:16 sybase-thai-12.5.0.1-2.i386.rpm
bash-2.05$
|
5.パッチをあてる
bash-2.05$ su
Password:■■
[root@poweredge RPMS]#
|
[root@poweredge RPMS]# rpm -Uhv sybase-common-12.5.0.1-5.i386.rpm
Preparing... ########################################### [100%]
1:sybase-common ########################################### [100%]
chmod: getting attributes of `/opt/sybase-12.5/EBF10431/ebf10431/PC-Client/Sybase': No such file or directory
chmod: getting attributes of `Central': No such file or directory
chmod: getting attributes of `3.2': No such file or directory
chmod: getting attributes of `/opt/sybase-12.5/EBF10431/ebf10431/PC-Client/Sybase': No such file or directory
chmod: getting attributes of `Central': No such file or directory
chmod: getting attributes of `3.2/java': No such file or directory
[root@poweredge RPMS]#
|
[root@poweredge RPMS]# rpm -Uhv sybase-ase-12.5.0.1-3.i386.rpm
Preparing... ########################################### [100%]
1:sybase-ase ########################################### [100%]
chmod: getting attributes of `/opt/sybase-12.5/EBF10431/ebf10431/PC-Client/Sybase': No such file or directory
chmod: getting attributes of `Central': No such file or directory
chmod: getting attributes of `3.2': No such file or directory
chmod: getting attributes of `/opt/sybase-12.5/EBF10431/ebf10431/PC-Client/Sybase': No such file or directory
chmod: getting attributes of `Central': No such file or directory
chmod: getting attributes of `3.2/java': No such file or directory
[root@poweredge RPMS]#
|
[root@poweredge RPMS]# rpm -Uhv sybase-japanese-12.5.0.1-2.i386.rpm
Preparing... ########################################### [100%]
1:sybase-japanese ########################################### [100%]
chmod: getting attributes of `/opt/sybase-12.5/EBF10431/ebf10431/PC-Client/Sybase': No such file or directory
chmod: getting attributes of `Central': No such file or directory
chmod: getting attributes of `3.2': No such file or directory
chmod: getting attributes of `/opt/sybase-12.5/EBF10431/ebf10431/PC-Client/Sybase': No such file or directory
chmod: getting attributes of `Central': No such file or directory
chmod: getting attributes of `3.2/java': No such file or directory
[root@poweredge RPMS]#
|
[root@poweredge RPMS]# exit
bash-2.05$
|
bash-2.05$ syb_start.sh
bash-2.05$ 00:00000:00000:2002/09/22 20:34:18.69 kernel Warning: There is no valid license for ASE server
product. Server is booting with all the option features disabled.
Backup Server/12.5.0.1/EBF 10431 ESD#2/P/Linux Intel/Linux 2.2.14-5.0smp i686/rel125x/2212/32-bit/OPT/Wed
Jun 12 23:54:59 2002
Confidential property of Sybase, I
|
6.システムテーブルを更新する
- 新しくなったメッセージを更新するファイルを確認する.
bash-2.05$ ls -la $SYBASE/ASE-12_5/scripts/instmsgs.ebf
-r--r--r-- 1 sybase sybase 38799 May 8 04:16 /opt/sybase-12.5/ASE-12_5/scripts/instmsgs.ebf
bash-2.05$
|
bash-2.05$ isql -Usa -Psybase -Spoweredge -i/opt/sybase-12.5/ASE-12_5/scripts/instmsgs.ebf
Msg 2401, Level 11, State 2:
Server 'poweredge':
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
Due to previous errors, the language for this session is being forced to
'us_english'.
00:00000:00008:2002/09/22 20:35:40.41 server WARNING: ***************************
00:00000:00008:2002/09/22 20:35:40.41 server Attempt by user 1 to dump xact on db master with NO_LOG
00:00000:00008:2002/09/22 20:35:40.43 server Attempt by user 1 to dump xact on db master with NO_LOG was
successful
00:00000:00008:2002/09/22 20:35:40.43 server WARNING: ***************************
00:00000:00008:2002/09/22 20:35:40.68 server Configuration file '/opt/sybase-12.5/ASE/poweredge.cfg' has
been written and the previous version has been renamed to '/opt/sybase-12.5/ASE/poweredge.036'.
00:00000:00008:2002/09/22 20:35:40.69 server The configuration option 'allow updates to system tables' h
as been changed by 'sa' from '0' to '1'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
----------- -------------------- ----------
allow updates to system tables 0 0 1
1 switch dynamic
Configuration option changed. The SQL Server need not be rebooted since the
option is dynamic.
Changing the value of 'allow updates to system tables' does not increase the
amount of memory SQL Server uses.
(return status = 0)
Adding Message: 446 Severity: 16
(return status = 0)
Modifying Message: 526 Severity: 18
(return status = 0)
Modifying Message: 603 Severity: 17
(return status = 0)
Modifying Message: 622 Severity: 20
(return status = 0)
Modifying Message: 875 Severity: 20
(return status = 0)
Modifying Message: 905 Severity: 17
(return status = 0)
Modifying Message: 905 Severity: 17
(return status = 0)
Modifying Message: 1265 Severity: 20
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
Adding Message: 1772 Severity: 10
(return status = 0)
Modifying Message: 2786 Severity: 16
(return status = 0)
(return status = 0)
Adding Message: 2843 Severity: 16
(return status = 0)
Adding Message: 2904 Severity: 16
(return status = 0)
Adding Message: 3751 Severity: 0
(return status = 0)
Adding Message: 3752 Severity: 0
(return status = 0)
(return status = 0)
Modifying Message: 3927 Severity: 17
(return status = 0)
Modifying Message: 4022 Severity: 10
(return status = 0)
Adding Message: 4626 Severity: 16
(return status = 0)
Adding Message: 4627 Severity: 16
(return status = 0)
Adding Message: 4628 Severity: 16
(return status = 0)
Adding Message: 4629 Severity: 16
(return status = 0)
Modifying Message: 5124 Severity: 10
(return status = 0)
Adding Message: 5164 Severity: 10
(return status = 0)
Adding Message: 5165 Severity: 16
(return status = 0)
Adding Message: 5166 Severity: 16
(return status = 0)
Modifying Message: 7105 Severity: 22
(return status = 0)
Adding Message: 7157 Severity: 16
(return status = 0)
Adding Message: 7158 Severity: 10
(return status = 0)
Adding Message: 7159 Severity: 10
(return status = 0)
Modifying Message: 8207 Severity: 17
(return status = 0)
Modifying Message: 9827 Severity: 10
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
Adding Message: 10503 Severity: 0
(return status = 0)
Adding Message: 10504 Severity: 0
(return status = 0)
Adding Message: 10505 Severity: 0
(return status = 0)
Adding Message: 10506 Severity: 0
(return status = 0)
Adding Message: 10507 Severity: 0
(return status = 0)
Adding Message: 10508 Severity: 0
(return status = 0)
Adding Message: 10509 Severity: 0
(return status = 0)
Adding Message: 10510 Severity: 0
(return status = 0)
(return status = 0)
Modifying Message: 10812 Severity: 20
(return status = 0)
Adding Message: 10847 Severity: 16
(return status = 0)
Adding Message: 10848 Severity: 16
(return status = 0)
Adding Message: 10849 Severity: 16
(return status = 0)
Modifying Message: 10901 Severity: 17
(return status = 0)
Modifying Message: 10902 Severity: 17
(return status = 0)
Adding Message: 11060 Severity: 16
(return status = 0)
Modifying Message: 11060 Severity: 16
(return status = 0)
Adding Message: 11497 Severity: 20
(return status = 0)
Adding Message: 11749 Severity: 15
(return status = 0)
Modifying Message: 12511 Severity: 20
(return status = 0)
Modifying Message: 12512 Severity: 16
(return status = 0)
Adding Message: 12540 Severity: 10
(return status = 0)
Adding Message: 12541 Severity: 10
(return status = 0)
Adding Message: 12542 Severity: 16
(return status = 0)
Modifying Message: 12542 Severity: 16
(return status = 0)
Modifying Message: 12542 Severity: 16
(return status = 0)
Adding Message: 12543 Severity: 20
(return status = 0)
Modifying Message: 12543 Severity: 20
(return status = 0)
Adding Message: 12544 Severity: 0
(return status = 0)
Adding Message: 12829 Severity: 16
(return status = 0)
Adding Message: 12830 Severity: 16
(return status = 0)
Modifying Message: 12909 Severity: 16
(return status = 0)
Modifying Message: 12938 Severity: 16
(return status = 0)
Adding Message: 12954 Severity: 16
(return status = 0)
Adding Message: 12955 Severity: 16
(return status = 0)
Adding Message: 12956 Severity: 10
(return status = 0)
Adding Message: 13940 Severity: 16
(return status = 0)
Adding Message: 14023 Severity: 10
(return status = 0)
Adding Message: 14216 Severity: 16
(return status = 0)
Adding Message: 14400 Severity: 10
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
german language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
french language is not installed
(return status = 0)
00:00000:00008:2002/09/22 20:35:41.87 server Configuration file '/opt/sybase-12.5/ASE/poweredge.cfg'
has been written and the previous version has been renamed to '/opt/sybase-12.5/ASE/poweredge.037'.
00:00000:00008:2002/09/22 20:35:41.88 server The configuration option 'allow updates to system tables'
has been changed by 'sa' from '1' to '0'.
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
----------- -------------------- ----------
allow updates to system tables 0 0 0
0 switch dynamic
Configuration option changed. The SQL Server need not be rebooted since the
option is dynamic.
Changing the value of 'allow updates to system tables' does not increase the
amount of memory SQL Server uses.
(return status = 0)
bash-2.05$
|
- システムテーブルを変更するので,ダンプを取ってデータを更新しているみたいです.
7.パッチがあたったか確認する
bash-2.05$ isql -Usa -Psybase -Spoweredge -Jsjis -zus_english
1> select @@version
2> go
------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------
--------------------------------------------------------------------------
Adaptive Server Enterprise/12.5.0.1/EBF 10431 ESD#2/P/Linux Intel/Linux 2.2.14-5
.0smp i686/rel12501/1792/32-bit/OPT/Mon Jul 29 22:24:47 2002
(1 row affected)
1>
|