原 YashanDB个人版安装

发布日期 2023年11月21日 · 已更新 2023年12月11日  

0    261    1

Tags： 原创安装部署国产数据库YashanDB崖山数据库

👉 本文共约2368个字，系统预计阅读时间或需9分钟。

显示/隐藏全文目录

目录

• 下载
• 环境准备
• 安装
• 环境变量
• 启动和关闭
• YashanDB配套工具
• 错误解决
• 本地免密登录失败
• 问题描述
• 问题原因
• 解决办法
• dial tcp 127.0.0.1:1675: connect: connection refused
• 总结
• 参考

本页目录 隐藏

1) 下载

2) 环境准备

3) 安装

4) 环境变量

5) 相关文章

下载

https://download.yashandb.com/download

环境准备

http://doc.yashandb.com/yashandb/23.1/zh/%E5%BF%AB%E9%80%9F%E4%B8%8A%E6%89%8B/%E5%AE%89%E8%A3%85%E9%83%A8%E7%BD%B2/%E5%AE%89%E8%A3%85%E5%89%8D%E5%87%86%E5%A4%87/%E5%AE%89%E8%A3%85%E5%89%8D%E5%87%86%E5%A4%87.html

下表为个人开发环境最小配置，请根据如下配置自行调整软硬件配置。

项目	描述
操作系统	CentOS 7.6，kylin V10
CPU	X86_64，ARM64 2C
内存	4G
硬盘	50G
文件系统	SSD
网络	千兆以太网，支持TCP和UDP链接

安装

docker rm -f lhryashandb docker run -itd --name lhryashandb -h lhryashandb \ -p 1688:1688 -p 33389:3389 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --restart=always \ --privileged=true lhrbest/lhrcentos76:9.2 \ /usr/sbin/init docker exec -it lhryashandb bash wget https://linked.yashandb.com/resource/yashandb-personal-23.1.1.100-linux-x86_64.tar.gz useradd -d /home/yashan -m yashan echo "lhr"|passwd --stdin yashan groupadd YASDBA usermod -a -G YASDBA yashan cat >> /etc/security/limits.conf << "EOF" #add by yashandb * soft nofile 65536 * hard nofile 65536 * soft nproc 65536 * hard nproc 65536 * soft rss unlimited * hard rss unlimited * soft stack 8192 * hard stack 8192 EOF mkdir -p /yashandb/{install,data} tar -xvf /soft/yashandb-personal-23.1.1.100-linux-x86_64.tar.gz -C /yashandb/install chown -R yashan:yashan /yashandb chmod -R 755 /yashandb -- 生成参数文件：执行如下命令生成安装参数文件，ssh登录密码为创建yashan用户时指定的密码： su - yashan cd /yashandb/install/ ./bin/yasboot package se gen --cluster yashandb -u yashan -p lhr --ip 127.0.0.1 --port 22 \ --install-path /yashandb/install --data-path /yashandb/data \ --begin-port 1688 -- 安装 ./bin/yasboot package install -t /yashandb/install/hosts.toml -i yashandb-personal-23.1.0.100-linux-x86_64.tar.gz ./bin/yasboot cluster deploy -t /yashandb/install/yashandb.toml -- 环境变量 cd /yashandb/install/conf cat yashandb.bashrc >> ~/.bashrc source ~/.bashrc -- 修改sys密码 cd /yashandb/data/db-1-1/instance rm -rf yasdb.pwd yaspwd file=yasdb.pwd password=lhra@123 -- 查看YashanDB数据库状态 yasboot cluster status -c yashandb -- 登陆 yasql 'sys/"lhra@123"' yasql / as sysdba select open_mode from v$database; create user lhr identified by lhr; grant dba to lhr; alter user sys identified by lhr; -- 配置监听 远程登录 vi /yashandb/data/db-1-1/config/yasdb.ini LISTEN_ADDR=0.0.0.0:1688

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76

