Install Sybase for linux

Part 1 Operating System -------- LINUX
1. redhat linux server 7.2 Installation
1. Use the first REDHAT installation disk to boot from the CDROM Installation Guide
2. Use the default installation language ENGLISH and add Simplified Chinese as the system interface.
3. RedHat 7.2 has two major installation methods: Install or Upgrade. Select INSTALL.
4. If you select SERVER> SERVER type, all partitions on all hard disks are cleared.
5. Select the partitioning method and create a linux partition in the following mode:
Device Boot size Id System Mount on
/Dev/sda1 100 M 83 Linux/boot
/Dev/sda2 1024 M 82 Linux swap
/Dev/sda3 15G 83 Linux/
/Dev/sda4 5 Extended
/Dev/sda5 2G 60 Unknown
/Dev/sda6 2G 60 Unknown
/Dev/sda7 2G 60 Unknown
/Dev/sda8 2G 60 Unknown
......
Note:/dev/sda4 creates linux extended partitions and divides all the remaining space into the partitions for flexible calling in the future. The size of each partition after/dev/sda5 is 2048 mb. In the future, each partition will be used as a sybase database device, and the partition type must be 60 unknown ).
6. After formatting the partition, select the time zone and select Asia ----- SHANGHAI.
7. Enter the root password of the Super User. You can also create a common user account here. Retain the default options for MD5 Password and Shadow Password.
8. Skip making a boot disk
Part 2 SYBASE -------- ASE 12.5 for LINUX

