Shulou(Shulou.com)06/01 Report--

Components of the Sybase database:

As we all know, the Sybase database consists of three main parts as follows:

1. An online relational database management system Sybase SQL Server for database management and maintenance

This case is a centos6.5 operating system, and the version of sybase database is 15.7.

2. A set of front-end tools Sybase SQL Toolset, which supports the establishment and development of database application system.

3. The interface Sybase Open Client/Open Server that can connect the application software of other manufacturers in the heterogeneous environment with any type of data.

Understand the composition of the Sybase database, then how to build it? today, we will mainly explain the process of building the Sybase database. There is no detailed explanation for installing the operating system here.

The operating system involved in this paper is centos6.5 operating system, and the version of sybase database is 15.7.

After installation, configure IP under root and change it to dynamic acquisition so that it can link to the network.

Vi / etc/sysconfig/network-scripts/ifcfg-eth0

Restart the service

Service network restart

Download the JDK installation package jdk-10.0.2_linux-x64_bin.rpm and install it under / usr/local:

Rpm-ivh jdk-10.0.2_linux-x64_bin.rpm

Do the following to see if the information is normal:

Java

Javac

Java-version

Modify the system environment variable file

Vi + / etc/profile

Append the following to the file:

Make the changes take effect immediately:

Source / etc/profile

View the status of the system environment

Create a sybase user

Adduser sybase

Create the sybase database installation package storage path

Mkdir / tmp/sybase

Give permissions to the installation package storage path

Chown-R sybase:sybase / tmp/sybase

Create the sybase database installation path

Mkdir / opt/sybase

Assign permissions to the installation path

Chown-R sybase:sybase / opt/Sybase

Put the sybase database installation package ase157_linuxx86-64.tgz to the installation package storage path

Extract the installation package

Tar zxvf ase157_linuxx86-64.tgz

Download the dependency packages required for installation

Yum-y install gcc glibc libX compat

Yum install compat-libstdc*

Yum install glibci686

Switch sybase user

Su-sybase

Enter the installation package storage path

Cd / tmp/sybase

Execute to start installation

. / setup.bin

Click next

Select the installation path and click next

Select full installation and click next

To install the free version, click next.

Select "agree" and click next

Click install

Installing

Select the first two items and click next

To set the password, click next

Click next

Click next

Click next

Installation succeeded

After the installation is complete, set the environment variable of sybase, in the directory / opt/sybase directory, execute

Cat SYBASE.sh > > .bash _ profile

Append the environment variable to .bash _ profile and add the following line to .bash _ profile

LANG=en

Export LANG

If you do not set this, you cannot link to the sybase server through the isql command

Cd / opt/Sybase

Source SYBASE.sh

Export LD_POINTER_GUARD=0

Cd ASE-15_0

Export LD_POINTER_GUARD=0

Cd / opt/sybase/ASE-15_0/install

Restart the service

Startserver-f RUN_LOCALHOST

View Servic

Showserver

Set the client-side locale transformation, which is the only way to use the isql command

Vi / opt/sybase/locales/locales.dat

Locate the [linux] section and add the following under it

Locale = us_english,Chinese,utf8

Locale = zh_CN.UTF-8,Chinese,utf8

Locale = zh_CN.GBK,Chinese,eucgb

After the configuration is completed

Isql-SLOCALHOST-Usa login database

At this point, the construction step is over.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.