[altibase] 5.5.1.3.0 설치

1. 5.5.1.3.0 다운로드

$ wget http://data.altibase.com/download_back/altibase/altibase5/5.5.1patch/5.5.1.3.0/LINUX/altibase-server-5.5.1.3-LINUX-X86-64bit-patch_0_0_3_0.run

$ sudo ./altibase-server-5.5.1.3-LINUX-X86-64bit-patch_0_0_3_0.run 

----------------------------------------------------------------------------

Welcome to the ALTIBASE HDB Server 5.5.1.3.0 Setup Wizard.

----------------------------------------------------------------------------

Installation Directory

Please specify the installation directory for ALTIBASE HDB Server 5.5.1.3.0

Installation Directory [/opt/altibase-server-5.5.1]: /app/altibase

Please select the installation type.

Install type

[1] Patch package: patch package install

[2] Full package: full package install

Please choose an option [1] : 2

----------------------------------------------------------------------------

Pre-Installation requirements for ALTIBASE HDB

It is first, necessary to set your system environment to ensure that ALTIBASE 

HDB will run properly. Before installing ALTIBASE HDB, the kernel parameter 

values must be set using the root user account. The kernel parameter values may 

be modified after installation; however, they must be set prior to operating the 

ALTIBASE HDB.

Please refer to the installation manual and pre_install.sh script file.

(pre_install.sh : '$ALTIBASE_HOME'/install/pre_install.sh)

================ LINUX ================

[ How to modify kernel parameter values ]

echo 512 32000 512 512 > /proc/sys/kernel/sem

echo 872415232 > /proc/sys/kernel/shmall

# shmall 

If it is desired to use the ALTIBASE HDB in shared memory mode, the value of 

'shmall' must be set. This value determines the maximum size of an ALTIBASE 

database.

Press [Enter] to continue :

These values must be set in order for the ALTIBASE HDB to operate properly.

They must be set such that they are suitable for the system configuration.

=====================================

Press [Enter] to continue :

----------------------------------------------------------------------------

ALTIBASE HDB Property Settings

Step 1: Basic Database Operation Properties

Database name [mydb]: idp

ALTIBASE HDB connection port number (1024-65535)      [20300]: 8095

If you want to use the ALTIBASE HDB evaluation license, 

set the 'Maximum size of memory database' property to 2GB or less.

Maximum size of memory database

-MIN value:16M (K,M,G)      [2G]: 16M

Buffer area size for caching disk-based database pages

-MIN value:1M (K,M,G)      [128M]: 1M

Do you want to create a database after the installation is complete?

[1] YES

[2] NO

Please choose an option [1] : 1

----------------------------------------------------------------------------

ALTIBASE HDB Property Settings

Step 2: Database Creation Properties

Initialization database size

-4M~16M (K,M,G)      [10M]: 4M

Database archive logging mode 

[1] NoArchivelog

[2] Archivelog

Please choose an option [1] : 2

Database character set

[1] MS949

[2] US7ASCII

[3] KO16KSC5601

[4] BIG5

[5] GB231280

[6] UTF-8

[7] SHIFT-JIS

[8] EUC-JP

Please choose an option [1] : 1

National character set

[1] UTF-16

[2] UTF-8

Please choose an option [1] : 1

----------------------------------------------------------------------------

ALTIBASE HDB Property Settings

Step 3: Database Directory Properties

Default disk database directory [/app/altibase/dbs]: 

Memory database directory [/app/altibase/dbs]: 

Archive log directory [/app/altibase/arch_logs]: 

Transaction log directory [/app/altibase/logs]: 

[Log Anchor file Directories ]

The ALTIBASE HDB maintains three sets of log anchor files. These files contain 

important information

about the database. By default, they are located in the "logs" folder.

The location can be changed here or by modifying the contents of the ALTIBASE 

properties file,

which is named "altibase.properties".

Directory 1. [/app/altibase/logs]: 

Directory 2. [/app/altibase/logs]: 

Directory 3. [/app/altibase/logs]: 

----------------------------------------------------------------------------

Property Review

Please check your property settings.

To change these properties after installation is complete, 

please modify the following file :

  /app/altibase/conf/altibase.properties.

1. ALTIBASE HDB Property Settings :

    Step 1: Basic Database Operation Properties

    1) Database name :

         [idp]

    2) ALTIBASE HDB connection port number (1024-65535) :

         [8095]

    3) Maximum size of memory database :

         [16M]

    4) Buffer area size for caching disk-based database pages :

         [1M]

2. ALTIBASE HDB Property Settings :

Press [Enter] to continue :

    Step 2: Database Creation Properties

    1) Initial database size

         [4M]

    2) Database archive logging mode

         [archivelog]

    3) Database character set

         [MS949]

    4) National character set

         [UTF16]

3. ALTIBASE HDB Property Settings :

    Step 3: Database Directory Properties

    The database will not operate properly if one or more of these drectories 

are removed.

    1) Disk database directory : 

         [/app/altibase/dbs] 

Press [Enter] to continue :

    2) Memory database directory :

         [/app/altibase/dbs] 

    3) Archive log directory :

         [/app/altibase/arch_logs] 

    4) Transaction log directory :

         [/app/altibase/logs] 

    5) Log Anchor file directories :

         Directory 1 : 

         [/app/altibase/logs] 

         Directory 2 : 

         [/app/altibase/logs] 

         Directory 3 : 

         [/app/altibase/logs] 

Press [Enter] to continue :

----------------------------------------------------------------------------

Setup is now ready to install ALTIBASE HDB Server 5.5.1.3.0.

Do you want to continue? [Y/n]: Y

----------------------------------------------------------------------------

Please wait until the setup wizard finishes installing ALTIBASE HDB Server 

