UJP - 技術情報

Life is fun and easy!

不正IP報告数

Okan Sensor
 
メイン
ログイン
ブログ カテゴリ一覧

     

ASE 12.5 for Linux Install 〜Step 13 ASEの起動と終了用スクリプトを作成する〜

ASE 12.5 for Linux Install

〜Step 13 ASEの起動と終了用スクリプトを作成する〜


0.更新履歴

  • 2002.09.22 新規作成

1.はじめに

 このドキュメントでは,RedHat Linux 7.2に,Sybase Adaptive Server Enterprisee 12.5 for Linuxをインストールしたあと,起動と終了を簡単に行うためのスクリプトの作成手順を説明する.

2.終了用スクリプトを作成する

  • ASEディレクトリに移動する.
bash-2.05$ cd $SYBASE/$SYBASE_ASE
bash-2.05$ pwd
/opt/sybase-12.5/ASE
bash-2.05$ ls
ASE.csh       lib            poweredge.009  poweredge.018  poweredge.027  poweredge.bak
ASE.sh        poweredge.001  poweredge.010  poweredge.019  poweredge.028  poweredge.cfg
bin           poweredge.002  poweredge.011  poweredge.020  poweredge.029  poweredge.krg
certificates  poweredge.003  poweredge.012  poweredge.021  poweredge.030  sample
debugger      poweredge.004  poweredge.013  poweredge.022  poweredge.031  scripts
diag          poweredge.005  poweredge.014  poweredge.023  poweredge.032  sybhelp
include       poweredge.006  poweredge.015  poweredge.024  poweredge.033  symlib
init          poweredge.007  poweredge.016  poweredge.025  poweredge.034  upgrade
install       poweredge.008  poweredge.017  poweredge.026  poweredge.035  xappdefaults
bash-2.05$ 
  • installディレクトリに移動する.
bash-2.05$ cd install
bash-2.05$ ls -la
total 1664
drwxrwxr-x    3 sybase   sybase       4096 Sep 22 17:17 .
drwxrwxr-x   16 sybase   sybase       4096 Sep 22 17:34 ..
-rwx------    1 sybase   sybase        540 Sep 22 17:15 RUN_poweredge
-rwx------    1 sybase   sybase        485 Sep 22 17:17 RUN_poweredge_back
-rwx------    1 sybase   sybase        530 Sep 22 17:17 RUN_poweredge_mon
drwxrwxr-x    2 sybase   sybase       4096 Sep 22 16:41 SPR
-r-xr-xr-x    1 sybase   sybase    1647847 Jun  3  2001 auditinit
-r-xr-xr-x    1 sybase   sybase        670 Jun  3  2001 showserver
-r-xr-xr-x    1 sybase   sybase      17628 Jun  3  2001 startserver
bash-2.05$ 
  • シャットダウン用SQL文を作成する.
bash-2.05$ echo shutdown SYB_BACKUP >> shutdown.sql
bash-2.05$ echo go >> shutdown.sql
bash-2.05$ echo shutdown >> shutdown.sql
bash-2.05$ echo go >> shutdown.sql
bash-2.05$
  • 中身を確認する.
bash-2.05$ cat shutdown.sql
shutdown SYB_BACKUP
go
shutdown
go
bash-2.05$ 
  • シャットダウン用シェルを作成する.
bash-2.05$ echo $SYBASE/OCS/bin/isql -Usa -Psybase -Spoweredge -i`pwd`/shutdown.sql >> syb_shutdown.sh
bash-2.05$ 
  • 中身を確認する.
bash-2.05$ cat syb_shutdown.sh
/opt/sybase-12.5/OCS/bin/isql -Usa -Psybase -Spoweredge -i/opt/sybase-12.5/ASE/install/shutdown.sql
bash-2.05$
  • 実行権限を設定する.
bash-2.05$ chmod ogu+x syb_shutdown.sh
bash-2.05$
  • シャットダウンしてみる.
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 terminat
ed due to disconnect
bash-2.05$
  • 起動しているか確認する.
bash-2.05$ showserver
USER       PID %CPU %MEM   VSZ  RSS TTY      STAT START   TIME COMMAND
bash-2.05$ 
  • 稼働していない.

3.起動用スクリプトを作成する

  • 起動シェルを作成する.
bash-2.05$ echo `pwd`/startserver -f `pwd`/RUN_poweredge -f `pwd`/RUN_poweredge_back > syb_start.sh
bash-2.05$
  • 中身を確認する.
bash-2.05$ cat syb_start.sh
/opt/sybase-12.5/ASE/install/startserver -f /opt/sybase-12.5/ASE/install/RUN_poweredge -f /opt/sybase
-12.5/ASE/install/RUN_poweredge_back
bash-2.05$
  • 実行権限を付ける.
bash-2.05$ chmod ogu+x syb_start.sh
bash-2.05$
  • 実行してみる.
bash-2.05$ syb_start.sh
bash-2.05$ Backup Server/12.5/SWR 9617 GA/P/Linux Intel/Linux 2.2.14-5.0smp i686/main/2127/32-bit/OPT/
Thu May 24 01:34:30 2001
Confidential property of Sybase, Inc.
Copyright 1987, 2001
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA

00:00000:00000:2002/09/22 18:45:32.44 kernel  Warning: There is no valid license for ASE server produc
t. Server is booting with all the option features disabled.
00:00000:00000:2002/09/22 18:45:32.48 kernel  Using config area from primary master device.
00:00000:00000:2002/09/22 18:45:32.50 kernel  Internal run-time model set for Linux  - Native
〜略〜
00:00000:00001:2002/09/22 18:45:34.85 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2002/09/22 18:45:34.85 kernel  network name poweredge, type ether, port 5000, filter NO
NE
00:00000:00001:2002/09/22 18:45:34.87 server  Recovery complete.
00:00000:00001:2002/09/22 18:45:34.87 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2002/09/22 18:45:34.87 server  SQL Server's default sort order is:
00:00000:00001:2002/09/22 18:45:34.87 server    'bin_sjis' (ID = 50)
00:00000:00001:2002/09/22 18:45:34.87 server  on top of default character set:
00:00000:00001:2002/09/22 18:45:34.87 server    'sjis' (ID = 141).
00:00000:00001:2002/09/22 18:45:34.87 server  Master device size: 128 megabytes, or 65536 virtual page
s. (A virtual page is 2048 bytes.)

bash-2.05$
  • 起動しているか確認する.
bash-2.05$ showserver
USER       PID %CPU %MEM   VSZ  RSS TTY      STAT START   TIME COMMAND
sybase   32073  0.3  3.5 50996 36752 ?       S    18:45   0:00 /opt/sybase-12.5/ASE/bin/dataserver -spow
eredge -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 pts/0    S    18:45   0:00 /opt/sybase-12.5/ASE/bin/backupserver -Sp
oweredge_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$ 


広告スペース
Google