Oracle 12c 的使用和学习

创建实例

Alt text
Alt text
等十几分钟

查看实例

Alt text

登录

首次登录以超级管理员身份

1
sqlplus  / as sysdba

创建个人用户

1
create user c##rocky identified by root; /*一定加入##,rocky为用户名，root为密码。*/

对新用户授权

1
grant connect,resource,unlimited tablespace to c##rocky container=all;

退出后重新登录

1
2
sqlplus
/*输入用户名和密码*/

##Oracle SQl Developer
Alt text
Oracle

在developer图形化建表，插入初始数据

java+odbc连接数据库

在项目中导入odbc7.jar

1
2
3
4
5
6
7
8
9
10
11
select sys_context('userenv','db_name')as db_name from dual;


select v.name,v.open_mode,d.status,from v#PDBs;

lsnrctl status

create pluggable database udb
roles = (dba)
default tablespace u_ts
datafile '<oracle>'

动态绑定监听器端口

1
alter system set LOCAL_LISTENER='(ADDRESS = (PROTOCOL = TCP)(HOST = 222.20.77.184)(PORT = 1521))';

insert into SOD values(‘Ent’,’Exp’,’Mars’);(priv= ‘U’)
select from SOD;
update SOD set dest = ‘Talos’ where ship = ‘Ent’; (priv= ‘S’)
update SOD set dest = ‘Rigel’ where ship = ‘Ent’; (priv= ‘U’)
select from SOD;
delete from SOD where obj = ‘Exp’;