Installation of the Sybase ASE15.70 version under redhat6.4

Objective

A new project has been made using a database Sybase ASE15.70 that has never been used. Nothing to say, install it first.

Installation Preparation

Operating system

In order to reduce trouble, try to prepare the environment as required. A rhel-server-6.4-x86_64 version of Linux is installed first, and the installation type is selected base server. After installation.

Set local Yum source

In the process of Sybase installation, some packages need to install the update, and because it is Redhat version of Linux, non-registered users can not use, so we use the Redhat installation image ISO file set local Yum source, reference article "Redhat Set local ISO to Yum source

Add Sybase users

Execute command

Useradd-d/opt/sybase

To add a Sybase user, set the home directory to the/opt/sybase directory, which will also be the home directory that Sybase installs.

Upload installation media

Su-sybasemkdir Software

Switch to the Sybase user and establish a software directory to hold the Sybase installation files.

Upload the ase1570_linx8664_64.tgz compressed installation media to the/opt/sybase/software directory.

CD/OPT/SYBASE/SOFTWARETAR-ZXVF ase1570_linx8664_64.tgz

Go to the installation directory unzip ase1570_linx8664_64.tgz

Resolve missing Dependency Package issues

It is then executed under the current directory./setup.bin

The results are as follows

Tip Missing ld-linux.so.2, we can use the following command to find out which package the so file contains

Yum provides ld-linux.so.2

Get the following tips

From the results, the missing information is in the glibc-2.12-1.107.el6.i686 package, so we switch to the root account to execute the command.

Yum Install glibc*i686*

Note that it is important to add i686 match characters, and if you install with yum install glibc*, the system will automatically install the 64-bit version of the package based on your operating system version (64-bit). The problem with the missing ld-linux.so.2 file above cannot be resolved.

Here, the preparation for all Sybase ASE installations is resolved, and the next step is to proceed to the formal installation steps.

Sybase installation

Execute the./setup.bin in the/opt/sybase/software directory, start the installation process, and generally go through the following steps

Select Regional Settings

Here you choose 2 Simplified Chinese

Select the installation path

After a hint, enter the installation path selection interface

If you choose the default path, enter the directory path if you want to install it in a different directory. Note that the path here must exist and the owner is a Sybase user.

Here I choose the default, direct return to continue

Select the installation type

Choose the type of installation here, I chose 2, fully installed

Select License Type

I chose 1.

Specify the license agreement

Specify license

Choose 3 here, in the test environment, the connection is not much can not require a license.

Select the installation version

Test environment actually doesn't matter, here I choose the 1

Select License Type

Without permission, it doesn't matter. I choose 3

Select Software Asset Management notifications

Show Installation Summary

All the configurations in the installation process are shown here. Take a look. Enter to start the formal installation process

Installation software complete

Sybase configuration

The configuration work is immediately followed by the above installation process and begins automatically.

Do you remember the password

Configure the server

Only 1 and 2 are configured here, and the rest is removed.

Configure application type and page size

Configure default language and default character set

Configuring the default sorting method

Configure Server Parameters

Configure Admin account and display configuration summary

After the end, the server configuration succeeds and starts automatically.

Setting environment variables for Sybase

Under the directory/opt/sybase directory, execute the

Cat sybase.sh >>.bash_profile

Append an environment variable to the. bash_profile

Also add the following lines in the. bash_profile

Lang=enexport LANG

If you do not set this, you cannot connect to the Sybase server by using the isql command

Modify the sa password

Execute command

Isql-u sa-p-scmbidb

Enter the Sybase interactive client. Where the SA default password is empty and CMBIDB is the service name.

Execute the following command to modify the sa password

sp_password null, ' New password '

Go

Modify the password for the SA. You can then connect Sybase through the SA to operate.

Basic Maintenance Command Stop

In the Sybase interactive client, execute the

Shutdowngo

Can close the service

You can also perform

Showserver

Display the associated process and then kill the process stop service (not recommended)

Start

Execute command

Startserver-f RUN_CMBIDB

Postscript

At this point, the installation is basically complete, as for optimization, maintenance is a bigger problem, no longer here to unfold. The above steps may be a bit missing. Please do your own brain repair.

Installation of the Sybase ASE15.70 version under redhat6.4