1、数据库启动与关闭root用户登陆: /opt/oracle/app/19c/grid/bin/crsctl stop crs /opt/oracle/app/19c/grid/bin/crsctl start crs 2、表空间创建 create tablespace mydata datafile '+data' size 10m; 用户创建 create user cde identified by 111 default tablespace mydata; 用户授权 grant dba to cde; 用户登陆 conn cde/111; 创建表 create table people(id number(12) primary key,name varchar2(20)); 插入数据 insert into people values(1,'cde01'); insert into people values(2,'cde02'); 提交 commit; 查询 select * from people; 验证: 另一台rac主机登陆:切换到oracle用户,再splplus cde/111登陆,select * from people; 查看数据如果有同样的数据,表时使用正常。 |