docker rm -f lhryashandb docker run -itd --name lhryashandb -h lhryashandb \   -p 1688:1688 -p 33389:3389 \   -v /sys/fs/cgroup:/sys/fs/cgroup \   --restart=always \   --privileged=true lhrbest/lhrcentos76:9.2 \   /usr/sbin/init   docker exec -it lhryashandb bash   wget https://linked.yashandb.com/resource/yashandb-personal-23.1.1.100-linux-x86_64.tar.gz   useradd -d /home/yashan -m yashan echo "lhr"|passwd --stdin  yashan   groupadd YASDBA usermod -a -G YASDBA yashan   cat >> /etc/security/limits.conf  << "EOF" #add by yashandb * soft nofile 65536 * hard nofile 65536 * soft nproc 65536 * hard nproc 65536 * soft rss unlimited * hard rss unlimited * soft stack 8192 * hard stack 8192 EOF   mkdir -p /yashandb/{install,data}   tar -xvf /soft/yashandb-personal-23.1.1.100-linux-x86_64.tar.gz -C /yashandb/install   chown -R yashan:yashan /yashandb chmod -R 755 /yashandb   -- 生成参数文件：执行如下命令生成安装参数文件，ssh登录密码为创建yashan用户时指定的密码： su - yashan cd /yashandb/install/ ./bin/yasboot package se gen --cluster yashandb -u yashan -p lhr --ip 127.0.0.1 --port 22 \ --install-path /yashandb/install  --data-path /yashandb/data \ --begin-port 1688   -- 安装 ./bin/yasboot package install -t /yashandb/install/hosts.toml -i yashandb-personal-23.1.0.100-linux-x86_64.tar.gz ./bin/yasboot cluster deploy -t  /yashandb/install/yashandb.toml   -- 环境变量 cd /yashandb/install/conf cat yashandb.bashrc >> ~/.bashrc source ~/.bashrc   -- 修改sys密码 cd /yashandb/data/db-1-1/instance rm -rf yasdb.pwd yaspwd file=yasdb.pwd password=lhra@123   -- 查看YashanDB数据库状态 yasboot cluster status -c yashandb   -- 登陆 yasql 'sys/"lhra@123"' yasql / as sysdba   select open_mode from v$database;   create user lhr identified by lhr; grant dba to lhr; alter user sys identified by lhr;   -- 配置监听 远程登录 vi /yashandb/data/db-1-1/config/yasdb.ini LISTEN_ADDR=0.0.0.0:1688

数据库安装过程中将实例自动切换成OPEN阶段，并创建名为yashandb的数据库。

日志：