1. Use rpm to install Sybase Database Software
1. log on to linux as a 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 software packages except other languages.
2. At this time, ASE is mounted to the/opt/Sybase-12.5 directory, and the system automatically added the sybase user, the sybase user account is set to locked. You must manually activate the Account in Account Management and change the initial password.
Ii. EBF11340 patch
Sybase introduced the Sybase ASE12.5 for Linux Database System for Linux operating systems. database versions earlier than 12.5.0.2 are based on the RedHat6.2 kernel, starting from 12.5.0.2, the Sybase Database System is re-compiled on RedHat7.2. After re-compilation, the system can now support POSIX asynchronous I/O, large file systems, and LDAP.
During the installation of Sybase ASE12.5, the following are the problems found and solutions:
EBF11340 is a required step to upgrade ASE12.5 to 12.5.0.3. However, after installing the patch, it takes about 45 minutes or longer to build a database server, this is normal. Please wait. After the Server is established, it is found through testing that asynchronous I/O can be supported, but the support for large files still has problems, and the database device cannot exceed 2 GB.
Procedure
1. Create a temporary directory
# Mkdir/ebf
2. Copy the patch file to/ebf
3. # gunzip-S. tgz EBF11340.tgz
# Tar-xvf EBF11340.tar
4. Open the decompressed directory
# Rpm-Uvh sybase-common-12.5-3
# Rpm-Uvh sybase-ase-12.5-3
# Rpm-Uvh sybase-openclient-12.5-3
......
All rpm software packages except other languages of Upgrade.
Iii. SYBASE Registration
Use sybase User Login
$ Cd/opt/Sybase-12.5/SYSAM
$ Lmgr
Enter the relevant registration information for the certificate)
Iv. RedHat8 Installation Problems ******
Some problems may occur during RedHat8 installation. The main reason is that there are some differences between software such as RPM in RH7 and RH8, resulting in problems during RH8 installation, specific problems include:
* After the Sybase Database is installed, KDE and GNOME graphical interfaces and SSH cannot be started. This is because Sybase needs to repair the/etc/ld. so. conf file during installation, but the file is cleared due to incompatibility.
* After Sybase is installed, you cannot automatically add sybase users or set environment variables correctly. This is because the rpm version is incompatible.
Solution:
1. Before installing the Sybase Database, 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. Patch EBF11340
4. Create a sybase user
Useradd-d/opt/sybase-12.5
5. Restore/etc/ld. so. conf and modify it:
Cp/etc/ld. so. conf. sybase/etc/ld. so. conf
Modify ld. so. conf and add it to the end of the file.
/Opt/sybase-12.5/ASE-12_5/lib
/Opt/sybase-12.5/OCS-12_5/lib
Save the disk and run it.
Ldconfig
6. Change/opt/owner of the sybase-12.5 directory
Chown-R sybase: sybase/opt/sybase-12.5
7. log on to the sybase user and modify the SYBASE. sh file to delete the following paragraph:
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
Add
Export SYBASE =/opt/sybase-12.5
8. Restart the server. Now, the problem has been basically solved. You can follow the normal steps to establish the server.
5. Preparations before the ASE Server is created
Modify the/opt/sys/kernel/shmmax parameter to the actual physical memory size in bytes)
Modify the/etc/sysctl. conf file, and add kernel. shmmax = memory size in bytes in one line after the meeting)
6. Create ASE Server and BACKUP Server
1. Log On With sybase
2. Go to the installation directory
$ Cd/opt/sybase-12.5/ASE/bin
$ Asecfg
3. Select Build New Servers
4. Select the Adaptive Server and Backup Server. Note that the default name is the host name. Do not change the name normally.
5. Enter the installation options of the Adaptive Server as follows, and then continue
Master Device Path:/sybdata/master. dat
Sybsystemprocs Device Path:/sybdata/systemprocs. dat
Port Number: 5000
6. Enter the Backup Server Installation option as follows, and then press Build Server to continue
Port number: 5001
7. After the installation is complete, return to the sybsetup Main Window
8. Select Localize Adaptive Server, select the Adaptive Server name, and press OK to continue
9. Select the installation language as Us English,
The character set is Code Page 850,
The sorting method is Binary Sort Order for Code Page 850 (cp850)
10. Edit and modify/opt/sybase-12.5/SYBSERVER. cfg
SYBSERVER is the SYBASE server name)
Max network packet size = 2048
Default network packet size = 2048
Number of user connections = 100
Number of open indexes = 2000
Number of open objects = 1000
Number of locks = 150000
11. Stop and restart the sybase Server
12. Log On With isql Verification
13. Modify sybase Configuration
Log in with isql
Sp_configure "max mem", 184000 M
Go
Sp_cacheconfig "default data cache", "M"
Go
14. Modify the attributes of the/dev/nst0 file.
# Chomd 777/dev/nst0
15. Start isql, execute the following command to configure the drive and verify
Sp_addumpdevice "tape", tapedev, "/dev/nst0", xxxx
(Xxxx indicates the capacity of a single disk, in MB, which is slightly smaller than the actual capacity)
Go
Dump database master to tapedev with init
Go
7. Use raw partition and bare Device
1. Confirm that partitions are correctly created in the first part.
2. log in with root, modify the/dev/sysconfig/rawdevices file, and map the partition to the bare device.
Add the last line:
/Dev/raw/raw1/dev/sda5
/Dev/raw/raw2/dev/sda6
/Dev/raw/raw3/dev/sda7
/Dev/raw/raw4/dev/sda8
......
Until all allocated partitions are mapped, save and exit
3. Bind a device
# Cd/etc/rc. d/init. d
# Sh rawdeviceds start
4. Terminal-based execution
#/Sbin/chkconfig rawdevices on
5. Change file attributes
Chown sybase: sybase/dev/raw/raw1
Chown sybase: sybase/dev/raw/raw2
Chown sybase: sybase/dev/raw/raw3
Chown sybase: sybase/dev/raw/raw4
......
6. Set the startup configuration
Modify the/etc/rc. d/rc. local file
Add the last line:
Raw/dev/raw/raw1/dev/sda5
Raw/dev/raw/raw2/dev/sda6
Raw/dev/raw/raw3/dev/sda7
Raw/dev/raw/raw4/dev/sda8
......
Wait until all devices are added.