Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "the course of Building sybase Database Environment". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

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

After loading, under root.

Configure IP to be dynamically acquired 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 put it under / usr/local

Installation:

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 for sybase

Under the directory / opt/sybase directory, execute

Cat SYBASE.sh > > .bash _ profile

Append environment variables to .bash _ profile

Also 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

This is the end of the tutorial on Building a sybase Database Environment. Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.