[yashan@lhryashandb install]$ cd /yashandb/install/ [yashan@lhryashandb install]$ ./bin/yasboot package se gen --cluster yashandb -u yashan -p lhr --ip 127.0.0.1 --port 22 \ > --install-path /yashandb/install --data-path /yashandb/data \ > --begin-port 1688 hostid | group | node_type | node_name | listen_addr | replication_addr | data_path ----------------------------------------------------------------------------------------------- host0001 | dbg1 | db | 1-1 | 127.0.0.1:1688 | 127.0.0.1:1689 | /yashandb/data ----------+-------+-----------+-----------+----------------+------------------+---------------- Generate config success [yashan@lhryashandb install]$ [yashan@lhryashandb install]$ ll -lrt total 40 drwxr-xr-x 3 yashan yashan 21 Nov 9 18:16 plug-in -rwxr-xr-x 1 yashan yashan 14989 Nov 9 18:16 LICENSE drwxr-xr-x 3 yashan yashan 17 Nov 9 18:16 java -rwxr-xr-x 1 yashan yashan 11632 Nov 9 18:16 gitmoduleversion.dat drwxr-xr-x 2 yashan yashan 170 Nov 9 18:16 scripts drwxr-xr-x 2 yashan yashan 4096 Nov 9 18:16 lib drwxr-xr-x 2 yashan yashan 65 Nov 9 18:16 include drwxr-xr-x 5 yashan yashan 60 Nov 9 18:16 ext drwxr-xr-x 2 yashan yashan 152 Nov 9 18:16 conf drwxr-xr-x 6 yashan yashan 70 Nov 9 18:16 admin drwxrwxr-x 2 yashan yashan 25 Nov 13 15:43 om drwxr-xr-x 2 yashan yashan 227 Nov 13 15:43 bin -rw------- 1 yashan yashan 492 Nov 13 15:45 hosts.toml -rw------- 1 yashan yashan 660 Nov 13 15:45 yashandb.toml [yashan@lhryashandb install]$ pwd /yashandb/install [yashan@lhryashandb install]$ cat hosts.toml uuid = "655d609c10d65bf1ca46c7b6366f6e90" cluster = "yashandb" yas_type = "SE" secret_key = "64f955c9f00b01dc" isLocal = true add_yasdba = true [om] hostid = "host0001" [om.config] LISTEN_ADDR = "127.0.0.1:1675" [[host]] hostid = "host0001" group = "yashan" user = "yashan" password = "lhr" ip = "127.0.0.1" port = 22 path = "/yashandb/install" jvm_path = "" total_memory = 0 [host.yasagent] [host.yasagent.config] LISTEN_ADDR = "127.0.0.1:1676" [yashan@lhryashandb install]$ [yashan@lhryashandb install]$ ./bin/yasboot package install -t /yashandb/install/hosts.toml -i yashandb-personal-23.1.0.100-linux-x86_64.tar.gz checking install profile.toml... install version: yashandb 23.1.1.100 update host to yasom... [yashan@lhryashandb install]$ ./bin/yasboot cluster deploy -t /yashandb/install/yashandb.toml type | uuid | name | hostid | index | status | return_code | progress | cost ------------------------------------------------------------------------------------------------------------ task | 95d5d822b67ec478 | DeployYasdbCluster | - | yashandb | SUCCESS | 0 | 100 | 9 ------+------------------+--------------------+--------+----------+---------+-------------+----------+------ task completed, status: SUCCESS [yashan@lhryashandb install]$ [yashan@lhryashandb conf]$ cat yashandb.bashrc export YASDB_HOME=/yashandb/install export PATH=${YASDB_HOME}/bin:$PATH export LD_LIBRARY_PATH=${YASDB_HOME}/lib:$LD_LIBRARY_PATH if command -v rlwrap >/dev/null 2>&1; then alias yasql="rlwrap yasql" fi export YASDB_DATA=/yashandb/data/db-1-1 [yashan@lhryashandb conf]$ cd /yashandb/install/conf [yashan@lhryashandb conf]$ cat yashandb.bashrc >> ~/.bashrc [yashan@lhryashandb conf]$ source ~/.bashrc [yashan@lhryashandb conf]$ [yashan@lhryashandb instance]$ yaspwd file=yasdb.pwd password=lhra@123 [yashan@lhryashandb instance]$ yasboot cluster status -c yashandb host_id | node_type | nodeid | pid -------------------------------------- host0001 | db | 1-1:1 | 1085 ----------+-----------+--------+------ [yashan@lhryashandb instance]$ yasql 'sys/"lhra@123"' YashanDB SQL Personal Edition Release 23.1.1.100 x86_64 Connected to: YashanDB Server Personal Edition Release 23.1.1.100 x86_64 - X86 64bit Linux SQL> SQL> select * from v$version; BANNER VERSION_NUMBER ---------------------------------------------------------------- ----------------- Personal Edition Release 23.1.1.100 x86_64 23.1.1.100 1 row fetched. SQL>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103

