ASE12.5 for Linux installation issues

With the development of Linux in the country, more and more units began to adopt a Linux based system platform, Sybase for Linux operating system, The introduction of the Sybasease12.5forlinux database system, of which 12.5.0.2 previous database versions are based on the RedHat6.2 kernel, starting from the 12.5.0.2, Sybase database system on the RedHat7.2 of the recompile, after recompilation, the system can now Supports POSIX asynchronous I/O, support for large file systems, and LDAP. At present, the highest version of Redhat is 8.0,ase12.5.0.2 running on RH7.1 and 7.2, which is completely fine. In the SybaseASE12.5 installation process, the customer reflects some problems, the following are the problems we found and the solution:

First, EBF10581

EBF10581 is a necessary step to upgrade ASE12.5 to 12.5.0.2, but after the installation of the patch, the database server, the speed will be particularly slow, about 40 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.

II. installation issues for REDHAT8

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:

1. 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.

2. Sybase users cannot be automatically added to the Sybase installation when they are finished, 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–ivhsybase-common-12.5-3

Rpm–ivhsybase-ase-12.5-3

Rom–ivhsybase-openclient-12.5-3

3. Play EBF10581 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–rsybase: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-qsybase-common|grep12.5 '

if["$PREFIX"];then

Exportsybase= ' Rpm-q--queryformat '%{installprefix} ' $PREFIX '

Else

exportsybase=/opt/sybase-12.5

Fi

And then add

exportsybase=/opt/sybase-12.5

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

Third, the use of logical volumes
Under the current Intel architecture, a partition of one hard disk can contain 4 primary partitions hdx1-hdx4 (IDE) or SDX1-SDX4 (SCSI) (which contains an extended partition), and 12 Logical Disk hdx5-hdx16 (IDE) can be established in the extended partition. or sdx5-sdx16 (SCSI), where x can be set to a, B, C, D, etc. according to the order in which the hard disk is installed, so there are only 15 available partitions on the Redhat operating system with only one hard drive or RAID disk. In a production system where REDHAT7 and 8 are installed, the partitions in the operating system are generally included:

/

/usr

/boot

/tmp

/home

/var

/proc

Swap