UJP - 技術情報

Life is fun and easy!
不正IP報告数

Okan Sensor
Home Information Service Tech(Free) Tech(Member) Blog FAQ
 
メイン
ログイン

ユーザー名:


パスワード:





パスワード再発行手続き  |無料会員入会手続へ...
ブログ　カテゴリ一覧
     

EBF9622を適用する　〜Solaris版　ASE 11.9.2〜

EBF9622を適用する

〜Solaris版　ASE 11.9.2〜

０．更新履歴

  • 2001.10.20　新規作成

１．はじめに

　このドキュメントでは,Solaris8上で稼動しているSybsae Adaptive Server Enterprise 11.9.2に，EBF9622を適用し,11.9.2.5にする．

　11.9.2のままのバージョンだと,ADO経由で接続できない．

２．手順

  • sybaseユーザでログインして,現在のバージョンを確認する. 

login: sybase
Password:
Last login: Sat Oct 20 01:30:54 from 10.0.1.74
Sun Microsystems Inc.   SunOS 5.8       Generic February 2000
couldn't set locale correctly
$ isql -Usa -P -SSYBASE01
1> select @@version
2> go


        ------------------------------------------------------
--------------------------------------------------------------
--------------------------------------------------------------
--------------------------------------------------------------
---------------
         Adaptive Server Enterprise/11.9.2/1031/P/Sun_svr4/OS 
5.5.1/FBO/Fri Aug14 06:26:45 1998


(1 row affected)
1>

  • sybase.comから入手したEBF9622ファイルを展開する. 

$ ls -la
total 109156
drwxr-xr-x   6 sybase   staff        512 Oct 20 01:31 .
drwxrwxr-x  10 root     sys          512 Oct 19 20:28 ..
-rw-r--r--   1 sybase   staff          2 Oct 19 22:14 .cshrc
-rw-r--r--   1 sybase   staff        828 Oct 20 01:03 .profile
drwxr-xr-x  22 sybase   staff       1536 Oct 20 01:03 ase
drwxr-xr-x   2 sybase   staff       2048 Oct 20 00:50 bcp
drwxr-xr-x   2 sybase   staff        512 Oct 19 22:40 database
drwxr-xr-x   2 sybase   staff        512 Oct 20 01:14 dump
-rw-r--r--   1 sybase   staff     198537 Oct 20 01:31 EBF9622.ltr
-rw-r--r--   1 sybase   staff    55620246 Oct 20 01:31 EBF9622.tgz
$ gzip -d EBF9622.tgz
$ tar xvf EBF9622.tar
x ebf9622, 0 bytes, 0 tape blocks
x ebf9622/Cover.ROLL.9622, 198537 bytes, 388 tape blocks
x ebf9622/locales, 0 bytes, 0 tape blocks
x ebf9622/locales/message, 0 bytes, 0 tape blocks
x ebf9622/locales/message/us_english, 0 bytes, 0 tape blocks
x ebf9622/locales/message/us_english/bslib.loc, 36963 bytes, 73 tape blocks
x ebf9622/scripts, 0 bytes, 0 tape blocks
x ebf9622/scripts/installcommit, 16609 bytes, 33 tape blocks
x ebf9622/scripts/installsecurity, 82918 bytes, 162 tape blocks
x ebf9622/scripts/installmaster, 2161696 bytes, 4223 tape blocks
x ebf9622/scripts/installdbccdb, 153247 bytes, 300 tape blocks
x ebf9622/scripts/installdbccalt, 153280 bytes, 300 tape blocks
x ebf9622/scripts/instmsgs.ebf, 37072 bytes, 73 tape blocks
x ebf9622/bin, 0 bytes, 0 tape blocks
x ebf9622/bin/backupserver, 2399176 bytes, 4686 tape blocks
x ebf9622/bin/monserver, 2292924 bytes, 4479 tape blocks
x ebf9622/bin/dataserver, 11102232 bytes, 21685 tape blocks
x ebf9622/bin/diagbs, 8006596 bytes, 15638 tape blocks
x ebf9622/bin/diagserver, 141293228 bytes, 275964 tape blocks
x ebf9622/bin/diagsmb, 662724 bytes, 1295 tape blocks
x ebf9622/bin/diagxps, 3292920 bytes, 6432 tape blocks
x ebf9622/bin/optdiag, 1830784 bytes, 3576 tape blocks
x ebf9622/bin/sqlupgrade, 4556992 bytes, 8901 tape blocks
x ebf9622/bin/sqlupgraderes, 2277568 bytes, 4449 tape blocks
x ebf9622/bin/srvbuild, 4637560 bytes, 9058 tape blocks
x ebf9622/bin/srvbuildres, 2262164 bytes, 4419 tape blocks
x ebf9622/bin/sybmultbuf, 66308 bytes, 130 tape blocks
x ebf9622/bin/xpserver, 1607216 bytes, 3140 tape blocks
x ebf9622/lib, 0 bytes, 0 tape blocks
x ebf9622/lib/sybsyesp.so, 16620 bytes, 33 tape blocks
x ebf9622/lib/xpsmsgs.so, 25944 bytes, 51 tape blocks
x ebf9622/symlib, 0 bytes, 0 tape blocks
x ebf9622/symlib/sybsyesp.so, 21248 bytes, 42 tape blocks
x ebf9622/symlib/xpsmsgs.so, 29960 bytes, 59 tape blocks
x ebf9622/upgrade, 0 bytes, 0 tape blocks
x ebf9622/upgrade/preupgrade, 837488 bytes, 1636 tape blocks
x ebf9622/upgrade/upgrade, 1358164 bytes, 2653 tape blocks

  • インストール手順についてはEBF9622.ltr(レターファイル．テキスト)を参照すればよい.
  • ASEをシャットダウンする． 

