人大金仓V8R6 for RHEL7.6_3.10.0-957.el7-CSDN博客

本文链接：https://blog.csdn.net/qq_35435160/article/details/122695058

人大金仓数据库安装

查看Linux系统版本信息

[root@localhost ~]# cat /proc/version

Linux version 3.10.0-957.el7.x86_64 (mockbuild@x86-040.build.eng.bos.redhat.com) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-36) (GCC) ) #1 SMP Thu Oct 4 20:48:51 UTC 2018

查看Linux发行版本ID及描述信息

[root@localhost ~]# yum install -y redhat-lsb-core

[root@localhost ~]# lsb_release -id

Distributor ID: RedHatEnterpriseServer

Description: Red Hat Enterprise Linux Server release 7.6 (Maipo)

查看CPU信息

[root@localhost ~]# lscpu

Architecture: x86_64

CPU op-mode(s): 32-bit, 64-bit

Byte Order: Little Endian

CPU(s): 2

On-line CPU(s) list: 0,1

Thread(s) per core: 1

Core(s) per socket: 2

Socket(s): 1

NUMA node(s): 1

Vendor ID: GenuineIntel

CPU family: 6

Model: 126

Model name: Intel(R) Core(TM) i5-1035G1 CPU @ 1.00GHz

Stepping: 5

CPU MHz: 1190.400

BogoMIPS: 2380.80

Hypervisor vendor: VMware

Virtualization type: full

L1d cache: 48K

L1i cache: 32K

L2 cache: 512K

L3 cache: 6144K

NUMA node0 CPU(s): 0,1

查看内存信息

[root@localhost ~]# free -m

total used free shared buff/cache available

Mem: 3932 1043 1376 71 1511 2457

Swap: 3967 22 3945

设置yum源

查看镜像是否挂载

