The steps of Sybase installed under Linux

Source: Internet
Author: User
Tags log modify sybase sybase database linux

The first operating system part--------LINUX one. REDHAT LINUX SERVER 7.2 Installation

1. Boot boot from CDROM installation using Redhat first Setup disk

2. Use the default installation language 中文版 and add Simplified Chinese as a system interface

3. RedHat 7.2 has two main types of installation: Install or upgrade. Choose install here.

4. Selecting the server---Type installation will empty all partition information on all hard drives.

5. Select partition mode and build Linux partition in the following mode

Device Boot size Id System Mount on

/DEV/SDA1 100M Linux/boot

/dev/sda2 1024M Linux Swap

/dev/sda3 15G Linux/

/DEV/SDA4 5 Extended

/dev/sda5 2G Unknown

/dev/sda6 2G Unknown

/DEV/SDA7 2G Unknown

/dev/sda8 2G Unknown

......

Note:/DEV/SDA4 to establish a Linux extended partition, the rest of the space is divided into, in order to be flexible to call later. After each partition size is 2048M, each partition will be used as a Sybase database device, and the partition type must be/DEV/SDA5 (unknown).

6. When you have finished formatting the partitions, select the time zone and select Asia-----shanghai

7. Enter the password for Superuser root, or you can create the necessary regular user account here. Leave the default options for MD5 password and shadow password.

8. Skip making Startup Disk

The second Sybase section--------ASE 12.5 for LINUX

A Installing Sybase database software using rpm

1. Log on to Linux with the root user

# Cd/mnt/cdrom/rpms

# RPM–IVH Sybase-common-12.5-3

# RPM–IVH Sybase-ase-12.5-3

# RPM–IVH Sybase-openclient-12.5-3

......

Install all RPM packages except for other languages.

2. At this point, ASE is loaded into the/opt/sybase-12.5 directory and the Sybase user is automatically added to the system, at which time the user account is set to a locked state. You need to manually activate the account and modify the initial password in the accounts management.

Two EBF11340 Patch

Sybase has launched the Sybase ASE12.5 for Linux database system for Linux operating systems, 12.5.0.2 before the database version is based on the RedHat6.2 kernel, starting from 12.5.0.2, Sybase database system on the RedHat7.2 compiled, after recompilation, the system can currently support POSIX asynchronous I/O, Support for large file systems and LDAP.

During the installation of Sybase ASE12.5, the following are the problems found and the workaround:

EBF11340 is a necessary step to upgrade ASE12.5 to 12.5.0.3, but after the installation of the patch, the database server, the speed will be particularly slow, about 45 minutes, or even longer, the phenomenon is normal, please wait patiently. After the server was established, the test found that asynchronous I/O could be supported, but there was still a problem with large file support, and the database could not have more than 2G of equipment.

Operation method

1. Create a new temporary directory

# MKDIR/EBF

2. Copy patch file to/EBF

3. # gunzip–s.tgz Ebf11340.tgz

# TAR–XVF Ebf11340.tar

4. Open the Unpacked directory

# RPM–UVH Sybase-common-12.5-3

# RPM–UVH Sybase-ase-12.5-3

# RPM–UVH Sybase-openclient-12.5-3

......

Upgrade all RPM packages except for other languages.

Three SYBASE Registration

Log in with Sybase users

$ cd/opt/sybase-12.5/sysam

$ lmgr

Enter the appropriate registration information (see certificate)

Four For REDHAT8 installation issues, Hu Jintao

There are some problems with the installation of ASE12.5 on REDHAT8, mainly because there are some differences in software such as RPM in RH7 and RH8, causing problems when installing on the RH8, the specific problems include:

* After the Sybase database is installed, KDE and GNOME graphics interfaces, SSH, and so on cannot be started. The reason for this is that Sybase needs to repair the/etc/ld.so.conf file during the installation process, but because it is incompatible, it causes the file to be emptied.

* Sybase users cannot be automatically added to Sybase installation and environment variables cannot be set correctly. The reason is due to an incompatible RPM version.

The solution is:

1. Before you install the Sybase database, first back up/etc/ld.so.conf:

Cp/etc/ld.so.conf/etc/ld.so.conf.sybase

2. Install Sybase database software with rpm

RPM–IVH sybase-common-12.5-3

RPM–IVH sybase-ase-12.5-3

RPM–IVH sybase-openclient-12.5-3

3. Play EBF11340 Patch

4. Create Sybase users

useradd–d/opt/sybase-12.5

5. Restore the/etc/ld.so.conf and make modifications:

Cp/etc/ld.so.conf.sybase/etc/ld.so.conf

Modify ld.so.conf at the end of the file to add

/opt/sybase-12.5/ase-12_5/lib

/opt/sybase-12.5/ocs-12_5/lib

And then save the disk and run it.

Ldconfig

6. Change the owner of the/opt/sybase-12.5 directory

Chown–r sybase:sybase/opt/sybase-12.5

7. The SYBASE user logs in, and then modifies the sybase.sh file, specifically to delete the following passage:

prefix= ' Rpm-q Sybase-common | grep 12.5 '

If ["$PREFIX"]; Then

Export sybase= ' rpm-q--queryformat '%{installprefix} ' $PREFIX '

Else

Export sybase=/opt/sybase-12.5

Fi

And then add

Export sybase=/opt/sybase-12.5

8. Restart the server, the problem has been basically resolved, you can follow the normal steps to establish the server.

Five Preparation before creating ASE server

Modify the/opt/sys/kernel/shmmax parameter to the actual number of physical memory (in bytes)

Modify the/etc/sysctl.conf file to add kernel.shmmax= memory (in bytes) after the line

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.