$ isql -Usa -P -SSYBASE01
Msg 2401, Level 11, State 2:
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
1> shutdown
2> go
Server SHUTDOWN by request.
The SQL Server is terminating this process.
00:00000:00001:2001/10/20 01:55:09.59 server  SQL Server shutdown by request.
00:00000:00001:2001/10/20 01:55:09.60 kernel  ueshutdown: exiting
CT-LIBRARY error:
        ct_results(): network packet layer: internal net library error: Net-Libr
ary operation terminated due to disconnect
CT-LIBRARY error:
        ct_cancel(): network packet layer: internal net library error: Net-Libra
ry operation terminated due to disconnect
$

  • $SYBASEディレクトリ以下に，EBFを複写する.
    • 以下の様にcpコマンドを実行すると,EBF9622ディレクトリ以下のファイル等が複写される. 

$ pwd
/opt/sybase
$ ls
ase              dump             EBF9622.tar
bcp              ebf9622          mbox
database         EBF9622.ltr.txt  start_log.sql
$ cd $SYBASE
$ pwd
/opt/sybase/ase
$ cp ../EBF9622 .
$

  • ASEを起動する.
  • 次のようにスクリプトを実行する. 

$ isql -Usa -P -SSYBASE01 -i$SYBASE/scripts/installmaster -oOut.txt
00:00000:00001:2001/10/20 01:59:58.77 server  Configuration file '/
opt/sybase/ase/SYBAE01.cfg' has been written and the previous versi
on has been renamed to '/opt/sybase/ase/SYBAE01.036'.
01:00000:00001:2001/10/20 01:59:58.88 server  The configuration opt
ion 'allow up dates to system tables' has been changed by 'sa' from
 '0' to '1'.
00:00000:00001:2001/10/20 02:01:20.11 server  Configuration file '/
opt/sybase/ase/hdb.cfg' has been written and the previous version h
as been renamed to '/opt/sybase/ase/SYBAE01.037'.
01:00000:00001:2001/10/20 02:01:20.23 server  The configuration opt
ion 'allow up dates to system tables' has been changed by 'sa' from
 '1' to '0'.
$

  • もう１つ流す. 

$ isql -Usa -P -SSYBAE01 -i$SYBASE/scripts/installcommit -oOut2.txt
00:00000:00001:2001/10/20 02:02:21.29 server  Configuration file '/
opt/sybase/ase/SYBAE01.cfg' has been written and the previous versi
on has been renamed to '/opt/sybase/ase/SYBAE01.038'.
01:00000:00001:2001/10/20 02:02:21.32 server  The configuration opt
ion 'allow up dates to system tables' has been changed by 'sa' from
 '0' to '1'.
00:00000:00001:2001/10/20 02:02:22.45 server  Configuration file '/
opt/sybase/ase/hdb.cfg' has been written and the previous version h
as been renamed to '/opt/sybase/ase/SYBAE01.039'.
01:00000:00001:2001/10/20 02:02:22.47 server  The configuration opt
ion 'allow updates to system tables' has been changed by 'sa' from 
'1' to '0'.
$

  • ｄｂｃｃを使っている場合は,次のスクリプトも実行する. 

$SYBASE/scripts/installdbccdb

  • 最後にもう1発,流す. 

$ isql -Usa -P -SSYBAE01 -n -i$SYBASE/scripts/instmsgs.ebf -oOut3.txt
01:00000:00001:2001/10/20 02:03:41.97 server  WARNING: *************************
**
01:00000:00001:2001/10/20 02:03:41.97 server  Attempt by user 1 to dump xact on
db master with NO_LOG
01:00000:00001:2001/10/20 02:03:41.98 server  Attempt by user 1 to dump xact on
db master with NO_LOG was successful
01:00000:00001:2001/10/20 02:03:41.98 server  WARNING: *************************
**
00:00000:00001:2001/10/20 02:03:42.04 server  Configuration file '/opt/sybase/as
e/SYBAE01.cfg' has been written and the previous version has been renamed to '/opt/s
ybase/ase/SYBAE01.040'.
01:00000:00001:2001/10/20 02:03:42.07 server  The configuration option 'allow up
dates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2001/10/20 02:03:43.25 server  Configuration file '/opt/sybase/as
e/SYBAE01.cfg' has been written and the previous version has been renamed to '/opt/s
ybase/ase/SYBAE01.041'.
01:00000:00001:2001/10/20 02:03:43.27 server  The configuration option 'allow up
dates to system tables' has been changed by 'sa' from '1' to '0'.
$

  • 接続して,バージョンを確認してみる. 

$ isql -Usa -P -SSYBASE01 -Jsjis -zjapanese
1> select @@version
2> go





        ------------------------------------------------------
--------------------------------------------------------------
--------------------------------------------------------------
-----------------------
         Adaptive Server Enterprise/11.9.2.5/1227/P/SWR 9622 R
OLLUP/Sun_svr4/OS5.5.1/FBO/Tue Jun 12 05:26:11 2001


(1 row affected)
1>


サイトからのおしらせ

広告スペース
Google