[root@localhost ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/rhel-root 46G 4.1G 42G 10% /

devtmpfs 2.0G 0 2.0G 0% /dev

tmpfs 2.0G 0 2.0G 0% /dev/shm

tmpfs 2.0G 13M 2.0G 1% /run

tmpfs 2.0G 0 2.0G 0% /sys/fs/cgroup

/dev/sda1 1014M 165M 850M 17% /boot

tmpfs 394M 4.0K 394M 1% /run/user/42

tmpfs 394M 60K 394M 1% /run/user/0

新建挂载目录

[root@localhost ~]# mkdir -p /media/cdrom

将镜像挂载到目录

[root@localhost ~]# mount /dev/cdrom /media/cdrom/

mount: block device /dev/sr0 is write-protected, mounting read-only

编辑yum源配置文件

[root@localhost ~]# vi /etc/yum.repos.d/rhel.repo

[rhel]

name=rhel

baseurl=file:///media/cdrom

enabled=1

gpgcheck=0

清空并重新加载yum仓库

[root@localhost ~]# yum clean all

[root@localhost ~]# yum repolist all

安装软件包

[root@localhost ~]# yum -y install coreutils glib2 lrzsz dstat sysstat e4fsprogs xfsprogs ntp readline-devel zlib-delvel openssl-devel pam-devel libxml2-devel libxslt-devel python-devel tcl-devel gcc gcc-c++ make smartmontools flex bison perl-devel perl-ExtUtils* openldap-devel jadetex openjade bzip2

查询软件包是否安装

[root@localhost ~]# rpm -qa | grep coreutils

policycoreutils-2.5-29.el7.x86_64

policycoreutils-python-2.5-29.el7.x86_64

coreutils-8.22-23.el7.x86_64

[root@localhost ~]# rpm -qa | grep glib2

glib2-2.56.1-2.el7.x86_64

pulseaudio-libs-glib2-10.0-5.el7.x86_64

[root@localhost ~]# rpm -qa | grep lrzsz

lrzsz-0.12.20-36.el7.x86_64

[root@localhost ~]# rpm -qa | grep dstat

dstat-0.7.2-12.el7.noarch

[root@localhost ~]# rpm -qa | grep sysstat

sysstat-10.1.5-17.el7.x86_64

[root@localhost ~]# rpm -qa | grep e4fsprogs

[root@localhost ~]# rpm -qa | grep e4fspr

[root@localhost ~]# yum -y install e4fsprogs*

Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Package e2fsprogs-1.42.9-13.el7.x86_64 already installed and latest version

Nothing to do

[root@localhost ~]# rpm -qa | grep e2fsprogs

e2fsprogs-libs-1.42.9-13.el7.x86_64

e2fsprogs-1.42.9-13.el7.x86_64

[root@localhost ~]# rpm -qa | grep xfsprogs

xfsprogs-4.5.0-18.el7.x86_64

[root@localhost ~]# rpm -qa | grep ntp

ntpdate-4.2.6p5-28.el7.x86_64

fontpackages-filesystem-1.44-8.el7.noarch

ntp-4.2.6p5-28.el7.x86_64

python-ntplib-0.3.2-1.el7.noarch

[root@localhost ~]# rpm -qa | grep readline-devel

readline-devel-6.2-10.el7.x86_64

[root@localhost ~]# rpm -qa | grep zlib-devel

zlib-devel-1.2.7-18.el7.x86_64

[root@localhost ~]# rpm -qa | grep openssl-devel

openssl-devel-1.0.2k-16.el7.x86_64

[root@localhost ~]# rpm -qa | grep pam-devel

pam-devel-1.1.8-22.el7.x86_64

[root@localhost ~]# rpm -qa | grep libxml2-devel

libxml2-devel-2.9.1-6.el7_2.3.x86_64

[root@localhost ~]# rpm -qa | grep libxslt-devel

libxslt-devel-1.1.28-5.el7.x86_64

[root@localhost ~]# rpm -qa | grep python-devel

python-devel-2.7.5-76.el7.x86_64

[root@localhost ~]# rpm -qa | grep tcl-devel

tcl-devel-8.5.13-8.el7.x86_64

[root@localhost ~]# rpm -qa | grep gcc

gcc-gfortran-4.8.5-36.el7.x86_64

gcc-4.8.5-36.el7.x86_64

gcc-c++-4.8.5-36.el7.x86_64

libgcc-4.8.5-36.el7.x86_64

[root@localhost ~]# rpm -qa | grep gcc-c++

gcc-c++-4.8.5-36.el7.x86_64

[root@localhost ~]# rpm -qa | grep make

make-3.82-23.el7.x86_64

automake-1.13.4-3.el7.noarch

[root@localhost ~]# rpm -qa | grep smartmontools

smartmontools-6.5-1.el7.x86_64

[root@localhost ~]# rpm -qa | grep flex

flex-2.5.37-6.el7.x86_64

[root@localhost ~]# rpm -qa | grep bison

bison-3.0.4-2.el7.x86_64

[root@localhost ~]# rpm -qa | grep perl-devel

perl-devel-5.16.3-293.el7.x86_64

[root@localhost ~]# rpm -qa | grep perl-ExtUtils

perl-ExtUtils-MakeMaker-6.68-3.el7.noarch

perl-ExtUtils-Manifest-1.61-244.el7.noarch

perl-ExtUtils-Install-1.58-293.el7.noarch

perl-ExtUtils-Embed-1.30-293.el7.noarch

perl-ExtUtils-CBuilder-0.28.2.6-293.el7.noarch

perl-ExtUtils-ParseXS-3.18-3.el7.noarch

[root@localhost ~]# rpm -qa | grep openldap-devel

openldap-devel-2.4.44-20.el7.x86_64

[root@localhost ~]# rpm -qa | grep jadetex

texlive-jadetex-bin-svn3006.0-43.20130427_r30134.el7.noarch

texlive-jadetex-svn23409.3.13-43.el7.noarch

[root@localhost ~]# rpm -qa | grep openjade

openjade-1.3.2-45.el7.x86_64

[root@localhost ~]# rpm -qa | grep bzip2

bzip2-1.0.6-13.el7.x86_64

bzip2-libs-1.0.6-13.el7.x86_64

设置内核参数

[root@localhost ~]# vi /etc/sysctl.conf

添加

#kernel.sem = SEMMSL SEMMNS SEMOPM SEMMNI

Kernel.sem = 512 64000 400 2560

[root@localhost ~]# vi /etc/systemd/logind.conf

添加

RemoveIPC=no

设置数据库软限制和硬限制

[root@localhost ~]# vi /etc/security/limits.conf

添加

kingbase soft nproc 65536

kingbase hard nproc 65536

kingbase soft nofile 65536

kingbase hard nofile 65536

[root@localhost ~]# lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT

sda 8:0 0 50G 0 disk

├─sda1 8:1 0 1G 0 part /boot

└─sda2 8:2 0 49G 0 part

├─rhel-root 253:0 0 45.1G 0 lvm /

└─rhel-swap 253:1 0 3.9G 0 lvm [SWAP]

sr0 11:0 1 4.2G 0 rom /media/cdrom

[root@localhost ~]# cat /etc/rc.local

添加

echo deadline > /sys/block/sda/queue/scheduler

[root@localhost ~]# bash /etc/rc.local

新建目录并授权，/soft放置数据库相关软件，/opt/Kingbase/ES/V8为数据库安装目录及数据目录，/opt/Kingbase/bak为数据库备份目录

[root@localhost ~]# mkdir -p /soft

[root@localhost ~]# chown -R kingbase:kingbase /soft

[root@localhost ~]# mkdir -p /opt/Kingbase/ES/V8

[root@localhost ~]# mkdir -p /opt/Kingbase/bak

[root@localhost ~]# chown -R kingbase:kingbase /opt/Kingbase

新建用户和同名用户组

[root@localhost ~]# useradd -m -U kingbase

设置oracle用户密码

[root@localhost ~]# passwd kingbase

配置kingbase用户环境

[root@localhost ~]# su - kingbase

[kingbase@localhost ~]$ vi .bash_profile

添加

export KINGBASE_DATA=/opt/Kingbase/ES/V8/data

export PATH=/opt/Kingbase/ES/V8/Server/bin:$PATH

配置生效

[kingbase@localhost ~]$ source .bash_profile

将数据库安装包上传至/soft目录，root用户解压

[root@localhost ~]# cd /soft/

[root@localhost soft]# ll

total 4

drwxr-xr-x. 3 root root 35 Jan 24 14:11 KingbaseES_V008R006C005B0023_Lin64_single_install

-rw-r--r--. 1 root root 2553 Jan 21 17:22 license_V8R6-enterprise.zip

以kingbase用户登陆数据库服务器图形化界面，如果以root用户登陆然后su切换到kingbase用户并安装人大金仓数据库，无法调出数据库图像化安装界面，只能命令行安装，同时会报错：Graphical installers are not supported by the VM. The console mode will be used instead…

[kingbase@localhost ~]$ cd /soft

[kingbase@localhost soft]$ ls

KingbaseES_V008R006C005B0023_Lin64_single_install license_12349 license_V8R6-enterprise.zip

[kingbase@localhost soft]$ cd KingbaseES_V008R006C005B0023_Lin64_single_install/

[kingbase@localhost KingbaseES_V008R006C005B0023_Lin64_single_install]$ cd SETUP/

[kingbase@localhost SETUP]$ ls

INSTALL.BIN MD5

[kingbase@localhost SETUP]$sh INSTALL.BIN