[yashan@lhryashandb install]$ cd /yashandb/install/ [yashan@lhryashandb install]$ ./bin/yasboot package se gen --cluster yashandb -u yashan -p lhr --ip 127.0.0.1 --port 22 \ > --install-path /yashandb/install  --data-path /yashandb/data \ > --begin-port 1688   hostid   | group | node_type | node_name | listen_addr    | replication_addr | data_path       ----------------------------------------------------------------------------------------------- host0001 | dbg1  | db        | 1-1       | 127.0.0.1:1688 | 127.0.0.1:1689   | /yashandb/data ----------+-------+-----------+-----------+----------------+------------------+----------------   Generate config success [yashan@lhryashandb install]$ [yashan@lhryashandb install]$ ll -lrt total 40 drwxr-xr-x 3 yashan yashan    21 Nov  9 18:16 plug-in -rwxr-xr-x 1 yashan yashan 14989 Nov  9 18:16 LICENSE drwxr-xr-x 3 yashan yashan    17 Nov  9 18:16 java -rwxr-xr-x 1 yashan yashan 11632 Nov  9 18:16 gitmoduleversion.dat drwxr-xr-x 2 yashan yashan   170 Nov  9 18:16 scripts drwxr-xr-x 2 yashan yashan  4096 Nov  9 18:16 lib drwxr-xr-x 2 yashan yashan    65 Nov  9 18:16 include drwxr-xr-x 5 yashan yashan    60 Nov  9 18:16 ext drwxr-xr-x 2 yashan yashan   152 Nov  9 18:16 conf drwxr-xr-x 6 yashan yashan    70 Nov  9 18:16 admin drwxrwxr-x 2 yashan yashan    25 Nov 13 15:43 om drwxr-xr-x 2 yashan yashan   227 Nov 13 15:43 bin -rw------- 1 yashan yashan   492 Nov 13 15:45 hosts.toml -rw------- 1 yashan yashan   660 Nov 13 15:45 yashandb.toml [yashan@lhryashandb install]$ pwd /yashandb/install [yashan@lhryashandb install]$ cat hosts.toml uuid = "655d609c10d65bf1ca46c7b6366f6e90" cluster = "yashandb" yas_type = "SE" secret_key = "64f955c9f00b01dc" isLocal = true add_yasdba = true   [om]   hostid = "host0001"   [om.config]     LISTEN_ADDR = "127.0.0.1:1675"   [[host]]   hostid = "host0001"   group = "yashan"   user = "yashan"   password = "lhr"   ip = "127.0.0.1"   port = 22   path = "/yashandb/install"   jvm_path = ""   total_memory = 0   [host.yasagent]     [host.yasagent.config]       LISTEN_ADDR = "127.0.0.1:1676" [yashan@lhryashandb install]$ [yashan@lhryashandb install]$ ./bin/yasboot package install -t /yashandb/install/hosts.toml -i yashandb-personal-23.1.0.100-linux-x86_64.tar.gz checking install profile.toml... install version: yashandb 23.1.1.100 update host to yasom... [yashan@lhryashandb install]$ ./bin/yasboot cluster deploy -t  /yashandb/install/yashandb.toml type | uuid             | name               | hostid | index    | status  | return_code | progress | cost ------------------------------------------------------------------------------------------------------------ task | 95d5d822b67ec478 | DeployYasdbCluster | -      | yashandb | SUCCESS | 0           | 100      | 9     ------+------------------+--------------------+--------+----------+---------+-------------+----------+------ task completed, status: SUCCESS [yashan@lhryashandb install]$ [yashan@lhryashandb conf]$ cat yashandb.bashrc export YASDB_HOME=/yashandb/install export PATH=${YASDB_HOME}/bin:$PATH export LD_LIBRARY_PATH=${YASDB_HOME}/lib:$LD_LIBRARY_PATH if command -v rlwrap >/dev/null 2>&1; then   alias yasql="rlwrap yasql" fi   export YASDB_DATA=/yashandb/data/db-1-1 [yashan@lhryashandb conf]$ cd /yashandb/install/conf [yashan@lhryashandb conf]$ cat yashandb.bashrc >> ~/.bashrc [yashan@lhryashandb conf]$ source ~/.bashrc [yashan@lhryashandb conf]$ [yashan@lhryashandb instance]$ yaspwd file=yasdb.pwd password=lhra@123 [yashan@lhryashandb instance]$  yasboot cluster status -c yashandb host_id  | node_type | nodeid | pid   -------------------------------------- host0001 | db        | 1-1:1  | 1085 ----------+-----------+--------+------ [yashan@lhryashandb instance]$ yasql 'sys/"lhra@123"' YashanDB SQL Personal Edition Release 23.1.1.100 x86_64   Connected to: YashanDB Server Personal Edition Release 23.1.1.100 x86_64 - X86 64bit Linux   SQL> SQL> select * from v$version;   BANNER                                                           VERSION_NUMBER     ---------------------------------------------------------------- ----------------- Personal Edition Release 23.1.1.100 x86_64                       23.1.1.100         1 row fetched.   SQL>