5.5.1.3.0.

 Installing

 0% ______________ 50% ______________ 100%

 #########################################

----------------------------------------------------------------------------

ALTIBASE HDB License

If a license has not been issued, or if it has expired,

ALTIBASE HDB services will not start.

If this is the case, Please visit   http://atc.altibase.com

or contact ALTIBASE Technical support (license@altibase.com)

 - If you set 'Maximum size of memory database' to 2GB or less, 

   you can use the ALTIBASE HDB evaluation license.

   You can change the maximum size using the MEM_MAX_DB_SIZE property 

   in the altibase.properties file.

   ($ALTIBASE_HOME/conf/altibase.properties)

Choose an option for ALTIBASE license registration.

[1] Input a license key.

[2] Select a license file.

[3] I will use the ALTIBASE evaluation license.

[4] I do not have an ALTIBASE license.

Please choose an option [1] : 3

Info: Evaluation license registration is complete.

copy 

FROM : $ALTIBASE_HOME/conf/license_evaluation

TO : $ALTIBASE_HOME/conf/license

Press [Enter] to continue :

----------------------------------------------------------------------------

ALTIBASE Quick Setting Guide

[  Installation complete  ]

Please refer to the file listed below to verify the ALTIBASE HDB version.

    /app/altibase/APatch/patchinfo 

[ Quick Guide to Making Settings in ALTIBASE ] 

1. Set kernel variables using the root user account.

    run the '/app/altibase/install/pre_install.sh' file 

    - This script helps your kernel parameter settings.

================ LINUX ================

[ How to modify kernel parameter values ]

echo 512 32000 512 512 > /proc/sys/kernel/sem

echo 872415232 > /proc/sys/kernel/shmall

# shmall 

If it is desired to use the ALTIBASE HDB in shared memory mode, the value of 

'shmall' must be set. This value determines the maximum size of an ALTIBASE 

database.

Press [Enter] to continue :

These values must be set in order for the ALTIBASE HDB to operate properly.

They must be set such that they are suitable for the system configuration.

=====================================

 

2. Provide a license.

    Please rename and locate the license file as shown below.

    /app/altibase/conf/license 

    If no license file has been issued, or if the license file has expired,

    ALTIBASE HDB services will not start.

    In this case, please visit http://atc.altibase.com

    or contact ALTIBASE Technical Support (license@altibase.com)

    -  If you set 'Maximum size of memory database' to 2GB or less, 

       you can use the ALTIBASE HDB evaluation license.

       copy

       FROM : /app/altibase/conf/license_evaluation

Press [Enter] to continue :

       TO : /app/altibase/conf/license 

       You can change the maximum size using the MEM_MAX_DB_SIZE property 

       in the altibase.properties file.

       ($ALTIBASE_HOME/conf/altibase.properties)

3. Configure user environment variables (using the user account with which 

ALTIBASE was installed).

    Run the '/app/altibase/install/post_install.sh' file 

    under the account with which ALTIBASE was installed.

    This script performs necessary post-installation configuration. 

    1) Create the ALTIBASE user environment file and apply to the user profile.

         (/app/altibase/conf/altibase_user.env)

    2) Create a database.

         If you selected 'YES' in response to the question about whether to 

create a database 

         after installation, at "ALTIBASE Property setting step 1",

         If you selected 'NO' in response to this question,

         you need  to create a database manually.

Press [Enter] to continue :

         shell> server create [DB Character Set] [National Character Set]

4. Start up and Shut down the server

    shell> server start

    shell> server stop

5. Connect to the database using iSQL

    shell> isql -s 127.0.0.1 -u SYS -p MANAGER

Press [Enter] to continue :

Would you like to launch 'post_install.sh' now ?

 - It will create the ALTIBASE user environment file and the database. [Y/n]: Y

-

/

Result

[Linux Env.]

Target : /app/altibase/conf/altibase_user.env

created  ----------------------- Altibase environment setup file.

added    ----------------------- ALTIBASE_HOME

added    ----------------------- PATH

added    ----------------------- LD_LIBRARY_PATH

added    ----------------------- CLASSPATH

        export ----------------------- 'altibase_user.env' into 

'/home/vagrant/.profile'

-----------------------------------------------------------------

     Altibase Client Query utility.

     Release Version 5.5.1.3.0

     Copyright 2000, ALTIBASE Corporation or its subsidiaries.

     All Rights Reserved.

-----------------------------------------------------------------

ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 8095

[ERR-910FB : Connected to idle instance]

Connecting to the DB server.... Connected.

Press [Enter] to continue :

TRANSITION TO PHASE : PROCESS

Command executed successfully.

DB Info (Page Size     = 32768)

        (Page Count    = 129)

        (Total DB Size = 4227072)

        (DB File Size  = 1073741824)

Creating MMDB FILES     [SUCCESS]

Creating Catalog Tables [SUCCESS]

Creating DRDB FILES     [SUCCESS]

  [SM] Rebuilding Indices [Total Count:0]  [SUCCESS]

DB Writing Completed. All Done.

Create success.

Press [Enter] to continue :==============================================

Please perform [re-login] 

or [source /home/vagrant/.profile] 

or [. /home/vagrant/.profile]

==============================================

Press [Enter] to continue :

----------------------------------------------------------------------------

Setup has finished installing the ALTIBASE HDB Server 5.5.1.3.0 on your host.

2. DB 실행 

$ export ALTIBASE_HOME=/app/altibase

$ chown -R vagrant.vagrant /app/altibase/

$ /bin/isql  -s 127.0.0.1 -u sys -p manager -sysdba -port 8095

(sudo 계정으로 하면 db 실행이 안됨, 계정 단위 작업 중요)