oceanbase企业版部署

https://blog.csdn.net/avatar_2009/article/details/146917486

https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000944267

groupadd admin

useradd admin -g admin

rpm -ivh rpm -ivh oceanbase-3.2.4.1-101000052023010822.el7.x86_64.rpm

#路径根据实际修改
mkdir -p /data/1/$cluster_name/{etc3,sort_dir,sstable} 
mkdir -p /data/log1/$cluster_name/{clog,etc2,ilog,slog,oob_clog} 
mkdir -p /home/admin/oceanbase/store/$cluster_name
 
for t in {etc3,sort_dir,sstable};do 
  ln -s /data/1/$cluster_name/$t /home/admin/oceanbase/store/$cluster_name/$t; 
done
 
for t in {clog,etc2,ilog,slog,oob_clog};do 
  ln -s /data/log1/$cluster_name/$t /home/admin/oceanbase/store/$cluster_name/$t; 
done

su - admin

限制资源（内存最少需要8G）

cd /home/admin/oceanbase && /home/admin/oceanbase/bin/observer -i eno1 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/obdemo -r '10.1.1.38:2882:2881' -c 10001 -n obdemo -o "__min_full_resource_pool_memory=1073741824,cpu_count=4,system_memory=4G,memory_limit=8G,cache_wash_threshold=2G,-l ERROR,datafile_size=50G,config_additional_dir=/data/oceanbase/1/obdemo/etc3;/data/oceanbase/log1/obdemo/etc2"

不限制资源

cd /home/admin/oceanbase && /home/admin/oceanbase/bin/observer -i eno1 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/obdemo -r '10.1.1.38:2882:2881' -c 10001 -n obdemo -o "__min_full_resource_pool_memory=1073741824,system_memory=4G,-l ERROR,datafile_size=50G,config_additional_dir=/data/oceanbase/1/obdemo/etc3;/data/oceanbase/log1/obdemo/etc2"

SET SESSION ob_query_timeout=1000000000;
ALTER SYSTEM BOOTSTRAP ZONE 'zone1' SERVER '10.1.1.38:2882';

oracle模式创建schema

create user u1 identified by 123456;

grant connect to u1;

grant create table to u1;

grant create view to u1;

grant resource to u1;

删除用户和schema

DROP USER u1 CASCADE;

dbeaver连接oceanbase-oracle模式，驱动类型选择oracle，按下图配置