Dameng 7 Database Installation Records

# NOTE 1: This document is suitable for Rhel/oel/centos 5/6.x x64 or the successful Kylin operating system.
# Organize the complete installation process record.

First, the Dream database installation and use 1. Modify the local Hosts file

# vi/etc/hosts
192.168.14.180 Node1

2. The commands to create user groups and users are as follows

Groupadd Dinstall
Useradd-g dinstall-m-d/home/dmdba-s/bin/bash dmdba
passwd DMDBA

3. Create a database directory

Mkdir-p/opt/dmdbms
Chown-r Dmdba.dinstall/opt/dmdbms
Chmod-r 775/opt/dmdbms

4. modifying file descriptors

Cat >>/etc/security/limits.conf << EOF
DMDBA Soft Nproc 2047
DMDBA Hard Nproc 16384
DMDBA Soft Nofile 1024
DMDBA Hard Nofile 65536
Eof

5. Modify Login Authentication Module

Cat >>/etc/pam.d/login << EOF
Session required/lib64/security/pam_limits.so
Eof

6. Modify kernel support (kernel parameter optimization)

# vi/etc/sysctl.conf

Kernel.shmall = 2097152
Kernel.shmmax = 4294967296
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Fs.file-max = 359670
Net.ipv4.ip_local_port_range = 9000 65500
Net.core.rmem_default = 1048576
Net.core.rmem_max = 1048576
Net.core.wmem_default = 262144
Net.core.wmem_max = 262144

# sysctl-p

7. Modify the DMBMS Path variable

Su-dmdba
VI. bash_profile
Export ld_library_path= "/opt/dmdbms/bin: $LD _library_path"
Export Path=/opt/dmdbms/bin:: $PATH

8. DM7 Installation

Note: If a console can be installed by the console, it can also be installed in VNC mode.

(1) Installation of Remote VNC service mode

# for the server in the remote room in the case of the installation, previously ran Vncserver, configured password.
# Vi/root/.vnc/xstartup
#!/bin/sh

# Uncomment the following-lines for normal desktop:
Unset Session_manager
Exec/etc/x11/xinit/xinitrc

or directly cancel the above unset as well as the comments with exec.

# vncserver:1
# vncserver-kill:1 off Desktop number: 1

(2) Preparing the Software installation media

General authorization file Dm.key file to/opt/dmdbms directory
and the installation package into the/HOME/DMDBA directory.
Chown Dmdba:dinstall/home/dmdba/dminstall.bin

(3) VNC Client connection start installing database software

# Xhost +
Access control disabled, clients can connect from any host

$ su-dmdba
$./dminstall.bin

The entire process is installed as a wizard, in the database installation directory/opt/dmdbms and in the/opt/dmdbms/data directory.
In the middle, the following actions are performed by the root user:
Mv/opt/dmdbms/bin/dm_svc.conf/etc/dm_svc.conf
/opt/dmdbms/script/root/root_db_service_install.sh-s Dmservicedmserver
Registration Service Mode

9, confirm the DM database installation complete (1) port confirmation 5236

# NETSTAT-TUNLP
Active Internet connections (only servers)
Proto recv-q send-q Local address Foreign address State Pid/program Name
TCP 0 0 0.0.0.0:5236 0.0.0.0:* LISTEN 3297/dmserver
TCP 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 3159/sshd

(2) database start-up service starts from start

# chkconfig--list |grep DM
Dmservicedmserver 0: Off 1: Off 2: Enable 3: Enable 4: Enable 5: Enable 6: Off

(3) Start and close by service mode

Service Dmservicedmserver Stop
Service Dmservicedmserver Start

This article is from the "Koumm Linux Technology blog" blog, be sure to keep this source http://koumm.blog.51cto.com/703525/1882502

Dameng 7 Database Installation Records