内部管理系统，前端vue,后端服务C#,数据库mysql8.0.37 社区版，根据信创要求：我想迁移数据库到oceanbase，但并不想用oceanbase分布式、集群等功能，只想替代mysql单机，因为如果用了oceanbase分布式、集群等配置非常吃机器的cup和内存，我现在用的mysql就不需要，下载了OceanBase All in One V4.5.0 X86-el7，单机部署时失败，问了多个ai，说是统信UOS 是 Debian 为技术基础，不支持rpm，那么问题来了 ：
1、统信UOS V20(1070) 到底应该下载哪个版本，能提供网址吗？
2、我只想替代mysql单机无需分布和集群等浪费资源，怎么部署生产环境？
帮顶
1 个赞
部署失败麻烦提供一下obd报错日志。
2.部署个单节点ob即可
我把我的整个操作步骤要点，第2部就 一直找不到：No such package name: oceanbase-ce，查了各种ai，说统信UOS 不支持rpm的，让rpm2cpio把文件提取出来，不通过系统包管理器安装，最后手工创建 OceanBase 4.5.0 单机启动脚本，倒是成功，但明细这种方式不好啊。我觉得应该还是说统信UOS 不支持rpm的 仅支持deb的问题吧？请执教，我敢安装那个版本，如能提供具体方法感谢！
1、Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ sudo ./install.sh
2、Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ obd cluster deploy mini-local -c mini-local.yaml
[ERROR] No such package name: oceanbase-ce. Trace ID: 817ee64e-064f-11f1-bb8f-be5388320f61
If you want to view detailed obd logs, please run: obd display-trace 817ee64e-064f-11f1-bb8f-be5388320f61
======以下是在统信的具体操作===============
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ ls /home/Plin/Downloads/oceanbase-all-in-one/rpms | grep oceanbase-ce-4
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ sudo ./install.sh
请输入密码:
验证成功
install obd as root
No previous obd installed, try install…, wait a moment
rpm: RPM should not be used directly install RPM packages, use Alien instead!
rpm: However assuming you know what you are doing…
/var/tmp/rpm-tmp.ks4fbG: 9: /var/tmp/rpm-tmp.ks4fbG: Syntax error: “(” unexpected (expecting “)”)
warning: %post(ob-deploy-4.2.0-1.el7.x86_64) scriptlet failed, exit status 2
name: alertmanager
version: 0.28.1
release:32025073111.el7
arch: x86_64
md5: c5fe05fcc8263b83f6d0602a871d7e1a7a79bdb8
size: 69543154
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/alertmanager-0.28.1-32025073111.el7.x86_64.rpm to local mirror
name: grafana
version: 7.5.17
release:1
arch: x86_64
md5: 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6
size: 177766248
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/grafana-7.5.17-1.el7.x86_64.rpm to local mirror
name: obagent
version: 4.2.4
release:200000022025090416.el7
arch: x86_64
md5: bae1154d745991c109af6cb5b151fb2831594df4
size: 72947757
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/obagent-4.2.4-200000022025090416.el7.x86_64.rpm to local mirror
name: ob-configserver
version: 1.0.0
release:2.el7
arch: x86_64
md5: feca6b9c76e26ac49464f34bfa0780b5a8d3f4a0
size: 24259515
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/ob-configserver-1.0.0-2.el7.x86_64.rpm to local mirror
name: ob-deploy
version: 4.2.0
release:1.el7
arch: x86_64
md5: 63936b09a892a27df843fe7337ca5143a72c7a5c
size: 213908897
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/ob-deploy-4.2.0-1.el7.x86_64.rpm to local mirror
name: obproxy-ce
version: 4.3.5.0
release:3.el7
arch: x86_64
md5: f17b277b681adb1c86bfc3cfda369ad88896da9d
size: 123559862
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/obproxy-ce-4.3.5.0-3.el7.x86_64.rpm to local mirror
name: ob-sysbench
version: 1.0.20
release:21.el7
arch: x86_64
md5: 34eb6ecba0ebc4c31c4cfa01162045cbbbec55f7
size: 1566511
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/ob-sysbench-1.0.20-21.el7.x86_64.rpm to local mirror
name: obtpcc
version: 5.0.0
release:1.el7
arch: x86_64
md5: 8624590be4bfe16f28bdd9fc5e4849cda19577d6
size: 1890344
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/obtpcc-5.0.0-1.el7.x86_64.rpm to local mirror
name: obtpch
version: 3.0.0
release:1.el7
arch: x86_64
md5: 3e3e88f87527677998fedf25087f5c87779dee62
size: 1856985
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/obtpch-3.0.0-1.el7.x86_64.rpm to local mirror
name: oceanbase-ce
version: 4.2.1.8
release:108000022024072217.el7
arch: x86_64
md5: 499b676f2ede5a16e0c07b2b15991d1160d972e8
size: 457041540
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/oceanbase-ce-4.2.1.8-108000022024072217.el7.x86_64.rpm to local mirror
name: oceanbase-ce
version: 4.5.0.0
release:100000012025112711.el7
arch: x86_64
md5: ea2a91329c00190d20c01dd73da81b2f081abd4e
size: 1001699475
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/oceanbase-ce-4.5.0.0-100000012025112711.el7.x86_64.rpm to local mirror
name: oceanbase-ce-libs
version: 4.2.1.8
release:108000022024072217.el7
arch: x86_64
md5: d02f4bfd321370a02550424293beb1be31204038
size: 468528
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/oceanbase-ce-libs-4.2.1.8-108000022024072217.el7.x86_64.rpm to local mirror
name: oceanbase-ce-libs
version: 4.5.0.0
release:100000012025112711.el7
arch: x86_64
md5: d3819a346ae9437422d248563ee7e88cfd1dfacc
size: 7848
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/oceanbase-ce-libs-4.5.0.0-100000012025112711.el7.x86_64.rpm to local mirror
name: oceanbase-ce-utils
version: 4.2.1.8
release:108000022024072217.el7
arch: x86_64
md5: 6f87392f95b399a21382323f256cfda5969375c4
size: 403350984
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/oceanbase-ce-utils-4.2.1.8-108000022024072217.el7.x86_64.rpm to local mirror
name: oceanbase-ce-utils
version: 4.5.0.0
release:100000012025112711.el7
arch: x86_64
md5: eb2f66c9fe4becee1400a6472a6e53e7bd5d8227
size: 1735471904
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/oceanbase-ce-utils-4.5.0.0-100000012025112711.el7.x86_64.rpm to local mirror
name: oceanbase-diagnostic-tool
version: 3.7.1
release:12025102215.el7
arch: x86_64
md5: d52e8fa03d97b755b6bc3bf6515d0b2f51c4a927
size: 71887826
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/oceanbase-diagnostic-tool-3.7.1-12025102215.el7.x86_64.rpm to local mirror
name: ocp-agent-ce
version: 4.4.0
release:20251114143405.el7
arch: aarch64
md5: 6c619c8406abb57771d26e29ea7b0f58d5fed3de
size: 134228546
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/ocp-agent-ce-4.4.0-20251114143405.el7.aarch64.rpm to local mirror
name: ocp-agent-ce
version: 4.4.0
release:20251114143405.el7
arch: x86_64
md5: f8dd0ebfaa2c2f413fb3eafb922cfabde114d32f
size: 190676800
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/ocp-agent-ce-4.4.0-20251114143405.el7.x86_64.rpm to local mirror
name: ocp-server-ce
version: 4.4.0
release:20251114143405.el7
arch: noarch
md5: f673d693677a2c640f925ad2127a604aaebf00bf
size: 491684490
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/ocp-server-ce-4.4.0-20251114143405.el7.noarch.rpm to local mirror
name: openjdk-jre
version: 17.0.16_8
release:92025080421.el7
arch: x86_64
md5: ceb2cc6abb2016acb9d13681e5d8c76bab7ddd56
size: 140342516
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/openjdk-jre-17.0.16_8-92025080421.el7.x86_64.rpm to local mirror
name: prometheus
version: 2.37.1
release:10000102022110211.el7
arch: x86_64
md5: 58913c7606f05feb01bc1c6410346e5fc31cf263
size: 211224073
add /home/Plin/Downloads/oceanbase-all-in-one/rpms/prometheus-2.37.1-10000102022110211.el7.x86_64.rpm to local mirror
Trace ID: 992c4214-064a-11f1-bb2d-be5388320f61
If you want to view detailed obd logs, please run: obd display-trace 992c4214-064a-11f1-bb2d-be5388320f61
Disable remote ok
Trace ID: da7dfe06-064a-11f1-9d71-be5388320f61
If you want to view detailed obd logs, please run: obd display-trace da7dfe06-064a-11f1-9d71-be5388320f61
add auto set env logic to profile: /root/.bashrc
#########################################################################################
Install Finished
Setup Environment: source ~/.oceanbase-all-in-one/bin/env.sh
Quick Start: obd demo
Quick Start (performance): obd perf
Interactive install: obd cluster deploy -i
Use Web Service to install: obd web
Use Web Service to upgrade: obd web upgrade
More Details: obd -h
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ source ./env.sh
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ source /home/Plin/Downloads/oceanbase-all-in-one/obd/etc/profile.d/obd.sh
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ cp /home/Plin/Downloads/oceanbase-all-in-one/obd/usr/obd/example/mini-local-example.yaml ./mini-local.yaml
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ obd cluster deploy mini-local -c mini-local.yaml
[ERROR] No such package name: oceanbase-ce.
Trace ID: 817ee64e-064f-11f1-bb8f-be5388320f61
If you want to view detailed obd logs, please run: obd display-trace 817ee64e-064f-11f1-bb8f-be5388320f61
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ ls /home/Plin/Downloads/oceanbase-all-in-one/rpms | grep oceanbase-ce-4
oceanbase-ce-4.2.1.8-108000022024072217.el7.x86_64.rpm
oceanbase-ce-4.5.0.0-100000012025112711.el7.x86_64.rpm
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ obd cluster deploy mini-local -c mini-local.yaml
[ERROR] No such package name: oceanbase-ce.
Trace ID: 96d051c6-0650-11f1-afee-be5388320f61
If you want to view detailed obd logs, please run: obd display-trace 96d051c6-0650-11f1-afee-be5388320f61
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ find ~/Downloads/oceanbase-all-in-one -name “oceanbase-ce-4.5.0.0-100000012025112711.el7.x86_64.rpm”
/home/Plin/Downloads/oceanbase-all-in-one/rpms/oceanbase-ce-4.5.0.0-100000012025112711.el7.x86_64.rpm
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ obd cluster deploy mini-local -c mini-local.yaml
[ERROR] No such package name: oceanbase-ce.
Trace ID: 1ac1b4e8-0651-11f1-9bd4-be5388320f61
If you want to view detailed obd logs, please run: obd display-trace 1ac1b4e8-0651-11f1-9bd4-be5388320f61
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ obd --version
OceanBase Deploy: 4.2.0
REVISION: 45ef3f40de9a31b747bf280b44385983bed8f039
BUILD_BRANCH: HEAD
BUILD_TIME: Jan 30 2026 15:47:16OURCE
Copyright (C) 2025 OceanBase
License Apache 2.0: Apache version 2 or later https://www.apache.org/licenses/LICENSE-2.0.
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ mkdir -p /home/Plin/ob-ce-4.5.0
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ rpm2cpio /home/Plin/Downloads/oceanbase-all-in-one/rpms/oceanbase-ce-4.5.0.0-100000012025112711.el7.x86_64.rpm | cpio -idmv -D /home/Plin/ob-ce-4.5.0
./home/admin/oceanbase/admin
./home/admin/oceanbase/admin/__dbms_upgrade_body_mysql.sql
./home/admin/oceanbase/admin/__dbms_upgrade_mysql.sql
./home/admin/oceanbase/admin/dbms_ai_service_body_mysql.sql
./home/admin/oceanbase/admin/dbms_ai_service_mysql.sql
./home/admin/oceanbase/admin/dbms_application_body_mysql.sql
./home/admin/oceanbase/admin/dbms_application_mysql.sql
./home/admin/oceanbase/admin/dbms_balance_body_mysql.sql
./home/admin/oceanbase/admin/dbms_balance_mysql.sql
./home/admin/oceanbase/admin/dbms_data_dict_body_mysql.sql
./home/admin/oceanbase/admin/dbms_data_dict_mysql.sql
./home/admin/oceanbase/admin/dbms_external_table_body_mysql.sql
./home/admin/oceanbase/admin/dbms_external_table_mysql.sql
./home/admin/oceanbase/admin/dbms_hybrid_vector_body_mysql.sql
./home/admin/oceanbase/admin/dbms_hybrid_vector_mysql.sql
./home/admin/oceanbase/admin/dbms_ischeduler_mysql.sql
./home/admin/oceanbase/admin/dbms_ischeduler_mysql_body.sql
./home/admin/oceanbase/admin/dbms_java_body_mysql.sql
./home/admin/oceanbase/admin/dbms_java_mysql.sql
./home/admin/oceanbase/admin/dbms_monitor_body_mysql.sql
./home/admin/oceanbase/admin/dbms_monitor_mysql.sql
./home/admin/oceanbase/admin/dbms_mview_body_mysql.sql
./home/admin/oceanbase/admin/dbms_mview_mysql.sql
./home/admin/oceanbase/admin/dbms_mview_stats_body_mysql.sql
./home/admin/oceanbase/admin/dbms_mview_stats_mysql.sql
./home/admin/oceanbase/admin/dbms_ob_limit_calculator_body_mysql.sql
./home/admin/oceanbase/admin/dbms_ob_limit_calculator_mysql.sql
./home/admin/oceanbase/admin/dbms_partition_body_mysql.sql
./home/admin/oceanbase/admin/dbms_partition_mysql.sql
./home/admin/oceanbase/admin/dbms_python_body_mysql.sql
./home/admin/oceanbase/admin/dbms_python_mysql.sql
./home/admin/oceanbase/admin/dbms_resource_manager_body_mysql.sql
./home/admin/oceanbase/admin/dbms_resource_manager_mysql.sql
./home/admin/oceanbase/admin/dbms_scheduler_mysql.sql
./home/admin/oceanbase/admin/dbms_scheduler_mysql_body.sql
./home/admin/oceanbase/admin/dbms_session_body_mysql.sql
./home/admin/oceanbase/admin/dbms_session_mysql.sql
./home/admin/oceanbase/admin/dbms_space_body_mysql.sql
./home/admin/oceanbase/admin/dbms_space_mysql.sql
./home/admin/oceanbase/admin/dbms_stats_body_mysql.sql
./home/admin/oceanbase/admin/dbms_stats_mysql.sql
./home/admin/oceanbase/admin/dbms_trusted_certificate_manager_body_mysql.sql
./home/admin/oceanbase/admin/dbms_trusted_certificate_manager_mysql.sql
./home/admin/oceanbase/admin/dbms_udr_body_mysql.sql
./home/admin/oceanbase/admin/dbms_udr_mysql.sql
./home/admin/oceanbase/admin/dbms_vector_body_mysql.sql
./home/admin/oceanbase/admin/dbms_vector_mysql.sql
./home/admin/oceanbase/admin/dbms_workload_repository_body_mysql.sql
./home/admin/oceanbase/admin/dbms_workload_repository_mysql.sql
./home/admin/oceanbase/admin/dbms_xplan_mysql.sql
./home/admin/oceanbase/admin/dbms_xplan_mysql_body.sql
./home/admin/oceanbase/admin/dbms_xprofile_mysql.sql
./home/admin/oceanbase/admin/dbms_xprofile_mysql_body.sql
./home/admin/oceanbase/admin/external_table_alert_log.sql
./home/admin/oceanbase/bin
./home/admin/oceanbase/bin/import_srs_data.py
./home/admin/oceanbase/bin/import_time_zone_info.py
./home/admin/oceanbase/bin/observer
./home/admin/oceanbase/bin/obshell
./home/admin/oceanbase/etc
./home/admin/oceanbase/etc/default_parameter.json
./home/admin/oceanbase/etc/default_srs_data_mysql.sql
./home/admin/oceanbase/etc/default_system_variable.json
./home/admin/oceanbase/etc/deps_compat.yml
./home/admin/oceanbase/etc/fill_help_tables-ob.sql
./home/admin/oceanbase/etc/ob_all_available_parameters.json
./home/admin/oceanbase/etc/ob_system_variable_init.json
./home/admin/oceanbase/etc/oceanbase_upgrade_dep.yml
./home/admin/oceanbase/etc/spatial_reference_systems.data
./home/admin/oceanbase/etc/timezone.data
./home/admin/oceanbase/etc/timezone_V1.log
./home/admin/oceanbase/etc/timezone_name.data
./home/admin/oceanbase/etc/timezone_trans.data
./home/admin/oceanbase/etc/timezone_trans_type.data
./home/admin/oceanbase/etc/upgrade_checker.py
./home/admin/oceanbase/etc/upgrade_health_checker.py
./home/admin/oceanbase/etc/upgrade_post.py
./home/admin/oceanbase/etc/upgrade_pre.py
./home/admin/oceanbase/profile
./home/admin/oceanbase/profile/oceanbase-pre.json
./home/admin/oceanbase/profile/oceanbase-service.sh
./home/admin/oceanbase/profile/oceanbase.cnf
./home/admin/oceanbase/profile/oceanbase.service
./home/admin/oceanbase/profile/post_install.sh
./home/admin/oceanbase/profile/post_uninstall.sh
./home/admin/oceanbase/profile/pre_install.sh
./home/admin/oceanbase/profile/pre_uninstall.sh
./home/admin/oceanbase/profile/telemetry-pre.json
./home/admin/oceanbase/profile/telemetry.sh
./home/admin/oceanbase/software_package
1956474 块
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ chmod 755 /home/Plin/observer
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ obd cluster deploy mini-local -c mini-local.yaml
[ERROR] No such package name: oceanbase-ce.
Trace ID: 6a93ca00-0657-11f1-9c79-be5388320f61
If you want to view detailed obd logs, please run: obd display-trace 6a93ca00-0657-11f1-9c79-be5388320f61
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ chown -R Plin:Plin /home/Plin/observer
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ chmod -R 755 /home/Plin/observer
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ chmod +x /home/Plin/ob-ce-4.5.0/home/admin/oceanbase/bin/observer
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ /home/Plin/Downloads/oceanbase-all-in-one/obd/usr/bin/obd cluster deploy mini-local -c mini-local.yaml
[ERROR] No such package name: oceanbase-ce.
Trace ID: d1e2505c-065a-11f1-89f9-be5388320f61
If you want to view detailed obd logs, please run: obd display-trace d1e2505c-065a-11f1-89f9-be5388320f61
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ /home/Plin/Downloads/oceanbase-all-in-one/obd/usr/bin/obd mirror clone /home/Plin/ob-ce-4.5.0/home/admin/oceanbase oceanbase-ce 4.5.0
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ sudo apt install tree
请输入密码:
验证成功
正在读取软件包列表… 完成
正在分析软件包的依赖关系树
正在读取状态信息… 完成
下列软件包是自动安装的并且现在不需要了：
libqtermwidget5-0 libutf8proc2 live-system-com qtermwidget5-data x11-apps x11-session-utils xinit
使用’sudo apt autoremove’来卸载它(它们)。
下列【新】软件包将被安装：
tree
升级了 0 个软件包，新安装了 1 个软件包，要卸载 0 个软件包，有 304 个软件包未被升级。
需要下载 49.4 kB 的归档。
解压缩后会消耗 117 kB 的额外空间。
获取:1 https://professional-packages.chinauos.com/desktop-professional eagle/main amd64 tree amd64 1.8.0-1 [49.4 kB]
25% [1 tree 15.5 kB/49.4 kB 31%]94960ca40edc8d6c1904b91bb368cf20 /var/cache/apt/archives/partial/tree_1.8.0-1_amd64.deb
94960ca40edc8d6c1904b91bb368cf20 /var/cache/apt/archives/partial/tree_1.8.0-1_amd64.deb
已下载 49.4 kB，耗时 3秒 (14.7 kB/s)
正在选中未选择的软件包 tree。
(正在读取数据库 … 系统当前共安装有 216648 个文件和目录。)
准备解压 …/tree_1.8.0-1_amd64.deb …
正在解压 tree (1.8.0-1) …
/var/cache/apt/archives/tree_1.8.0-1_amd64.deb
正在设置 tree (1.8.0-1) …
正在处理用于 man-db (2.8.5.3-deepin1) 的触发器 …
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ tree -L 5 /home/Plin/ob-ce-4.5.0
/home/Plin/ob-ce-4.5.0
└── home
└── admin
└── oceanbase
├── admin
│ ├── dbms_ai_service_body_mysql.sql
│ ├── dbms_ai_service_mysql.sql
│ ├── dbms_application_body_mysql.sql
│ ├── dbms_application_mysql.sql
│ ├── dbms_balance_body_mysql.sql
│ ├── dbms_balance_mysql.sql
│ ├── dbms_data_dict_body_mysql.sql
│ ├── dbms_data_dict_mysql.sql
│ ├── dbms_external_table_body_mysql.sql
│ ├── dbms_external_table_mysql.sql
│ ├── dbms_hybrid_vector_body_mysql.sql
│ ├── dbms_hybrid_vector_mysql.sql
│ ├── dbms_ischeduler_mysql_body.sql
│ ├── dbms_ischeduler_mysql.sql
│ ├── dbms_java_body_mysql.sql
│ ├── dbms_java_mysql.sql
│ ├── dbms_monitor_body_mysql.sql
│ ├── dbms_monitor_mysql.sql
│ ├── dbms_mview_body_mysql.sql
│ ├── dbms_mview_mysql.sql
│ ├── dbms_mview_stats_body_mysql.sql
│ ├── dbms_mview_stats_mysql.sql
│ ├── dbms_ob_limit_calculator_body_mysql.sql
│ ├── dbms_ob_limit_calculator_mysql.sql
│ ├── dbms_partition_body_mysql.sql
│ ├── dbms_partition_mysql.sql
│ ├── dbms_python_body_mysql.sql
│ ├── dbms_python_mysql.sql
│ ├── dbms_resource_manager_body_mysql.sql
│ ├── dbms_resource_manager_mysql.sql
│ ├── dbms_scheduler_mysql_body.sql
│ ├── dbms_scheduler_mysql.sql
│ ├── dbms_session_body_mysql.sql
│ ├── dbms_session_mysql.sql
│ ├── dbms_space_body_mysql.sql
│ ├── dbms_space_mysql.sql
│ ├── dbms_stats_body_mysql.sql
│ ├── dbms_stats_mysql.sql
│ ├── dbms_trusted_certificate_manager_body_mysql.sql
│ ├── dbms_trusted_certificate_manager_mysql.sql
│ ├── dbms_udr_body_mysql.sql
│ ├── dbms_udr_mysql.sql
│ ├── __dbms_upgrade_body_mysql.sql
│ ├── __dbms_upgrade_mysql.sql
│ ├── dbms_vector_body_mysql.sql
│ ├── dbms_vector_mysql.sql
│ ├── dbms_workload_repository_body_mysql.sql
│ ├── dbms_workload_repository_mysql.sql
│ ├── dbms_xplan_mysql_body.sql
│ ├── dbms_xplan_mysql.sql
│ ├── dbms_xprofile_mysql_body.sql
│ ├── dbms_xprofile_mysql.sql
│ └── external_table_alert_log.sql
├── bin
│ ├── import_srs_data.py
│ ├── import_time_zone_info.py
│ ├── observer
│ └── obshell
├── etc
│ ├── default_parameter.json
│ ├── default_srs_data_mysql.sql
│ ├── default_system_variable.json
│ ├── deps_compat.yml
│ ├── fill_help_tables-ob.sql
│ ├── ob_all_available_parameters.json
│ ├── ob_system_variable_init.json
│ ├── oceanbase_upgrade_dep.yml
│ ├── spatial_reference_systems.data
│ ├── timezone.data
│ ├── timezone_name.data
│ ├── timezone_trans.data
│ ├── timezone_trans_type.data
│ ├── timezone_V1.log
│ ├── upgrade_checker.py
│ ├── upgrade_health_checker.py
│ ├── upgrade_post.py
│ └── upgrade_pre.py
├── profile
│ ├── oceanbase.cnf
│ ├── oceanbase-pre.json
│ ├── oceanbase.service
│ ├── oceanbase-service.sh
│ ├── post_install.sh
│ ├── post_uninstall.sh
│ ├── pre_install.sh
│ ├── pre_uninstall.sh
│ ├── telemetry-pre.json
│ └── telemetry.sh
└── software_package
7 directories, 86 files
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ ls -ld /home/Plin/ob-ce-4.5.0/home/admin/oceanbase
drwxr-xr-x 6 Plin Plin 4096 2月 10 15:32 /home/Plin/ob-ce-4.5.0/home/admin/oceanbase
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ ls -l $(find /home/Plin/ob-ce-4.5.0 -name “observer” -type f)
-rwxr-xr-x 1 Plin Plin 924940792 11月 27 12:39 /home/Plin/ob-ce-4.5.0/home/admin/oceanbase/bin/observer
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ mkdir -p ~/.obd/mirror/oceanbase-ce/4.5.0
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ cp -r /home/Plin/ob-ce-4.5.0/home/admin/oceanbase/* ~/.obd/mirror/oceanbase-ce/4.5.0/
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ ls ~/.obd/mirror/oceanbase-ce/4.5.0/bin/observer
/home/Plin/.obd/mirror/oceanbase-ce/4.5.0/bin/observer
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ /home/Plin/Downloads/oceanbase-all-in-one/obd/usr/bin/obd cluster deploy mini-local -c mini-local.yaml
[ERROR] No such package name: oceanbase-ce.
Trace ID: e2ca0c54-065d-11f1-b13a-be5388320f61
If you want to view detailed obd logs, please run: obd display-trace e2ca0c54-065d-11f1-b13a-be5388320f61
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ # 创建启动脚本文件
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ cat > /home/Plin/start_ob.sh << EOF
#!/bin/bash
OceanBase 4.5.0 单机启动脚本
1. 创建工作目录
mkdir -p /home/Plin/observer/{data,redo}
chmod -R 755 /home/Plin/observer2. 停止已有 observer 进程（避免端口占用）
ps -ef | grep observer | grep -v grep | awk ‘{print $2}’ | xargs kill -9 > /dev/null 2>&1
3. 启动 observer
cd /home/Plin/ob-ce-4.5.0/home/admin/oceanbase/bin
./observer
-o “home_path=/home/Plin/observer,data_dir=/home/Plin/observer/data,redo_dir=/home/Plin/observer/redo”
-o “mysql_port=2881,rpc_port=2882,local_ip=127.0.0.1”
-o “zone=zone1,cluster_id=1,server_id=1”
-o “memory_limit=4G,system_memory=1G,cpu_count=2”
-o “datafile_size=2G,log_disk_size=8G”
-o “production_mode=false,enable_syslog_wf=false”
-o “root_password=”4. 验证启动
echo “=== 启动状态检查 ===”
ps -ef | grep observer | grep -v grep
echo “=== 端口监听检查 ===”
netstat -tulpn | grep 2881
echo “=== 连接命令 ===”
echo “mysql -h 127.0.0.1 -P 2881 -uroot”
EOF
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ # 给脚本加执行权限
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ chmod +x /home/Plin/start_ob.sh
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/bin$ /home/Plin/start_ob.sh
[32071]OB_MALLOC COST TOO MUCH TIME, cost_time=277140, tenant_id=500, label=glibc_malloc, ctx_id=7, prio=0, size=45,
[32071]OB_MALLOC COST TOO MUCH TIME, cost_time=123671, tenant_id=500, label=glibc_malloc, ctx_id=7, prio=0, size=24,
[32071]OB_MALLOC COST TOO MUCH TIME, cost_time=126247, tenant_id=500, label=glibc_malloc, ctx_id=7, prio=0, size=1056,
./observer -o home_path=/home/Plin/observer,data_dir=/home/Plin/observer/data,redo_dir=/home/Plin/observer/redo -o mysql_port=2881,rpc_port=2882,local_ip=127.0.0.1 -o zone=zone1,cluster_id=1,server_id=1 -o memory_limit=4G,system_memory=1G,cpu_count=2 -o datafile_size=2G,log_disk_size=8G -o production_mode=false,enable_syslog_wf=false -o root_password=
optstr: home_path=/home/Plin/observer,data_dir=/home/Plin/observer/data,redo_dir=/home/Plin/observer/redo
optstr: mysql_port=2881,rpc_port=2882,local_ip=127.0.0.1
optstr: zone=zone1,cluster_id=1,server_id=1
optstr: memory_limit=4G,system_memory=1G,cpu_count=2
optstr: datafile_size=2G,log_disk_size=8G
optstr: production_mode=false,enable_syslog_wf=false
optstr: root_password=
=== 启动状态检查 ===
Plin 32147 1 0 16:57 ? 00:00:00 ./observer -o home_path=/home/Plin/observer,data_dir=/home/Plin/observer/data,redo_dir=/home/Plin/observer/redo -o mysql_port=2881,rpc_port=2882,local_ip=127.0.0.1 -o zone=zone1,cluster_id=1,server_id=1 -o memory_limit=4G,system_memory=1G,cpu_count=2 -o datafile_size=2G,log_disk_size=8G -o production_mode=false,enable_syslog_wf=false -o root_password=
=== 端口监听检查 ===
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
=== 连接命令 ===
mysql -h 127.0.0.1 -P 2881 -uroot
666666
obd mirror list看一下镜像中的包
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/obd/usr/bin$ obd mirror list
±------------------------------------------------------------+
| Mirror Repository List |
±------------±------±--------±---------±-----------------+
| SectionName | Type | Enabled | Avaiable | Update Time |
±------------±------±--------±---------±-----------------+
| local | local | - | True | 2026-02-11 12:47 |
±------------±------±--------±---------±-----------------+
Use obd mirror list <section name> for more details
Trace ID: c648d13a-0704-11f1-9c4d-31d887be3ba6
If you want to view detailed obd logs, please run: obd display-trace c648d13a-0704-11f1-9c4d-31d887be3ba6
Plin@Plin-PC:~/Downloads/oceanbase-all-in-one/obd/usr/bin$ obd mirror list local
local Package List is empty.
Trace ID: d430b812-0704-11f1-8809-0feb0dbf96de
If you want to view detailed obd logs, please run: obd display-trace d430b812-0704-11f1-8809-0feb0dbf96de
只能手动部署吗？对于小白手动部署有点难度
学习学习 