|
Sybase ASE 11.0.3.3 ESD#6 for Linuxが使えるまで
Sybase ASE 11.0.3.3 ESD#6 for Linuxが使えるまで
０．更新履歴
- 2001.09.06 新規作成
- 2001.09.09 情報ちょっと追加
１．はじめに
このドキュメントでは，RedHatLinux6.2に無償版のSybase Adaptive Server 11.0.3.3
#ESD6をインストールする手順を説明する．
２．無償版のSybaseについて
２．１．入手方法
無償版のSybaseは，今から3世代前のバージョンとなる． 入手先としては次の２つとなる．
- Sybase社のWebページ
- 書籍
- 詳解 SYBASE SQL SERVER on LINUX
- ISBN4-274-07881-7 オーム社
今回利用したのは，米国Sybase社からダウンロードした，ASE
11.0.3.3 ESD#6というモジュールである．
パッケージファイル
|
ファイル名 |
説明 |
|
sybase-ase-11.0.3.3-6.i386.rpm |
Sybase本体と言語ライブラリなど． |
|
sybase-ocsd-10.0.4-6.i386.rpm |
OpenClient/Serverのモジュール． |
このインストールについては，前出「詳解 SYBASE SQL
SERVER on LINUX」を参考にしているが，本とはバージョンが異なるため，インストール方法等に違いがある．
２．２．ライセンスについて
ここで入手した無償版のSybaseについては，開発および商用利用（インターネット公開含む）で完全に無償である．
また，クライアントソフトウェアについても無償であるので，インターネット系サーバで複数台のWebサーバにクライアントをインストールして利用しても良い．
今回導入するASE 11.0.3.3 for Linuxには，次のようなパッケージが含まれている．
- ASE for Linuxのランタイム
- 開発環境
- 日本語を含む言語モジュール
- OpenClient/Serverライブラリ
３．環境について
- 今回のインストールは，次のようなマシン上で行った．
[shin@takaken /opt]$ cat /etc/redhat-release
Red Hat Linux release 6.2 (Zoot)
[shin@takaken /opt]$ uname -a
Linux takaken.Xo.jp 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 i686
unknown
[shin@takaken /opt]$ dmesg|grep mem
Memory: 192736k/196544k available (1060k kernel code, 416k reserved,
2268k data, 64k init, 0k bigmem)
Freeing unused kernel memory: 64k freed
[shin@takaken /opt]$ df -k
Filesystem 1k-blocks Used Available Use% Mounted on
/dev/hda2 4134932 949240 2975644 24% /
/dev/hda3 8617868 1104 8178996 0% /root
[shin@takaken /opt]$
|
- RedHatLinuxについては，特にDBを稼動させるための諸設定を行ったものではなく，スライスですら適当にきったものである．
- また，インストール中にDBA用のsybaseユーザとsybaseグループが作成される．
４．インストール手順
- デフォルトでは，/opt/sybaseにインストールされる．
- rpmで自動的にディレクトリを作成してくれるので，あらかじめ用意する必要は無い．
- rootユーザでログインする．
- パッケージ管理用のファイルを更新するために，rootユーザ権限が必要．
- パッケージをインストールする．
[root@takaken /opt]# ls
sybase-ase-11_0_3_3-6_i386.rpm sybase-ocsd-10.0.4-6.i386.rpm
[root@takaken /opt]# rpm -i sybase-ase-11_0_3_3-6_i386.rpm
[root@takaken /opt]# rpm -i sybase-ocsd-10.0.4-6.i386.rpm
[root@takaken /opt]# du -s /opt/sybase
127116 /opt/sybase
[root@takaken /opt]#
|
- /opt/sybase/install/sybinstall.shを実行する．
- ライセンス関連の文書が表示され，必要なユーザアカウントの作成などが行われる．
[root@takaken sybase]# /opt/sybase/install/sybinstall.sh
SYBASE ADAPTIVE SERVER ENTERPRISE 11.0.3.3 SOFTWARE LICENSE AGREEMENT
NOTICE TO USER: BY INSTALLING THIS SOFTWARE YOU ACCEPT ALL THE TERMS
AND CONDITIONS OF THIS AGREEMENT. PLEASE READ THEM CAREFULLY.
THIS SOFTWARE LICENSE AGREEMENT (THE "AGREEMENT") ACCOMPANIES THE
SYBASE ADAPTIVE SERVER ENTERPRISE PRODUCT, VERSION 11.0.3.3 FOR
THE LINUX OPERATING SYSTEM WITH WHICH IT IS DISTRIBUTED AND RELATED
MATERIALS AND DOCUMENTATION (THE "SOFTWARE"). AT THE END OF THIS
AGREEMENT, YOU WILL BE ASKED TO ACCEPT THIS AGREEMENT IN ORDER TO
INSTALL THE SOFTWARE. IF YOU DO NOT ACCEPT THIS AGREEMENT, YOU MAY
NOT INSTALL THE SOFTWARE EVEN THOUGH THE SOFTWARE IS PROVIDED FREE
OF CHARGE.
WHEN YOU ACCEPT THIS AGREEMENT, SYBASE GRANTS YOU A ROYALTY-FREE,
NON-EXCLUSIVE LICENSE TO USE THE PROGRAMS AS FOLLOWS:
1. LICENSE & LICENSE RESTRICTIONS. You are allowed to install and
use the Software at no charge for free as long as you operate
the Software at all times only with the Open Source - Linux and
FreeBSD - operating systems running natively on your hardware
system. You may modify, translate or adapt the Software as long as
you do not reverse engineer, decompile or disassemble it (except
to the extent the laws in your jurisdiction specifically prohibit
these restrictions). You may not use the Software for timesharing,
rental or service bureau purposes. You may copy the Software as
long as you copy all of it and do not remove this Agreement or
the copyright notices and other proprietary notices included in
the Software or documentation. You must reproduce this Agreement
and all notices included in the Software on all copies or extracts
of the Software and Documentation. Results of benchmark or other
performance tests run on the Software may not be disclosed to
any third party without Sybase's prior written consent.
2. COPYRIGHT AND OWNERSHIP. The Software is owned by Sybase or
its licensorssuppliers and is protected under the copyright laws
of the United States and international treaty provisions. This
Agreement gives you only the right to use the Software on the
terms stated here. You do not own the Software and cannot sell it.
3. SUPPORT. THE SOFTWARE IS NOT SUPPORTED BY SYBASE, ITS SUBSIDIARIES
OR LICENSORS.The Software is not supported by Sybase. Sybase has no
obligation to provide you with any maintenance or support services
or any bug fixes, updates or new versions of the Software.
4. U.S. GOVERNMENT RESTRICTED RIGHTS. The Software is Commercial
Computer Software. Use, duplication and disclosure of the Software
by the U.S. Government is subject to the restrictions set forth
in this Agreement or in any other written agreement specifying
the Government's right to use the Software. Sybase reserves all
unpublished rights under U.S. copyright laws.
5. TERMINATION. This Agreement and your right to use the Software
will continue so long as you comply with the terms and conditions
of this Agreement. Sybase may immediately terminate (end) your
license to use the Software if you breach any of your obligations
stated here. If Sybase terminates your license to use the Software,
you must immediately stop using the Software and destroy all copies
of it. All disclaimers of warranties and limitations of liability
(Paragraphs 6 and 7) will continue in force after termination of
this Agreement.
6. NO WARRANTY. The Software is provided AS IS, without any warranty
whatsoever. You assume the full responsibility for the selection
of the Software to achieve your intended results and for the
installation, use and results obtain from the Software. SYBASE
DISCLAIMS ALL WARRANTIES AND CONDITIONS, EXPRESS OR IMPLIED,
INCLUDING WITHOUT LIMITATION THE IMPLIED WARRANTIES OR CONDITIONS
OF MERCHANTABLE QUALITY, NONINFRINGEMENT, AND FITNESS FOR A
PARTICULAR PURPOSE.
7. LIMITATION ON LIABILITY. UNDER NO CIRCUMSTANCES WILL SYBASE,
ITS SUBSIDIARIES OR ITS LICENSORS BE LIABLE FOR ANY LOSS OR
DAMAGE AS A RESULT OF THIS AGREEMENT, INCLUDING BUT NOT LIMITED
TO ANY INACCURACY OF DATA, LOSS OF PROFITS OR DIRECT, INDIRECT, SPECIAL,
INCIDENTAL OR CONSEQUENTIAL DAMAGES, EVEN IF THEY HAVE BEEN
ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
8. INDEMNITY. If you distribute or transfer all or any part of the
Software to any other person or entity, you agree to indemnify
Sybase and hold Sybase harmless from all costs, losses, liability
and expense (including all legal fees and costs) which Sybase may
incur as a result of any demands or claims brought against Sybase
(or its subsidiaries, affiliates, directors, employees or agents)
in connection such other party's use of the Software.
9. EXPORT. You agree to fully comply with all laws and regulations of
the United States and other countries ("Export Laws") relating to
exports of computer software. You will ensure that the Software
and any direct products of the Software are not (1) exported,
directly or indirectly, in violation of the Export Laws, or (2)
used for any purpose prohibited by the Export Laws, including,
without limitation, nuclear, chemical or biological weapons
production.
10. ULTRA-HAZARDOUS ACTIVITIES. The Software is not designed or
intended for use in on-line control of aircraft, air traffic,
aircraft navigation or aircraft communications; or in the design,
construction, operation or maintenance of nuclear facilities. You
agree you will not use or redistribute the Software for such
purposes.
11. GOVERNING LAW; COMPLETE AGREEMENT. This Agreement is the complete
agreement between you and Sybase or its subsidiaries with respect
to the Software and is governed by the laws of the State of
California (other than its conflict of law provisions).
BY SELECTING BELOW "YES I AGREE TO THE ABOVE TERMS AND CONDITIONS",
YOU ARE STATING THAT YOU HAVE READ, UNDERSTOOD AND AGREE TO BE BOUND
BY THIS AGREEMENT, THAT, IF YOU ARE ACCEPTING THIS AGREEMENT FOR A
COMPANY, YOU ARE AUTHORIZED TO DO SO AND YOU ARE WARRANTING THAT EACH
OF THE FOLLOWING STATEMENTS IS TRUE:
1. You are not a citizen, national or resident of, or under the
control of the government of Cuba, Iran, Iraq, Libya, North
Korea, Syria or any other country to which the United States has
prohibited exports of software.
2. You will not export or re-export the Software, directly or
indirectly, to the above mentioned countries or to citizens,
nationals or residents of those countries.
3. You are not listed on the U.S Department of Commerce Table of
Denial Orders and you agree not export or re-export the Software,
directly or indirectly, to persons on this list.
4. You agree not to use, or permit the use of, the Software for any
purposes prohibited by U.S. law, including, without limitation,
for the development, design or production of nuclear, chemical
or biological weapons.
DO YOU AGREE WITH THE LISTED LICENSE CONDITIONS? [Yes/No/List]: y
ライセンスに同意するか？
Do you want this script to proceed by installing an account? [y/n]: y
インストール用のアカウントを作成するけど良いか？
Group sybase not found. Create it now? [y/n]: y
Linux上にsybaseグループが定義されていないが，作成するか？
Group and permissions for /opt/sybase are set !
グループが作成され，/opt/sybaseディレクトリのアクセス権が設定されました．
User sybase not found. Create it now? [y/n]: y
OS上にsybaseユーザが定義されていないが，作成するか？
Changing password for user sybase
New UNIX password:■■■■■■■■■■
Retype new UNIX password:■■■■■■■■■■
passwd: all authentication tokens updated successfully
User sybase is available, release user id is set !
sybaseユーザのパスワードを入力してください．
パスワードを2回入れる．
sybaseユーザが設定されました．
This completes your Sybase Adaptive Server Enterprise (ASE) package
installation. To run Sybase ASE, you may like configuring your master
and sybsystemprocs databases by continuing the installation procedure
after logging in as sybase and executing /opt/sybase/install/sybinit.
これでASEのパッケージのインストール（ファイルのコピー等）が終了しました．
次はmasterとsybsystemprocsデータベースを設定する必要があります．
その場合はsybinitを実行してください．
This action is the default when you login for the first time.
Re-running this configuration procedure can be initiated by removing
the .readme and .sybinit files from the 'sybase' installation
directory.
sybaseユーザでログインしてください．
[root@takaken /opt]#
|
５．OpenClient/Serverの設定
- sybaseユーザでログインする．
- 初回だけ，次のように表示される．
[root@takaken sybase]# su - sybase
This first time login as Database Administrator (DBA) will start
configuring and running the Sybase Adaptive Server Enterprise (ASE)
with help from 'sybinit'. If you are unfamiliar or feel uncomfortable
with this action and like to read the HOWTO or full documentation
first, you can either choose not to enter 'sybinit' or exit from the
'sybinit' main menu by entering '^X'.
Entering 'sybinit' can be done at any time by:
=> Login under the 'sybase' DBA account.
=> Setup your environment (if not done by the login process)
Bourne-Shell users
$ . .profile
C-Shell users:
% source .cshrc
=> Start 'sybinit'
$ $SYBASE/install/sybinit
Complete documentation and a Quickstart HOWTO to configure this Sybase
ASE release can be found in the $SYBASE/doc directory.
Documentation towards any Sybase product can be found on our Dynaweb
pages accessible from our World Wide Web site:
<http://www.sybase.com>
<http://sybooks.sybase.com/dynaweb>
We would like you to register your installation and find more
information about this Sybase Adaptive Server Enterprise release
for Linux available from:
<http://linux.sybase.com>
Enjoy this Sybase Adaptive Enterprise Server installation !
Do you want to start 'sybinit' now? [y/n]: y
|
- sybinitを実行するか質問されるので，yを入力する．
- ログイン時に表示されるこのメッセージは，一度sybinitを実行すると表示されなくなる．
The log file for this session is '/opt/sybase/init/logs/log0905.001'.
SYBINIT
1. Release directory: /opt/sybase
2. Edit / View Interfaces File
3. Configure a Server product
4. Configure an Open Client/Server product
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 4
CONFIGURE CONNECTIVITY PRODUCTS
Products:
Product Date Installed Date Configured
1. Open Client Library Mar 17 2000 20:4
2. Open Server Library Mar 17 2000 20:4
3. Embedded SQL/C Precomp Mar 17 2000 05:2
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- OpenClient/Serverライブラリが導入されていることを確認．
- sybase-ocsd-10.0.4-6.i386.rpmを導入していないと，この一覧にある1番と2番のOpenClient/Serverはこの一覧に表示されない．
- それぞれ１〜３のプロダクトを順次選択し，初期化を行っておく．
Enter the number of your choice and press return: 1
Running task: initialize Open Client Library.
Successfully initialized 'Open Client Library'.
Press <return> to continue.
Task succeeded: initialize Open Client Library.
Configuration completed successfully.
Press <return> to continue.
CONFIGURE CONNECTIVITY PRODUCTS
Products:
Product Date Installed Date Configured
1. Open Client Library Mar 17 2000 20:4 Sep 05 2001 19:5
2. Open Server Library Mar 17 2000 20:4
3. Embedded SQL/C Precomp Mar 17 2000 05:2
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 2
Running task: initialize Open Server Library.
Successfully initialized 'Open Server Library'.
Press <return> to continue.
Task succeeded: initialize Open Server Library.
Configuration completed successfully.
Press <return> to continue.
CONFIGURE CONNECTIVITY PRODUCTS
Products:
Product Date Installed Date Configured
1. Open Client Library Mar 17 2000 20:4 Sep 05 2001 19:5
2. Open Server Library Mar 17 2000 20:4 Sep 05 2001 19:5
3. Embedded SQL/C Precomp Mar 17 2000 05:2
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 3
Running task: initialize Embedded SQL C Precompiler.
Successfully initialized 'Embedded SQL/C Precompiler'.
Press <return> to continue.
Task succeeded: initialize Embedded SQL C Precompiler.
Configuration completed successfully.
Press <return> to continue.
CONFIGURE CONNECTIVITY PRODUCTS
Products:
Product Date Installed Date Configured
1. Open Client Library Mar 17 2000 20:4 Sep 05 2001 19:5
2. Open Server Library Mar 17 2000 20:4 Sep 05 2001 19:5
3. Embedded SQL/C Precomp Mar 17 2000 05:2 Sep 05 2001 19:5
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 設定が終了していれば，Date Configuredに設定した時間がセットされる．
- CTRL+Aを1回おして，１つ上位のメニューに戻る．
６．SQL Serverの設定
SYBINIT
1. Release directory: /opt/sybase
2. Edit / View Interfaces File
3. Configure a Server product
4. Configure an Open Client/Server product
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 3を入力し，Server productの設定を行う．
Enter the number of your choice and press return:3
CONFIGURE SERVER PRODUCTS
Products:
Product Date Installed Date Configured
1. SQL Server Mar 17 2000 23:59
2. Backup Server Mar 17 2000 23:58
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return:1
EXISTING SYBASE SERVER
1. Configure a new Adaptive Server
2. Configure an existing Sybase Server
3. Upgrade an existing Sybase Server
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return:1
ADD NEW ADAPTIVE SERVER
1. Adaptive Server name: SYBASE
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 1を押して，Enterキーを押下する．
- AdaptiveServer名を入力する．
Enter the number of your choice and press return:1
Enter the name of the new Adaptive Server (default is 'SYBASE'):
SYBASE01
|
- 名前を入力したら，Enterキーを押下する．
- SYBASE01の内容の設定を行う事とする．
ADD NEW ADAPTIVE SERVER
1. Adaptive Server name: SYBASE01
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:1
|
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Incomplete
2. MASTER DEVICE CONFIGURATION Incomplete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Incomplete
4. SET ERRORLOG LOCATION Incomplete
5. CONFIGURE DEFAULT BACKUP SERVER Incomplete
6. CONFIGURE LANGUAGES Incomplete
7. CONFIGURE CHARACTER SETS Incomplete
8. CONFIGURE SORT ORDER Incomplete
9. CONFIGURE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:1
|
- Internfaceファイル(Oracleでいうところのtnsnames.ora)の編集を行う為，1を選択する．
SERVER INTERFACES FILE ENTRY SCREEN
Server name: SYBASE01
1. Retry Count: 0
2. Retry Delay: 0
3. Add a new listener service
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 3を入力し，Enterを押下する．
- Retry CountとRetry Delayは，クライアントからの再接続に関係する設定を行う時に必要であるが，通常はデフォルトで良いと本に書いてあった．
EDIT TCP SERVICE
1. Hostname/Address: takaken.Xo.jp
2. Port:
3. Name Alias:
4. Delete this service from the interfaces entry
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 2
Enter the port number to use for this entry (default is ''):
5000
EDIT TCP SERVICE
1. Hostname/Address: takaken.Xo.jp
2. Port: 5000
3. Name Alias:
4. Delete this service from the interfaces entry
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- ここでは，ポートは5000番を指定する．
- 入力が終了したら，CTRL+aを入力し，質問にはyと答える．
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
Is this information correct? y
SERVER INTERFACES FILE ENTRY SCREEN
Server name: SYBASE01
1. Retry Count: 0
2. Retry Delay: 0
3. Add a new listener service
Modify or delete a service
Listener services available:
Protocol Address Port Name Alias
4. tcp takaken.Xo.jp 5000
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- CTRL+aを入力し，intafacesファイルを上書きするかの質問にyと答える．
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
Write the changes to the interfaces file now? y
|
Write the changes to the interfaces file now? y
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Incomplete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Incomplete
4. SET ERRORLOG LOCATION Incomplete
5. CONFIGURE DEFAULT BACKUP SERVER Incomplete
6. CONFIGURE LANGUAGES Incomplete
7. CONFIGURE CHARACTER SETS Incomplete
8. CONFIGURE SORT ORDER Incomplete
9. CONFIGURE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 2
MASTER DEVICE CONFIGURATION
1. Master Device: /opt/sybase/master.dat
2. Size (Meg): 21
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 2を押して，サイズを変更する．
- ここでは設定していないが，必要があれば１を選択してマスターデバイスを作成するファイルパスを設定する．
Enter the number of your choice and press return: 2
Enter the size of the Adaptive Server's master device in megabytes:
50
MASTER DEVICE CONFIGURATION
1. Master Device: /opt/sybase/master.dat
2. Size (Meg): 50
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return:
WARNING: '/opt/sybase/master.dat' is a regular file which is not rec
ommended for a Server device.
Press <return> to continue.
|
- このWARNINGメッセージは無視してかまわない．
- マスタデバイスをファイルシステム上に作成する場合に表示される．
- システムの安全性を重視する場合は，ローデバイスに作成することが推奨されている．
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Incomplete
4. SET ERRORLOG LOCATION Incomplete
5. CONFIGURE DEFAULT BACKUP SERVER Incomplete
6. CONFIGURE LANGUAGES Incomplete
7. CONFIGURE CHARACTER SETS Incomplete
8. CONFIGURE SORT ORDER Incomplete
9. CONFIGURE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 3を選択して，sybsystemprocsデバイスの設定を行う．
- sybsystemprocsとは，ストプロが格納されるデバイスである．
Enter the number of your choice and press return: 3
SYBSYSTEMPROCS DATABASE CONFIGURATION
1. sybsystemprocs database size (Meg): 16
2. sybsystemprocs logical device name: sysprocsdev
3. create new device for the sybsystemprocs database: yes
4. physical name of new device: /opt/sybase/sybprocs.dat
5. size of the new device (Meg): 16
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- デバイスサイズを変更するために，1を選択する．
- サイズを50MBに変更する．
Enter the number of your choice and press return: 1
Enter the size of the sybsystemprocs database in megabytes:
50
SYBSYSTEMPROCS DATABASE CONFIGURATION
1. sybsystemprocs database size (Meg): 50
2. sybsystemprocs logical device name: sysprocsdev
3. create new device for the sybsystemprocs database: yes
4. physical name of new device: /opt/sybase/sybprocs.dat
5. size of the new device (Meg): 50
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- CTRL+Aを押下すると，１階層上のメニューに戻る．
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Incomplete
5. CONFIGURE DEFAULT BACKUP SERVER Incomplete
6. CONFIGURE LANGUAGES Incomplete
7. CONFIGURE CHARACTER SETS Incomplete
8. CONFIGURE SORT ORDER Incomplete
9. CONFIGURE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- エラーログファイルの設定を確認するために，４を入力する．
Enter the number of your choice and press return: 4
SET ERRORLOG LOCATION
1. Adaptive Server errorlog: /opt/sybase/install/errorlog
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- このエラーログには，SQL Serverで発生するイベントがログとして吐き出される．
- CTRL+Aを押下すると，最初のメニューに戻る．
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Incomplete
6. CONFIGURE LANGUAGES Incomplete
7. CONFIGURE CHARACTER SETS Incomplete
8. CONFIGURE SORT ORDER Incomplete
9. CONFIGURE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- デフォルトバックアップサーバの設定を行うため，5を選択する．
Enter the number of your choice and press return: 5
SET THE SYBASE SERVER'S BACKUP SERVER
1. Sybase Server Backup Server name: SYB_BACKUP
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
6. CONFIGURE LANGUAGES Incomplete
7. CONFIGURE CHARACTER SETS Incomplete
8. CONFIGURE SORT ORDER Incomplete
9. CONFIGURE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 6
CONFIGURE LANGUAGES
Current default language: us_english
Current default character set: ISO 8859-1 (Latin-1) - Western European 8-b
character set.
Current sort order: Binary ordering, for the ISO 8859/1 or Latin-1 charact
(iso_1).
Select the language you want to install, remove, or designate as the default la
guage.
Language Installed? Remove Install Make default
1. us_english yes no no yes
2. chinese no no no no
3. french no no no no
4. german no no no no
5. japanese no no no no
6. korean no no no no
7. portuguese no no no no
8. spanish no no no no
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 現在の言語環境はUS_ENGLISHになっている．
- 日本語環境を入れるため，5を選択する．
- ほんとにいれるか？ 入れた言語をデフォルトにするか？と質問されるので，yで答える．
Enter the number of your choice and press return: 5
Install this language? y
Make this language the default language? y
|
CONFIGURE LANGUAGES
Current default language: japanese
Current default character set: ASCII, for use with unspecified 8-bit data.
Current sort order: Binary ordering, for use with any ASCII-based 8-bit (a
environment.
Select the language you want to install, remove, or designate as the default la
guage.
Language Installed? Remove Install Make default
1. us_english yes no no no
2. chinese no no no no
3. japanese no no yes yes
4. korean no no no no
5. portuguese no no no no
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
6. CONFIGURE LANGUAGES Complete
7. CONFIGURE CHARACTER SETS Incomplete
8. CONFIGURE SORT ORDER Incomplete
9. CONFIGURE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 7
CONFIGURE CHARACTER SETS
Current default language: japanese
Current default character set: ASCII, for use with unspecified 8-bit data.
Current sort order: Binary ordering, for use with any ASCII-based 8-bit (a
environment.
Select the character set you want to install, remove, or designate as the defau
set.aracter
Character set Installed? Remove Install Make default
1. DEC Kanji Code for JIS-X no no no no
2. Extended Unix Code for J no no no no
3. IBM/Microsoft Code for J no no no no
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- SJISを使うので，3番のIBM/Microsoft Code〜を選択する．
Enter the number of your choice and press return: 3
Install this character set? y
Make this character set the default character set? y
|
- ほんとにいれるか？ 入れた言語をデフォルトにするか？と質問されるので，yで答える．
CONFIGURE CHARACTER SETS
Current default language: japanese
Current default character set: IBM/Microsoft Code for JIS-X0201 and JIS-X0
08.
Current sort order: Binary ordering, for the Japanese Shift JIS character
(sjis).
Select the character set you want to install, remove, or designate as the defau
set.aracter
Character set Installed? Remove Install Make default
1. DEC Kanji Code for JIS-X no no no no
2. Extended Unix Code for J no no no no
3. IBM/Microsoft Code for J no no yes yes
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
6. CONFIGURE LANGUAGES Complete
7. CONFIGURE CHARACTER SETS Complete
8. CONFIGURE SORT ORDER Incomplete
9. CONFIGURE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 8
CONFIGURE SORT ORDER
Current default language: japanese
Current default character set: IBM/Microsoft Code for JIS-X0201 and JIS-X0
08.
Current sort order: Binary ordering, for the Japanese Shift JIS character
(sjis).
Select a sort order.
Sort Order Chosen
1. Binary ordering, for the Japanese Shift JIS character set (sjis) yes
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- バイナリ順になっていることを確認したら，CTRL+Aを押してメニューに戻る．
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
6. CONFIGURE LANGUAGES Complete
7. CONFIGURE CHARACTER SETS Complete
8. CONFIGURE SORT ORDER Complete
9. CONFIGURE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- セキュリティ面の監査機能の設定を確認するために，9を選択する．
- 監査は，C2セキュリティに準拠したリソースへの監視を行うことが可能．
- 今回は入れない．
Enter the number of your choice and press return: 9
CONFIGURE AUDITING
AUDITING INSTRUCTION
1. Configure auditing: no
2. sybsecurity database size (Meg): 5
3. sybsecurity logical device name: sybsecurity
4. create new device for the sybsecurity database: no
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 使われない設定になっていることを確認して，CTRL+Aでメニューに戻る．
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
6. CONFIGURE LANGUAGES Complete
7. CONFIGURE CHARACTER SETS Complete
8. CONFIGURE SORT ORDER Complete
9. CONFIGURE AUDITING Complete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- ここまでで，SQL Serverの諸設定が終了した．
- CTRL+Aを押すと，サーバの構築が行われる．
Enter the number of your choice and press return:
Execute the Sybase Server Configuration now? y
|
- ほんとに今やっちゃいますか？ときいてくるので笑顔でYes!と答える．
WARNING: '/opt/sybase/master.dat' is a regular file which is not recom
mended for a Server device.
Press <return> to continue.
|
- 前出のマスタデバイスの定義の時に出てきたのと同じ警告なので，そのまま進める．
Running task: create the master device.
Building the master device
.Done
Task succeeded: create the master device.
Running task: update the Sybase Server runserver file.
Task succeeded: update the Sybase Server runserver file.
Running task: boot the Sybase Server.
waiting for server 'SYBASE01' to boot...
Task succeeded: boot the Sybase Server.
Running task: create the sybsystemprocs database.
sybsystemprocs database created.
Task succeeded: create the sybsystemprocs database.
Running task: install system stored procedures.
........................................................................
........................................................................
........................................Done
Task succeeded: install system stored procedures.
Running task: set permissions for the 'model' database.
Done
Task succeeded: set permissions for the 'model' database.
Running task: install a character set(s).
Installing character set 'sjis'
Installing character set 'sjis'
.Done
Character set 'sjis' has been successfully installed.
Task succeeded: install a character set(s).
Running task: set the default character set and/or default sort order for
the Adaptive Server.
Setting the default character set to sjis
Installing character set 'sjis'
.Done
Sort order 'binary' has been successfully installed.
Sort order 'binary' has been successfully set to the default.
Waiting 15 seconds for the operating system to reclaim resources before r
ebooting.
waiting for server 'SYBASE01' to boot...
Task succeeded: set the default character set and/or default sort order f
or the Adaptive
Server.
Running task: install a language(s).
Installing language 'japanese'
Installing language 'japanese'
........................................................................D
one
Language 'japanese' has been successfully installed.
Task succeeded: install a language(s).
Running task: set the default language.
Setting the default language to japanese
Waiting 15 seconds for the operating system to reclaim resources before r
ebooting.
waiting for server 'SYBASE01' to boot...
Task succeeded: set the default language.
Configuration completed successfully.
Press <return> to continue.
|
- “Task successed”と表示されている事を確認する．
- Enterキーを押下すると，最初のメニューに戻る．
EXISTING SYBASE SERVER
1. Configure a new Adaptive Server
2. Configure an existing Sybase Server
3. Upgrade an existing Sybase Server
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
CONFIGURE SERVER PRODUCTS
Products:
Product Date Installed Date Configured
1. SQL Server Mar 17 2000 23:59 Sep 05 2001 17:51
2. Backup Server Mar 17 2000 23:58
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 一番最初の画面に戻る．
- CTRL+Aを2回押す．
- TELNETで接続している場合，接続が切れるかもしれない．
７．Backup Serverの設定
- これまでの作業で接続が切れた場合，再度ログインしてsybinitを実行する．
Red Hat Linux release 6.2 (Zoot)
Kernel 2.2.14-5.0 on an i686
login: sybase
Password:
Last login: Thu Sep 6 19:42:33 from shinnai-dev
bash$ cd install
bash$ ls
RUN_SYBASE01 rc.sybase startserver sybinstall.sh
RUN_SYBASE01.org setperm_all sybdevices.sh
SPR setperm_monserv sybinit
errorlog showserver sybinit.sym
|
- ためしに，showserverコマンドを実行してみる．
bash$ ./showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
sybase 2242 0.0 4.2 16752 8132 ? S 20:00 0:00 dataserver
bash$
|
- SQL Serverの実体，dataserverプロセスが稼動していることがわかる．
- 次にsybinitを実行する．
bash$ ./sybinit
The log file for this session is '/opt/sybase/init/logs/log0906.002'.
SYBINIT
1. Release directory: /opt/sybase
2. Edit / View Interfaces File
3. Configure a Server product
4. Configure an Open Client/Server product
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
CONFIGURE SERVER PRODUCTS
Products:
Product Date Installed Date Configured
1. SQL Server Mar 17 2000 23:59 Sep 05 2001 17:51
2. Backup Server Mar 17 2000 23:58
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 1
EXISTING SYBASE SERVER
1. Configure a new Adaptive Server
2. Configure an existing Sybase Server
3. Upgrade an existing Sybase Server
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 2
CONFIGURE EXISTING ADAPTIVE SERVER
Select one of the following servers:
1. SYBASE01
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 1
ENTER SA ACCOUNT NAME AND PASSWORD
1. SA Account: sa
2. SA Password:
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return:
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Unchanged
2. MASTER DEVICE CONFIGURATION Unchanged
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Unchanged
4. SET ERRORLOG LOCATION Unchanged
5. CONFIGURE DEFAULT BACKUP SERVER Unchanged
6. CONFIGURE LANGUAGES Unchanged
7. CONFIGURE CHARACTER SETS Unchanged
8. CONFIGURE SORT ORDER Unchanged
9. CONFIGURE AUDITING Unchanged
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 5
SET THE SYBASE SERVER'S BACKUP SERVER
1. Sybase Server Backup Server name: SYB_BACKUP
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 1
Enter the name of the Sybase Server's Backup Server (default is 'SYB_BACKUP'):
SYB_BACKUP
SET THE SYBASE SERVER'S BACKUP SERVER
1. Sybase Server Backup Server name: SYB_BACKUP
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- BackupServerの名称が，デフォルトでSYB_BACKUPとなっているが，名前変更で同じSYB_BACKUPと入力する．
- CTRL+Aを押下する．
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SYBASE SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Unchanged
2. MASTER DEVICE CONFIGURATION Unchanged
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Unchanged
4. SET ERRORLOG LOCATION Unchanged
5. CONFIGURE DEFAULT BACKUP SERVER Changed
6. CONFIGURE LANGUAGES Unchanged
7. CONFIGURE CHARACTER SETS Unchanged
8. CONFIGURE SORT ORDER Unchanged
9. CONFIGURE AUDITING Unchanged
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- CTRL+Aを押下する．
- 設定変更を今反映するか？と質問されるので，yを入力する．
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
Execute the Sybase Server Configuration now? y
Configuration completed successfully.
Press <return> to continue.
|
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
CONFIGURE SERVER PRODUCTS
Products:
Product Date Installed Date Configured
1. SQL Server Mar 17 2000 23:59 Sep 06 2001 20:10
2. Backup Server Mar 17 2000 23:58
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 2
NEW OR EXISTING BACKUP SERVER
1. Configure a new Backup Server
2. Configure an existing Backup Server
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 1
ADD NEW BACKUP SERVER
1. Backup Server name: SYB_BACKUP
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 1
BACKUP SERVER CONFIGURATION
1. Backup Server errorlog: /opt/sybase/install/backup.log
2. Enter / Modify Backup Server interfaces file information
3. Backup Server language: us_english
4. Backup Server character set: iso_1
5. Backup Server tape configuration file: /opt/sybase/backup_tape.cfg
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- 1番のエラーログはそのままで良いので選択しない．
- 2番のIntefaceファイルの編集を行う．
Enter the number of your choice and press return: 2
SERVER INTERFACES FILE ENTRY SCREEN
Server name: SYB_BACKUP
1. Retry Count: 0
2. Retry Delay: 0
3. Add a new listener service
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 3
EDIT TCP SERVICE
1. Hostname/Address: takaken.Xo.jp
2. Port:
3. Name Alias:
4. Delete this service from the interfaces entry
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 2
Enter the port number to use for this entry (default is ''):
5001
EDIT TCP SERVICE
1. Hostname/Address: takaken.Xo.jp
2. Port: 5001
3. Name Alias:
4. Delete this service from the interfaces entry
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- ポート番号は，SQL Serverに5000を設定したので，今度は違う5001番を割り当てた．
- CTRL+Aを押下する．
- 良いですか？と質問してくるので，yを押下する．
Enter the number of your choice and press return:
Is this information correct? y
SERVER INTERFACES FILE ENTRY SCREEN
Server name: SYB_BACKUP
1. Retry Count: 0
2. Retry Delay: 0
3. Add a new listener service
Modify or delete a service
Listener services available:
Protocol Address Port Name Alias
4. tcp takaken.Xo.jp 5001
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- CTRL+Aを押下する．
- Intafaceファイルを保存してよいか？と質問してくるのでyを入力する．
Enter the number of your choice and press return:
Write the changes to the interfaces file now? y
BACKUP SERVER CONFIGURATION
1. Backup Server errorlog: /opt/sybase/install/backup.log
2. Enter / Modify Backup Server interfaces file information
3. Backup Server language: us_english
4. Backup Server character set: iso_1
5. Backup Server tape configuration file:
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 3
BACKUP SERVER LANGUAGE
Current Backup Server language: us_english
1. us_english
2. chinese
3. french
4. german
5. japanese
6. spanish
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 5
BACKUP SERVER LANGUAGE
Current Backup Server language: japanese
1. us_english
2. chinese
3. french
4. german
5. japanese
6. spanish
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return:
BACKUP SERVER CONFIGURATION
1. Backup Server errorlog: /opt/sybase/install/errorlog
2. Enter / Modify Backup Server interfaces file information
3. Backup Server language: japanese
4. Backup Server character set: iso_1
5. Backup Server tape configuration file:
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 4
BACKUP SERVER CHARACTER SET
Current Backup Server character set: iso_1
1. deckanji: DEC Kanji Code for JIS-X0208.
2. eucjis: Extended Unix Code for JIS-X0201 and JIS-X0208.
3. sjis: IBM/Microsoft Code for JIS-X0201 and JIS-X0208.
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return: 3
BACKUP SERVER CHARACTER SET
Current Backup Server character set: sjis
1. deckanji: DEC Kanji Code for JIS-X0208.
2. eucjis: Extended Unix Code for JIS-X0201 and JIS-X0208.
3. sjis: IBM/Microsoft Code for JIS-X0201 and JIS-X0208.
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return:
BACKUP SERVER CONFIGURATION
1. Backup Server errorlog: /opt/sybase/install/errorlog
2. Enter / Modify Backup Server interfaces file information
3. Backup Server language: japanese
4. Backup Server character set: sjis
5. Backup Server tape configuration file:/opt/sybase/backup_tape.cfg
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
Enter the number of your choice and press return:
Execute the Backup Server configuration now? y
|
- BackupServerの設定を実行してよいか？と聞かれるので，当然yと答える．
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
Execute the Backup Server configuration now? y
Running task: update the Backup Server runserver file.
Task succeeded: update the Backup Server runserver file.
Running task: boot the Backup Server.
waiting for server 'SYB_BACKUP' to boot...
Task succeeded: boot the Backup Server.
Configuration completed successfully.
Press <return> to continue.
NEW OR EXISTING BACKUP SERVER
1. Configure a new Backup Server
2. Configure an existing Backup Server
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
|
- CTRL+AやCTRL+Xを押して，sybinitを終了する．
- showserverコマンドを用いて，サーバが稼動しているか確認する．
bash$ pwd
/opt/sybase/install
bash$ ./showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
sybase 2242 0.0 4.2 16752 8260 ? S 20:00 0:00 dataserver
sybase 2324 0.0 2.7 8032 5236 pts/2 S 20:44 0:00 backupserver
bash$
|
８．SQL Serverの終了と起動スクリプトの確認
- SQL ServerとBackup Serverの起動シェルが作成されているか確認する．
bash$ pwd
/opt/sybase/install
bash$ ls -la
total 3700
drwxrwxr-x 3 sybase sybase 4096 Sep 6 20:49 .
drwxrwxr-x 14 sybase sybase 4096 Sep 6 20:42 ..
-rwxr-xr-x 1 sybase sybase 405 Sep 6 19:55 RUN_SYBASE01
-rwxr-xr-x 1 sybase sybase 600 Sep 6 20:44 RUN_SYB_BACKUP
drwxrwxr-x 2 root root 4096 Sep 6 19:37 SPR
-rw-rw-r-- 1 sybase sybase 956 Sep 6 20:44 backup.log
-rw-rw-r-- 1 sybase sybase 27871 Sep 6 20:00 errorlog
-r-xr-xr-x 1 root root 1435 Jan 7 2000 rc.sybase
-r-xr-xr-x 1 root root 4173 Jan 5 2000 setperm_all
-r--r--r-- 1 root root 386 Jan 7 2000 setperm_monserv
-r-xr-xr-x 1 root root 667 Mar 16 2000 showserver
-r-xr-xr-x 1 root root 16720 Mar 17 2000 startserver
-r-xr-xr-x 1 root root 2304 Jan 23 2000 sybdevices.sh
-r-xr-xr-x 1 root root 1009190 Mar 17 2000 sybinit
-r-xr-xr-x 1 root root 2661666 Mar 17 2000 sybinit.sym
-r-xr-xr-x 1 root root 5615 Jan 23 2000 sybinstall.sh
bash$ cat RUN_SYBASE01
#!/bin/sh
#
# Adaptive Server Information:
# name: SYBASE01
# master device: /opt/sybase/master.dat
# master device size: 25600
# errorlog: /opt/sybase/install/errorlog
# interfaces: /opt/sybase
#
/opt/sybase/bin/dataserver -d/opt/sybase/master.dat -sSYBASE01 \
-e/opt/sybase/install/errorlog -i/opt/sybase
bash$ cat RUN_SYB_BACKUP
#!/bin/sh
#
# Backup Server Information:
# name: SYB_BACKUP
# errorlog: /opt/sybase/install/backup.log
# interfaces: /opt/sybase/interfaces
# location of multibuf: /opt/sybase/bin/sybmultbuf
# language: japanese
# character set: sjis
# tape configuration file: /opt/sybase/backup_tape.cfg
#
#
/opt/sybase/bin/backupserver -SSYB_BACKUP -e/opt/sybase/install/backup.log \
-I/opt/sybase/interfaces -M/opt/sybase/bin/sybmultbuf -Ljapanese -Jsjis \
-c/opt/sybase/backup_tape.cfg
bash$
|
９．Intefacesファイルの中身の確認
- interfacesファイルとは，Oracleのtnsnames.oraと同じで，接続先が記述されているファイルである．
bash$ pwd
/opt/sybase
bash$ cat interfaces
## SYBASE01 on takaken.Xo.jp
## Services:
## query tcp (5000)
## master tcp (5000)
SYBASE01
query tcp ether takaken.Xo.jp 5000
master tcp ether takaken.Xo.jp 5000
## SYB_BACKUP on takaken.Xo.jp
## Services:
## query tcp (5001)
## master tcp (5001)
SYB_BACKUP
query tcp ether takaken.Xo.jp 5001
master tcp ether takaken.Xo.jp 5001
bash$
|
１０．データベースのシャットダウン
- isqlを使ってDBに接続し，データベースをシャットダウンする．
bash$ isql -Usa -P -SSYBASE01
Msg 2401, Level 11, State 2:
Line 1:
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'.
1> shutdown SYB_BACKUP
2> go
Backup Server: 3.48.1.1: The Backup Server will go down immediately.
Terminating sessions.
1> shutdown
2> go
Server SHUTDOWN by request.
The SQL Server is terminating this process.
DB-LIBRARY error:
Unexpected EOF from SQL Server.
bash$
|
- 停止する場合，Backup Serverを停止した後に，SQL Serverを停止する．
- BackupServerは，SQL Serverからの要求しか受け付けないため，先にSQL ServerをシャットダウンするとBackupServerを終了させる手段が無くなる．
- 最後にDB-LIBRARY errorと表示されているが，これはSQL
Serverが停止したので，それまで接続していたisqlコマンドがセッションを失ったために表示されたもので，正常動作の結果である．
１２．ファイルの権限の変更
- rootユーザでインストール時しているため，/opt/sybase以下の一部のファイルが所有者がrootのままになっている．
- 編集し辛い部分があるので，この所有者とグループを全てsybaseに変更する．
bash$ su
Password:
[root@takaken sybase]# pwd
/opt/sybase
[root@takaken sybase]# chown -R sybase ../sybase
[root@takaken sybase]# chgrp -R sybase ../sybase
[root@takaken sybase]# ls -la
total 59428
drwxrwxr-x 14 sybase sybase 4096 Sep 6 21:38 .
drwxr-xr-x 3 root root 4096 Sep 6 19:36 ..
-rw-r--r-- 1 sybase sybase 235 Sep 6 19:41 .Xdefaults
-rw------- 1 sybase sybase 279 Sep 6 21:02 .bash_history
-r-xr-xr-x 1 sybase sybase 191 Jan 5 2000 .cshrc
-rw-r--r-- 1 sybase sybase 491 Sep 6 19:41 .emacs
-r-xr-xr-x 1 sybase sybase 1289 Jan 5 2000 .profile
-rw-rw-r-- 1 sybase sybase 0 Sep 6 19:42 .readme
-rw-r--r-- 1 sybase sybase 3394 Sep 6 19:41 .screenrc
-rw-rw-r-- 1 sybase sybase 0 Sep 6 19:41 .syb_license
-rw-rw-r-- 1 sybase sybase 0 Sep 6 20:16 .sybinit
-r--r--r-- 1 sybase sybase 12010 Mar 28 2000 CONFIGURE
drwxrwxr-x 4 sybase sybase 4096 Sep 6 19:36 GPL
-r--r--r-- 1 sybase sybase 7409 Mar 18 2000 LICENSE
-r--r--r-- 1 sybase sybase 1266 Jan 5 2000 README
-rw-rw-r-- 1 sybase sybase 3463 Sep 6 19:55 SYBASE01.001
-rw-rw-r-- 1 sybase sybase 3451 Sep 6 19:56 SYBASE01.002
-rw-rw-r-- 1 sybase sybase 3457 Sep 6 19:58 SYBASE01.003
-rw-rw-r-- 1 sybase sybase 3457 Sep 6 19:58 SYBASE01.004
-rw-rw-r-- 1 sybase sybase 3451 Sep 6 19:58 SYBASE01.005
-rw-rw-r-- 1 sybase sybase 3457 Sep 6 19:58 SYBASE01.006
-rw-rw-r-- 1 sybase sybase 3451 Sep 6 19:58 SYBASE01.007
-rw-rw-r-- 1 sybase sybase 3457 Sep 6 19:58 SYBASE01.008
-rw-rw-r-- 1 sybase sybase 3451 Sep 6 19:58 SYBASE01.009
-rw-rw-r-- 1 sybase sybase 3451 Sep 6 19:58 SYBASE01.010
-rw-rw-r-- 1 sybase sybase 3457 Sep 6 19:58 SYBASE01.011
-rw-rw-r-- 1 sybase sybase 3457 Sep 6 19:58 SYBASE01.012
-rw-rw-r-- 1 sybase sybase 3451 Sep 6 19:58 SYBASE01.013
-rw-rw-r-- 1 sybase sybase 3457 Sep 6 20:00 SYBASE01.014
-rw-rw-r-- 1 sybase sybase 3451 Sep 6 20:00 SYBASE01.015
-rw-rw-r-- 1 sybase sybase 3451 Sep 6 20:00 SYBASE01.016
-rw-rw-r-- 1 sybase sybase 3457 Sep 6 21:04 SYBASE01.bak
-rw-rw-r-- 1 sybase sybase 3457 Sep 6 20:00 SYBASE01.cfg
drwxrwxr-x 2 sybase sybase 4096 Sep 6 19:37 bin
drwxrwxr-x 12 sybase sybase 4096 Sep 6 19:37 charsets
drwxrwxr-x 2 sybase sybase 4096 Sep 6 19:40 devlib
drwxrwxr-x 2 sybase sybase 4096 Sep 6 19:40 include
drwxrwxr-x 12 sybase sybase 4096 Sep 6 19:40 init
drwxrwxr-x 3 sybase sybase 4096 Sep 6 20:49 install
-rw-rw-r-- 1 sybase sybase 424 Sep 6 20:42 interfaces
-rw-rw-r-- 1 sybase sybase 210 Sep 6 19:50 interfaces.001
drwxrwxr-x 2 sybase sybase 4096 Sep 6 19:40 lib
drwxrwxr-x 10 sybase sybase 4096 Sep 6 19:37 locales
-rw-rw-r-- 1 sybase sybase 52428800 Sep 6 21:38 master.dat
drwxrwxr-x 6 sybase sybase 4096 Sep 6 19:40 sample
drwxrwxr-x 7 sybase sybase 4096 Sep 6 19:37 scripts
-rw-rw-r-- 1 sybase sybase 52428800 Sep 6 21:38 sybprocs.dat
drwxrwxr-x 2 sybase sybase 4096 Sep 6 19:37 upgrade
[root@takaken sybase]# exit
exit
bash$
|
１１．データベースの起動
- RUN_SERVERファイルを使い，SQL ServerとBackup Serverを起動する．
bash$ pwd
/opt/sybase/install
bash$ ls -la
total 3716
drwxrwxr-x 3 sybase sybase 4096 Sep 6 20:49 .
drwxrwxr-x 14 sybase sybase 4096 Sep 6 21:04 ..
-rwxr-xr-x 1 sybase sybase 405 Sep 6 19:55 RUN_SYBASE01
-rwxr-xr-x 1 sybase sybase 600 Sep 6 20:44 RUN_SYB_BACKUP
drwxrwxr-x 2 root root 4096 Sep 6 19:37 SPR
-rw-rw-r-- 1 sybase sybase 1064 Sep 6 20:53 backup.log
-rw-rw-r-- 1 sybase sybase 42786 Sep 6 21:04 errorlog
-r-xr-xr-x 1 root root 1435 Jan 7 2000 rc.sybase
-r-xr-xr-x 1 root root 4173 Jan 5 2000 setperm_all
-r--r--r-- 1 root root 386 Jan 7 2000 setperm_monserv
-r-xr-xr-x 1 root root 667 Mar 16 2000 showserver
-r-xr-xr-x 1 root root 16720 Mar 17 2000 startserver
-r-xr-xr-x 1 root root 2304 Jan 23 2000 sybdevices.sh
-r-xr-xr-x 1 root root 1009190 Mar 17 2000 sybinit
-r-xr-xr-x 1 root root 2661666 Mar 17 2000 sybinit.sym
-r-xr-xr-x 1 root root 5615 Jan 23 2000 sybinstall.sh
bash$
bash$ ./startserver -f ./RUN_SYBASE01
bash$ 00:2001/09/06 21:04:57.22 kernel Using config area from primary master dev
ice.
00:2001/09/06 21:04:57.22 kernel Warning: Using default file '/opt/sybase/SYBASE
01.cfg' since a configuration file was not specified. Specify a configuration fil
e name in the RUNSERVER file to avoid this message.
00:2001/09/06 21:04:57.22 kernel Using 1024 file descriptors.
00:2001/09/06 21:04:57.22 kernel Internal run-time model set for Linux
00:2001/09/06 21:04:57.22 kernel SQL Server/11.0.3.3 ESD#6/P-FREE/Linux Intel/Li
nux 2.2.14 i686/1/OPT/Fri Mar 17 15:45:30 CET 2000
00:2001/09/06 21:04:57.22 kernel (c) Copyright 1987, 2000.
00:2001/09/06 21:04:57.22 kernel Sybase, Inc. All rights reserved.
00:2001/09/06 21:04:57.22 kernel
00:2001/09/06 21:04:57.22 kernel Unpublished rights reserved under U.S. copyrigh
t laws.
00:2001/09/06 21:04:57.22 kernel This software contains confidential and trade s
ecret information of Sybase,
00:2001/09/06 21:04:57.22 kernel Inc. Use, duplication or disclosure of the s
oftware and documentation by
00:2001/09/06 21:04:57.22 kernel the U.S. Government is subject to restric
tions set forth in a license
00:2001/09/06 21:04:57.22 kernel agreement between the Government and Sybas
e, Inc. or other written
00:2001/09/06 21:04:57.22 kernel agreement specifying the Government's rights
to use the software and any
00:2001/09/06 21:04:57.22 kernel applicable FAR provisions, for example, FAR 52.
227-19.
00:2001/09/06 21:04:57.22 kernel
00:2001/09/06 21:04:57.22 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville,
CA 94608, USA.
00:2001/09/06 21:04:57.22 kernel Using '/opt/sybase/SYBASE01.cfg' for configurat
ion information.
00:2001/09/06 21:04:57.22 kernel Logging SQL Server messages in file '/opt/sybas
e/install/errorlog'
.
00:2001/09/06 21:04:57.23 kernel Network and device connection limit is 1014.
00:2001/09/06 21:04:57.23 server Number of proc buffers allocated: 495.
00:2001/09/06 21:04:57.26 server Number of blocks left for proc headers: 543.
00:2001/09/06 21:04:57.26 server Memory allocated for the default data cache cac
he: 3712 Kb
00:2001/09/06 21:04:57.26 server Size of the 2K memory pool: 3712 Kb
00:2001/09/06 21:04:57.26 kernel Initializing virtual device 0, '/opt/sybase/mas
ter.dat'
00:2001/09/06 21:04:57.26 kernel Virtual device 0 started using standard unix i/
o.
00:2001/09/06 21:04:57.26 server No active traceflags
00:2001/09/06 21:04:57.26 server Opening Master Database ...
00:2001/09/06 21:04:57.27 server Loading SQL Server's default sort order and cha
racter set
00:2001/09/06 21:04:57.27 kernel network name takaken.Xo.jp, type e
ther, port 5000
00:2001/09/06 21:04:57.27 server Recovering database 'master'
00:2001/09/06 21:04:57.27 server Recovery dbid 1 ckpt (2139,30)
00:2001/09/06 21:04:57.27 server Recovery no active transactions before ckpt.
00:2001/09/06 21:04:57.29 server Database 'master' is now online.
00:2001/09/06 21:04:57.29 server The transaction log in the database 'master' wi
ll use I/O size of 2 Kb.
00:2001/09/06 21:04:57.29 server 0 dump conditions detected at boot time
00:2001/09/06 21:04:57.29 server server is unnamed
00:2001/09/06 21:04:57.29 server Activating disk 'sysprocsdev'.
00:2001/09/06 21:04:57.29 kernel Initializing virtual device 1, '/opt/sybase/syb
procs.dat'
00:2001/09/06 21:04:57.29 kernel Virtual device 1 started using standard unix i/
o.
00:2001/09/06 21:04:57.30 server Recovering database 'model'.
00:2001/09/06 21:04:57.30 server Recovery dbid 3 ckpt (432,12)
00:2001/09/06 21:04:57.30 server Recovery no active transactions before ckpt.
00:2001/09/06 21:04:57.31 server The transaction log in the database 'model' wil
l use I/O size of 2 Kb.
00:2001/09/06 21:04:57.31 server Database 'model' is now online.
00:2001/09/06 21:04:57.31 server Clearing temp db
00:2001/09/06 21:04:57.66 server The transaction log in the database 'tempdb' wi
ll use I/O size of 2 Kb.
00:2001/09/06 21:04:57.70 server The transaction log in the database 'tempdb' wi
ll use I/O size of 2 Kb.
00:2001/09/06 21:04:57.71 server Database 'tempdb' is now online.
00:2001/09/06 21:04:57.72 server Recovering database 'sybsystemprocs'.
00:2001/09/06 21:04:57.72 server Recovery dbid 4 ckpt (8939,17)
00:2001/09/06 21:04:57.72 server Recovery no active transactions before ckpt.
00:2001/09/06 21:04:57.79 server The transaction log in the database 'sybsystemp
rocs' will use I/O size of 2 Kb.
00:2001/09/06 21:04:57.80 server Database 'sybsystemprocs' is now online.
00:2001/09/06 21:04:57.80 server Recovery complete.
00:2001/09/06 21:04:57.80 server SQL Server's default sort order is:
00:2001/09/06 21:04:57.80 server 'bin_sjis' (ID = 50)
00:2001/09/06 21:04:57.80 server on top of default character set:
00:2001/09/06 21:04:57.80 server 'sjis' (ID = 141).
bash$ ./startserver -f ./RUN_SYB_BACKUP
bash$ Backup Server/11.0.3.3 ESD#6/P-FREE/Linux Intel/Linux 2.2.14 i686/1/OPT/Fri
Mar 17 15:52:00 CET 2000
(c) Copyright 1987, 2000.
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.
ファイル '/opt/sybase/install/backup.log' に Backup Server メッセージをログします
。
bash$
|
１２．isqlを日本語環境で接続する
- 現在の設定のままだと，isqlで接続したときに次のように警告メッセージが表示される．
bash$ 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.
Due to previous errors, the language for this session is being forced to
'us_english'.
1> hello
2> go
Msg 2812, Level 16, State 4:
Line 1:
Stored procedure 'hello' not found. Specify owner.objectname or use sp_help to
check whether the object exists (sp_help may produce lots of output).
1> quit
bash$
|
- isqlのオプションにて，日本語を設定して実行する．
bash$ isql -Usa -P -SSYBASE01 -Jsjis -zjapanese
1> hello
2> go
Msg 2812, Level 16, State 4:
Line 1:
ストアド・プロシージャ 'hello'
がありません。「所有者名.オブジェクト名」を指定するか、SP_HELP
を使用してオブジェクトの存在を確認してください (sp_help
ではその他のオブジェクトも表示されます)。
1>
|
- オプションを指定して実行することにより，日本語でメッセージが表示されるようになった．
|
|