环境变量

使用临时配置方法配置环境变量不会生成环境变量信息，如下为使用永久生效方法配置的环境变量信息：

export YASDB_HOME=/home/yashan/yasdb_home/yashandb/23.1.0.100 export PATH=${YASDB_HOME}/bin:$PATH export LD_LIBRARY_PATH=${YASDB_HOME}/lib:$LD_LIBRARY_PATH if command -v rlwrap >/dev/null 2>&1; then alias yasql="rlwrap yasql" fi export YASDB_DATA=/home/yashan/yasdb_data/db-1-1

1 2 3 4 5 6 7 8

export YASDB_HOME=/home/yashan/yasdb_home/yashandb/23.1.0.100 export PATH=${YASDB_HOME}/bin:$PATH export LD_LIBRARY_PATH=${YASDB_HOME}/lib:$LD_LIBRARY_PATH if command -v rlwrap >/dev/null 2>&1; then   alias yasql="rlwrap yasql" fi   export YASDB_DATA=/home/yashan/yasdb_data/db-1-1

YASDB_HOME

YASDB_HOME环境变量所指向路径为YashanDB的HOME目录，包含产品相关程序文件。

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！

后续精彩内容已被小麦苗无情隐藏，请输入验证码解锁本站所有文章！

验证码：

请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

相关文章

• 在Docker中快速体验崖山YashanDB数据库
• 崖山YashanDB简介
• 崖山YashanDB数据库巡检脚本
• 小麦苗数据库巡检脚本，支持Oracle、MySQL、SQL Server、PG等21种数据库
• GreenPlum 6.26.1和gpcc 6.10单机版安装
• GreenPlum 7 单机安装
• YMatrix数据库单机安装
• 在docker中模拟不同主机快速搭建GBase 8cV5集群环境
• 在openEuler 22.03上分别使用yum和编译安装PostgreSQL环境
• GreenPlum 6 单机安装
• MPP架构之Greenplum的安装配置高级版（企业配置）
• GreenPlum官方监控工具GPCC的安装和卸载
• MySQL安装与卸载（持续更新）
• 神舟通用数据库巡检脚本
• 在Docker中分分钟拥有达梦数据库
• 【DB宝76】在Docker中只需2步即可拥有Oracle 21c环境
• 【DB宝14】在Docker中只需2步即可拥有Oracle 11g企业版环境（11.2.0.4）
• 【DB宝13】在Docker中只需2步即可拥有Oracle 12cR1(12.1.0.2)企业版环境
• 【连续视频】CentOS 7.3 ECS上搭建RAC 18c+单实例DG+EMCC+DG的FSFO快速故障转移配置
• 【视频】小麦苗高可用课程第5节-grid和db的静默安装

打赏赞(1)分享

标签： 原创安装部署国产数据库YashanDB崖山数据库

小麦苗

学习或考证，均可联系麦老师，请加微信db_bao或QQ646634621

• 下一篇 在Docker中快速体验崖山YashanDB数据库
• 上一篇 崖山YashanDB简介

您可能还喜欢...

• 0

  Windows使用cmd杀会话、杀进程、程序、注销用户、重启、限制CPU和内存等

  2023年5月8日

   由 小麦苗 · Published 2023年5月8日 · Last modified 2024年1月24日

  · 已更新 2024年1月24日  

  0    59    2
• 0

  MySQL登陆报错 ERROR 1040 (HY000) Too many connections 超过最大连接数错误

  2024年3月26日

   由 小麦苗 · Published 2024年3月26日

   

  0    54    1
• 0

  Oracle 10g和11g查询表空间大小（数据库大小）

  2021年6月23日

   由 小麦苗 · Published 2021年6月23日 · Last modified 2023年12月11日

  · 已更新 2023年12月11日  

  0    3440    10