[YshanDB认证]yashandb安装实战

YCA官方报名链接：https://jsj.top/f/GGXYlU

安装下载地址https://linked.yashandb.com/resource/yashandb-personal-23.2.1.100-linux-x86_64.tar.gz

1.关闭交换分区（目的是为最大限度使用物理内存）

# sysctl -w vm.swappiness=0

# echo " vm.swappiness = 0">> /etc / sysctl.conf

2.调整自动分配本地端口范围

# sysctl -w net.ipv4.ip_local_por t_range='32768 60999'

# echo "net.ipv4.ip_local_por t_range = 32768 60999" >> / etc / sysctl.conf

3.调整进程的VMA上限

# sysctl -w vm.max_map_count=2000000

# echo " vm.max_map_count=2000000" >> / etc / sysctl.conf

4.变量生效

# sysctl -p

调整资源限制值

5.修改配置文件

# vi /etc /security/ limits.conf

6.在文件 /etc/security/ limits.conf 后面添加以下内容:

yashan sof t nofile 65536 

yashan hard nofile 65536

yashan sof t nproc 65536 

yashan hard nproc 65536

yashan sof t rss unlimited 

yashan hard rss unlimited

yashan sof t stack 8192 

yashan hard stack 8192

7.创建YashanDB用户

# useradd yashan

# passwd yashan

# su - yashan 

8.创建软件安装目录

$ mkdir ~/install

$ cd ~/install

9.解压缩YashanDB软件包

$ tar - xf yashandb-22.2.1.1- linux - x86_64.tar.gz

[yashan@ycadb install]$ cd scripts/

[yashan@ycadb scripts]$ ls - lh 

10.安装参数调整

$ cat install.ini

[install]

YASDB_HOME=~/yashandb/yasdb_home

YASDB_DATA=~/yashandb/yasdb_data

R EDO _ F I L E _ S I Z E = 1 0 0M

R EDO _ F I L E _NUM S= 4

INSTALL_SIMPLE_SCHEMA_SALES=N

NLS_CHARACTERSET=UTF8

[instance]

LISTEN_ADDR=0.0.0.0:1688

DB_BLOCK_SIZE=8K

DATA _BU F F ER _ S I Z E = 2 5 6M

SH AR E _POO L _ S I Z E = 2 5 6M

WORK_ARE A_POOL_SIZE=32M

L ARGE_POOL_SIZE=32M

REDO_BUFFER_SIZE=8M

UNDO_RETENTION=300

OPEN_CURSORS=310

MAX_SESSIONS=1024

RUN_LOG_LEVEL=INFO

NODE_ID=1-1:1

11.执行安装

$ cd ~/install/scripts/

$ ./install.sh

$ ./initDB.sh

12.生效环境变量

$ source ~/.bashrc

13.验证安装是否成功

$ yasql sys/yasdb_123

SQL> select status from v$instance ;

SQL> select database_name from v$database ;