开头还是介绍一下群，如果感兴趣PolarDB ,MongoDB ,MySQL ,PostgreSQL ,Redis, OceanBase, Sql Server等有问题，有需求都可以加群群内有各大数据库行业大咖，可以解决你的问题。加群请联系 liuaustin3 ，（共2500人左右 1 + 2 + 3 + 4 +5 + 6 + 7）(1 2 3 4 5 群均已爆满，6群停止进人470人，新人进7群，8群 ，欢迎OceanBase的老师入群，一起加速学习我们Oceanbase的进程。
-rw-------. 1 root root 2.8K May 2 19:28 anaconda-ks.cfg
-rw-------. 1 root root 8 May 2 19:59 .bash_history
-rw-r--r--. 1 root root 18 Dec 28 2013 .bash_logout
-rw-r--r--. 1 root root 176 Dec 28 2013 .bash_profile
-rw-r--r--. 1 root root 176 Dec 28 2013 .bashrc
drwx------. 3 root root 18 May 2 19:59 .cache
drwxr-xr-x. 3 root root 18 May 2 19:59 .config
-rw-r--r--. 1 root root 100 Dec 28 2013 .cshrc
drwxr-xr-x. 6 root root 88 Mar 28 20:46 oceanbase-all-in-one
-rw-r--r--. 1 root root 661M Apr 23 00:09 oceanbase-all-in-one-4.3.0.1-100000242024032211.el7.x86_64.tar.gz
-rw-------. 1 root root 2.1K May 2 19:28 original-ks.cfg
-rw-r--r--. 1 root root 129 Dec 28 2013 .tcshrc
-rw-------. 1 root root 67 May 2 19:59 .Xauthority
[root@localhost oceanbase-all-in-one]# ll -ah
total 16K
drwxr-xr-x. 6 root root 88 Mar 28 20:46 .
dr-xr-x---. 5 root root 4.0K May 2 20:51 ..
drwxr-xr-x. 2 root root 58 Mar 28 20:45 bin
drwxr-xr-x. 3 root root 17 Mar 28 20:46 obclient
drwxr-xr-x. 4 root root 28 Mar 28 20:45 obd
-rw-r--r--. 1 root root 666 Mar 28 20:45 README.md
drwxr-xr-x. 2 root root 4.0K Mar 28 20:46 rpms
-rw-r--r--. 1 root root 27 Mar 28 20:45 VERSION
[root@localhost oceanbase-all-in-one]# cd bin
[root@localhost bin]# ls
env.sh install.sh uninstall.sh
[root@localhost bin]# ll -ah
total 12K
drwxr-xr-x. 2 root root 58 Mar 28 20:45 .
drwxr-xr-x. 6 root root 88 Mar 28 20:46 ..
-rw-r--r--. 1 root root 238 Mar 28 20:45 env.sh
-rwxr-xr-x. 1 root root 2.2K Mar 28 20:45 install.sh
-rwxr-xr-x. 1 root root 235 Mar 28 20:45 uninstall.sh
If you want to view detailed obd logs, please run: obd display-trace 7759d5fa-0900-11ef-a1f1-000c292fc016
Disable remote ok
Trace ID: 78f964ac-0900-11ef-9761-000c292fc016
If you want to view detailed obd logs, please run: obd display-trace 78f964ac-0900-11ef-9761-000c292fc016
add auto set env logic to profile: /root/.bash_profile
#########################################################################################
Install Finished
=========================================================================================
Setup Environment: source ~/.oceanbase-all-in-one/bin/env.sh
Quick Start: obd demo
Use Web Service to install: obd web
Use Web Service to upgrade: obd web upgrade
More Details: obd -h
=========================================================================================
[root@localhost bin]#
这里有OB 提示比如open files ，hard nproc 等部分的系统参数需要调整，并给出了命令
`echo -e "* soft nproc 120000\n* hard nproc 120000" >> /etc/security/limits.d/nproc.confecho -e "* soft nofile 20000\n* hard nofile 20000" >> /etc/security/limits.d/nofile.confLoad cluster param plugin ok
Open ssh connection ok
Check before start observer x
[ERROR] OBD-1007: (127.0.0.1) The value of the ulimit parameter "open files" must not be less than 20000 (Current value: 1024), Please execute `echo -e "* soft nofile 20000\n* hard nofile 20000" >> /etc/security/limits.d/nofile.conf` as root in 127.0.0.1. if it dosen't work, please check whether UsePAM is yes in /etc/ssh/sshd_config.
[ERROR] OBD-1007: (127.0.0.1) The value of the ulimit parameter "max user processes" must not be less than 120000 (Current value: 63344), Please execute `echo -e "* soft nproc 120000\n* hard nproc 120000" >> /etc/security/limits.d/nproc.conf` as root in 127.0.0.1. if it dosen't work, please check whether UsePAM is yes in /etc/ssh/sshd_config.
[WARN] OBD-1007: (127.0.0.1) The recommended number of core file size is unlimited (Current value: 0)
[WARN] OBD-1007: (127.0.0.1) The recommended number of stack size is unlimited (Current value: 8192)
[WARN] OBD-1017: (127.0.0.1) The value of the "vm.max_map_count" must be within [327600, 1310720] (Current value: 65530, Recommended value: 655360)
[WARN] OBD-1017: (127.0.0.1) The value of the "fs.file-max" must be greater than 6573688 (Current value: 1552260, Recommended value: 6573688)
[WARN] OBD-1012: (127.0.0.1) clog and data use the same disk (/)
Check before start obagent ok
Check before start obproxy ok
Check before start prometheus ok
Check before start grafana ok
See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: 4a36d9aa-0901-11ef-9d9a-000c292fc016
If you want to view detailed obd logs, please run: obd display-trace 4a36d9aa-0901-11ef-9d9a-000c292fc016
[root@localhost bin]# reboot
Check before start obagent ok
Check before start prometheus ok
Check before start obproxy ok
Check before start grafana ok
Start observer ok
observer program health check ok
Connect to observer 127.0.0.1:2881 ok
Initialize oceanbase-ce ok
Start obagent ok
obagent program health check ok
Connect to Obagent ok
Start promethues ok
prometheus program health check ok
Connect to Prometheus ok
Initialize prometheus ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
Start grafana ok
grafana program health check ok
Connect to grafana ok
Initialize grafana ok
Wait for observer init ok
+---------------------------------------------+
| observer |
+-----------+---------+------+-------+--------+
| ip | version | port | zone | status |
+-----------+---------+------+-------+--------+
| 127.0.0.1 | 4.3.0.1 | 2881 | zone1 | ACTIVE |
+-----------+---------+------+-------+--------+
obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A
+--------------------------------------------------------------+
| obagent |
+-----------+--------------------+--------------------+--------+
| ip | mgragent_http_port | monagent_http_port | status |
+-----------+--------------------+--------------------+--------+
| 127.0.0.1 | 8089 | 8088 | active |
+-----------+--------------------+--------------------+--------+
+--------------------------------------------------+
| prometheus |
+-----------------------+------+----------+--------+
| url | user | password | status |
+-----------------------+------+----------+--------+
| http://127.0.0.1:9090 | | | active |
+-----------------------+------+----------+--------+
+---------------------------------------------+
| obproxy |
+-----------+------+-----------------+--------+
| ip | port | prometheus_port | status |
+-----------+------+-----------------+--------+
| 127.0.0.1 | 2883 | 2884 | active |
+-----------+------+-----------------+--------+
obclient -h127.0.0.1 -P2883 -uroot -Doceanbase -A
+-----------------------------------------------------------------+
| grafana |
+-----------------------------------+-------+------------+--------+
| url | user | password | status |
+-----------------------------------+-------+------------+--------+
| http://127.0.0.1:3000/d/oceanbase | admin | JuqNCmkiR2 | active |
+-----------------------------------+-------+------------+--------+
demo running
Trace ID: 8b053b50-0908-11ef-a1a4-000c292fc016
If you want to view detailed obd logs, please run: obd display-trace 8b053b50-0908-11ef-a1a4-000c292fc016
[root@localhost ~]# obclient -h127.0.0.1 -P2883 -uroot -Doceanbase -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 292552706
Server version: OceanBase_CE 4.3.0.1 (r100000242024032211-0193a343bc60b4699ec47792c3fc4ce166a182f9) (Built Mar 22 2024 13:19:48)
Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [oceanbase]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ocs |
| ORAAUDITOR |
| SYS |
| test |
+--------------------+
8 rows in set (0.006 sec)
obclient [oceanbase]>
置顶文章：
往期热门文章：
阿里云数据库--市场营销聊胜于无--3年的使用感受与反馈系列
阿里云数据库产品 对内对外一样的卷 --3年阿里云数据库的使用感受与反馈系列
阿里云数据库使用感受--客户服务问题深入剖析与什么是廉价客户 --3年的使用感受与反馈系列
阿里云数据库使用感受--操作界面有点眼花缭乱 --3年的使用感受与反馈系列
PolarDB 最近遇到加字段加不上的问题 与 使用PolarDB 三年感受与恳谈
PostgreSQL 稳定性平台 PG中文社区大会--杭州来去匆匆
MySQL 的SQL引擎很差吗？由一个同学提出问题引出的实验
临时工访谈：从国产数据库 到 普罗大众的产品 ！与在美国创业软件公司老板对话
感谢 老虎刘 刘老师 对 5月20日 SQL 问题纠正贴 ---PostgreSQL 同一种SQL为什么这样写会提升45%性能
PostgreSQL 同一种SQL为什么这样写会提升45%性能 --程序员和DBA思维方式不同决定
PostgreSQL 熊灿灿一句话够学半个月 之 KILL -9
临时工访谈：庙小妖风大-PolarDB 组团镇妖 之 他们是第一 （阿里云组团PK笔者实录）
临时工访谈：金牌 “女” 销售从ORACLE 转到另类国产数据库 到底 为什么？
临时工访谈：无名氏意外到访-- 也祝你好运（管理者PUA DBA现场直播）
