零基础OceanBase数据库入门：搭建你的第一个OceanBase数据库

[root@iZbp130a38f5akwzn8n97bZ ~]# useradd -U admin -d /home/admin -s /bin/bash
[root@iZbp130a38f5akwzn8n97bZ ~]# chown -R admin:admin /home/admin
[root@iZbp130a38f5akwzn8n97bZ ~]# 

[root@iZbp130a38f5akwzn8n97bZ ~]# mkdir -p /data/{1,log1}
[root@iZbp130a38f5akwzn8n97bZ ~]# chown -R admin:admin /data

[admin@iZbp130a38f5akwzn8n97bZ ~]$ ll -h 
total 729M
-rw-r--r-- 1 root root 729M Aug  8  2025 oceanbase-standalone-all-in-one-4.2.5_bp4_hf4_20250716.el7.x86_64.tar.gz
[admin@iZbp130a38f5akwzn8n97bZ ~]$ 

$ tar -zxvf oceanbase-standalone-all-in-one-4.2.5_bp4_hf4_20250716.el7.x86_64.tar.gz 

[admin@iZbp130a38f5akwzn8n97bZ ~]$ cd oceanbase-standalone-all-in-one
[admin@iZbp130a38f5akwzn8n97bZ oceanbase-standalone-all-in-one]$ sh bin/install_obd.sh 

Trace ID: 992e69b8-2b66-11f1-9af9-00163e61e744
If you want to view detailed obd logs, please run: obd display-trace 992e69b8-2b66-11f1-9af9-00163e61e744
Disable remote ok
Trace ID: 9a5d2306-2b66-11f1-8e45-00163e61e744
If you want to view detailed obd logs, please run: obd display-trace 9a5d2306-2b66-11f1-8e45-00163e61e744

add auto set env logic to profile: /home/admin/.bash_profile

Execute this command to apply the environment config：`source ~/.oceanbase-all-in-one/bin/env.sh`

[admin@iZbp130a38f5akwzn8n97bZ oceanbase-standalone-all-in-one]$ source ~/.oceanbase-all-in-one/bin/env.sh

 bin/install_ob.sh
Enter the IP (Default: 192.168.2.251): 
Enter the current user password: 
get system config ok
+-----------------------------------------------------------------+
|                   System Parameter Change List                  |
+---------------+------------------+---------------+--------------+
| ip            | need_change_var  | current_value | target_value |
+---------------+------------------+---------------+--------------+
| 192.168.2.251 | fs.aio-max-nr    | 65536         | 1048576      |
| 192.168.2.251 | vm.max_map_count | 65530         | 655360       |
| 192.168.2.251 | fs.file-max      | 777882        | 6573688      |
| 192.168.2.251 | nofile           | 65535         | 655350       |
+---------------+------------------+---------------+--------------+
Do you want to modify the parameters above? [y/n] [Default: y]: 

[admin@iZbp130a38f5akwzn8n97bZ oceanbase-standalone-all-in-one]$ obclient -h192.168.2.251 -P'2881' -p'123456' -uroot@test -Doceanbase -A
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221502964
Server version: OceanBase 4.2.5.4 (r104040052025071121-969b0573b5acaa8702a55910412894a7a33b7382) (Built Jul 11 2025 21:46:10)

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(root@test)[oceanbase]> show  databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| oceanbase          |
| test               |
+--------------------+
4 rows in set (0.003 sec)

obclient(root@test)[oceanbase]> 

$ ps -ef|grep observer
admin     8133     1 47 20:13 ?        00:02:23 /home/admin/myoceanbase/oceanbase_name/bin/observer -r 192.168.2.251:2882:2881 -p 2881 -P 2882 -z zone1 -n myoceanbase -c 1774786407 -d /data/1/myoceanbase -I 192.168.2.251 -o __min_full_resource_pool_memory=2147483648,cluster_name=myoceanbase,cpu_count=8,memory_limit=7G,datafile_size=2G,datafile_maxsize=139G,datafile_next=14G,log_disk_size=19G,system_memory=0M,large_query_threshold=600s,enable_record_trace_log=False,enable_syslog_recycle=1,max_syslog_file_count=300
admin     9601  1409  0 20:18 pts/0    00:00:00 grep --color=auto observer