Install Sybase ASE15.70 in redhat6.4, and redhat6.4ase15.70

Install Sybase ASE15.70 in redhat6.4, and redhat6.4ase15.70
Preface

A new project uses Sybase ASE15.70, a database that has never been used. You can install it first.

Installation preparation

Operating System

To reduce the trouble, try to prepare the environment as required. First install a rhel-server-6.4-x86_64 version of linux, install type selection base server. After installation.

Set local yum Source

During Sybase installation, some software packages need to be installed and updated. Because of the redhat version of linux, it cannot be used by non-registered users, therefore, we used the redhat installation image ISO file to set the local yum source. For more information, see redhat setting the local ISO as the yum source.

Added 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 installed by sybase.

Upload installation media

su - sybasemkdir software

Switch to the sybase user and create a software Directory to store the sybase Installation File.

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

cd /opt/sybase/softwaretar -zxvf ase1570_linx8664_64.tgz

Go to the installation directory and decompress ase1570_linx8664_64.tgz.

Solve the problem of missing dependency packages

Then execute./setup. bin in the current directory.

The result is as follows:

The prompt for a lack of ld-linux.so.2, we can use the following command to query which package the so file contains

 yum provides ld-linux.so.2

The following message is displayed:

The result shows that 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 the i686 matching character must be added here. If you use yum install glibc * for installation, the system will automatically install the 64-bit package based on your operating system version (64-bit. Could not solve the problem with the lack of ld-linux.so.2 files above.

At this point, all preparations before the installation of Sybase ase are solved, and the next step is the formal installation step.

Install Sybase

Run./setup. bin in the/opt/sybase/software Directory to start the installation process.

Select region settings

Select Simplified Chinese

Select the installation path

After a step-by-step prompt, the installation path selection page is displayed.

If you select the default path, press Enter. If you want to install it in another directory, enter the directory path. Note that the path here must exist and the owner is a sybase user.

Here, the default value is selected. Press enter to continue.

Select the installation type

Select the installation type here. I chose 2 for full installation.

Select a license type

I selected 1

Specify License Agreement

License

Select 3 here. In the test environment, you do not need to permit a small number of connections.

Select the installation version

Test environment doesn't matter. Here I choose 1

Select the license type

No permission. Select 3

Select Software Asset Management notification

Show Installation Summary

All configurations during installation are displayed. Just take a look. Press enter to start the installation process.

Software Installed

Sybase Configuration

The configuration work follows the preceding installation process and starts automatically.

Remember password?

Configuration server

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

Configure the application type and page size

Configure the default language and Character Set

Configure the default sorting method

Configure Server Parameters

Configuration Management Account and display configuration Summary

After the configuration, the server is successfully configured and automatically started.

Set Sybase Environment Variables

In the/opt/sybase directory, run

cat SYBASE.sh >>.bash_profile

Append environment variables to. bash_profile

Add the following rows to. bash_profile:

LANG=enexport LANG

If this parameter is not set, you cannot use the isql command to connect to the sybase server.

Modify sa Password

Execute Command

isql -u sa -P -SCMBIDB

Enter the Sybase Interactive Client. The default sa password is blank, and CMBIDB is the service name.

Run the following command to modify the sa password.

sp_password null,'new password'

go

Modify the sa password. Then you can connect to sybase through sa.

Basic Maintenance command stopped

In the Sybase Interactive Client, run

shutdowngo

You can disable the service.

You can also execute

showserver

Display related processes and kill them to stop the service (not recommended)

Start

Execute Command

startserver -f RUN_CMBIDB

Postscript

Now, the installation is basically complete. Optimization and maintenance are even more important questions. The above steps may be omitted. Please make up your mind.