OceanBase 4.2.1 離線安裝

4.2 版本的OceanBase支持一鍵安裝，所以在線版本的安裝簡單了很多，但在無法連接網絡的情況下安裝就只能手動離線安裝。

注：如下安裝過程都是在同一臺機器上面進行，也就是只有一個節點，多個節點安裝以此類推即可。

離線安裝步驟：
下載安裝包
建議使用最上面的OceanBase 數據庫一鍵離線安裝包，選擇適合的版本號下載，里面包含的內容比較全

下載安裝部署工具包
安裝部署工具OceanBase Deployer（簡稱OBD），官方解釋上面的All in One 包里已經包含這個包了，可以直接運行安裝。

進入下載目錄解壓，然后進入oceanbase-all-in-one/rpms
tar -zxvf ocp-all-in-one-4.2.1-20231208144448.el7.x86_64.tar.gz

安裝obd
yum install ob-deploy-2.4.0-7.el7.x86_64.rpm

然后執行如下命令，將安裝工具的安裝源改完本地
obd? mirror disable remote #禁用遠程倉庫
obd mirror clone *.rpm #設置本地倉庫
obd mirror list local #查看本地倉庫

啟動web部署工具，web界面操作起來更方便一些
#啟動OBD部署界面，可以使用obd web -h 查看可用參數
obd web -p 8000 #會輸出web界面的網址，如下：
[root@ocpsys ~]# obd web -p 8000
start OBD WEB in 0.0.0.0:8000
please open http://192.168.142.12:8000

注意：所有部署過程均為web圖形界面操作部署，具體過程OceanBase官方有詳細的操作步驟。

vi /etc/security/limits.d/20-nproc.conf
*?????? soft??? nproc?? 655350????????? #最大線程數
root???????soft??? nproc?? unlimited????????? #最大線程數

vi /etc/security/limits.conf在文件尾部添加
*?????? soft??? nofile? 655350
*?????? hard??? nofile? 655350
*?????? soft??? nproc? 655350
*?????? hard??? nproc? 655350
*?????? soft??? stack?? unlimited
*?????? hard??? stack?? unlimited
*?????? soft??? core??? unlimited
*?????? hard??? core??? unlimited

vi /etc/sysctl.conf在文件尾部添加
vm.max_map_count=655360
vm.min_free_kbytes=2097152
fs.file-max = 6573688
fs.aio-max-nr = 1048576

設置免密碼sudo
vi /etc/sudoers 在文件尾部添加
vi /etc/sudoers
admin?????? ALL=(ALL)?????? NOPASSWD: ALL

用戶名密碼記錄：192.168.142.12
root@sys/zzh!@#123QAZ

部署日志：
+---------------------------------------------------------------------------------------------+
|?????????????????????????????????????????? Packages????????????????????????????????????????? |
+---------------+---------+------------------------+------------------------------------------+
| Repository??? | Version | Release??????????????? | Md5????????????????????????????????????? |
+---------------+---------+------------------------+------------------------------------------+
| oceanbase-ce? | 4.2.1.2 | 102000042023120514.el7 | b2ccb524f200a9ef0fad2cddf59d309ddaa2e3e4 |
| obproxy-ce??? | 4.2.1.0 | 11.el7???????????????? | 0aed4b782120e4248b749f67be3d2cc82cdcb70d |
| ocp-server-ce | 4.2.1?? | 20231208144448.el7???? | 58cf72891d75a2fa7c754bafc42d336525baf0b5 |
+---------------+---------+------------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Generate ocp server configuration ok
Cluster status check ok
Initializes observer work home ok
Initializes obproxy work home ok
Initializes ocp-server work home ok
Remote oceanbase-ce-4.2.1.2-102000042023120514.el7-b2ccb524f200a9ef0fad2cddf59d309ddaa2e3e4 repository install ok
Remote oceanbase-ce-4.2.1.2-102000042023120514.el7-b2ccb524f200a9ef0fad2cddf59d309ddaa2e3e4 repository lib check !!
Remote obproxy-ce-4.2.1.0-11.el7-0aed4b782120e4248b749f67be3d2cc82cdcb70d repository install ok
Remote obproxy-ce-4.2.1.0-11.el7-0aed4b782120e4248b749f67be3d2cc82cdcb70d repository lib check ok
Remote ocp-server-ce-4.2.1-20231208144448.el7-58cf72891d75a2fa7c754bafc42d336525baf0b5 repository install ok
Remote ocp-server-ce-4.2.1-20231208144448.el7-58cf72891d75a2fa7c754bafc42d336525baf0b5 repository lib check ok
Try to get lib-repository
Remote oceanbase-ce-libs-4.2.1.2-102000042023120514.el7-b4ae00ee729404557fa858d4cdd87250bca1aa63 repository install ok
Remote oceanbase-ce-4.2.1.2-102000042023120514.el7-b2ccb524f200a9ef0fad2cddf59d309ddaa2e3e4 repository lib check ok
obcluster deployed
Search plugins ok
Load cluster param plugin ok
Check before start observer ok
[WARN] OBD-1012: (192.168.142.12) clog and data use the same disk (/data)

Start observer ok
observer program health check ok
Connect to observer ok
Initialize oceanbase-ce ok
Wait for observer init ok
+--------------------------------------------------+
|???????????????????? observer???????????????????? |
+----------------+---------+------+-------+--------+
| ip???????????? | version | port | zone? | status |
+----------------+---------+------+-------+--------+
| 192.168.142.12 | 4.2.1.2 | 2881 | zone1 | ACTIVE |
+----------------+---------+------+-------+--------+
obclient -h192.168.142.12 -P2881 -uroot -p'zzh!@#123QAZ' -Doceanbase -A

succeed
Search plugins ok
Load cluster param plugin ok
Check before start obproxy ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
+--------------------------------------------------+
|???????????????????? obproxy????????????????????? |
+----------------+------+-----------------+--------+
| ip???????????? | port | prometheus_port | status |
+----------------+------+-----------------+--------+
| 192.168.142.12 | 2883 | 2884??????????? | active |
+----------------+------+-----------------+--------+
obclient -h192.168.142.12 -P2883 -uroot -p'zzh!@#123QAZ' -Doceanbase -A
succeed
Search plugins ok
Load cluster param plugin ok
Check before start ocp-server ok
Create tenant ocp_meta ok
Create tenant ocp_monitor ok
Start ocp-server ok
ocp-server program health check ok
Start ocp-server ok
ocp-server program health check ok
Connect to ocp-server ok
+---------------------------------------------------------------+
|?????????????????????????? ocp-server????????????????????????? |
+----------------------------+----------+--------------+--------+
| url??????????????????????? | username | password???? | status |
+----------------------------+----------+--------------+--------+
| http://192.168.142.12:8080 | admin??? | zzh!@#123QAZ | active |
+----------------------------+----------+--------------+--------+
succeed