Oracle_Oracle12c安装

1、下载好oracle12c的安装包
2、清除勾选

3、选择创建数据库

4、桌面类

5、创建新的额windows用户

6、管理口令自己设置一个，要牢记（我这里设置的密码简单，会提示。）

7、确认

8、等待安装好即可

我安装的过程出现了一个错误，我直接选择跳过。
在oralce12c中默认是删除了scott的用户的，我这里为了学习得使用scott用户，就上网查询了资料导入到数据库中
创建c##scott用户（我记得好像得用c##开头来命名用户，scott是oracle系统内置的数据测试用户，但是这个版本给删除了）

#原文链接
https://blog.csdn.net/cfchengfei002/article/details/45582259?utm_medium=distribute.pc_feed_404.none-task-blog-BlogCommendFromMachineLearnPai2-3.nonecase&depth_1-utm_source=distribute.pc_feed_404.none-task-blog-BlogCommendFromMachineLearnPai2-3.nonecas
#链接数据库
sqlplus sys/sys as sysdba
#创建c##scott用户
CREATE USER c##scott IDENTIFIED BY tiger ;
#用户授权
GRANT CONNECT ,RESOURCE,UNLIMITED TABLESPACE TO  c##scott CONTAINER= ALL ;
#设置用户的表空间
ALTER USER c##scott DEFAULT TABLESPACE USERS;
ALTER USER c##scott TEMPORARY TABLESPACE TEMP ;
#使用c##scott用户登录
CONNECT c##scott/tiger
#删除数据表
DROP TABLE emp  PURGE ;
DROP TABLE dept PURGE ;
DROP TABLE bonus PURGE ;
DROP TABLE salgrade PURGE ;
#创建表
CREATE TABLE dept (deptno NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY ,dname VARCHAR2(14) ,loc VARCHAR2(13) ) 

CREATE TABLE emp (empno NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY ,ename VARCHAR2(10),job VARCHAR2(9),mgr NUMBER(4),hiredate DATE ,sal NUMBER(7,2),comm NUMBER(7,2),deptno NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT )

CREATE TABLE bonus (enamE VARCHAR2(10) ,job VARCHAR2(9)  ,sal NUMBER,comm NUMBER )

CREATE TABLE salgrade (grade NUMBER,losal NUMBER,hisal NUMBER )

#插入数据 dept
INSERT INTO dept VALUES (10, 'ACCOUNTING' , 'NEW YORK' );
INSERT INTO dept VALUES (20, 'RESEARCH' , 'DALLAS' );
INSERT INTO dept VALUES (30, 'SALES' , 'CHICAGO' );
INSERT INTO dept VALUES (40, 'OPERATIONS' , 'BOSTON' );
#插入数据 emp
INSERT INTO emp VALUES (7369, 'SMITH' , 'CLERK' ,7902,to_date( '17-12-1980' , 'dd-mm-yyyy' ),800, NULL ,20);
INSERT INTO emp VALUES (7499, 'ALLEN' , 'SALESMAN' ,7698,to_date( '20-2-1981' , 'dd-mm-yyyy' ),1600,300,30);
INSERT INTO emp VALUES (7521, 'WARD' , 'SALESMAN' ,7698,to_date( '22-2-1981' , 'dd-mm-yyyy' ),1250,500,30);
INSERT INTO emp VALUES (7566, 'JONES' , 'MANAGER' ,7839,to_date( '2-4-1981' , 'dd-mm-yyyy' ),2975, NULL ,20);
INSERT INTO emp VALUES (7654, 'MARTIN' , 'SALESMAN' ,7698,to_date( '28-9-1981' , 'dd-mm-yyyy' ),1250,1400,30);
INSERT INTO emp VALUES (7698, 'BLAKE' , 'MANAGER' ,7839,to_date( '1-5-1981' , 'dd-mm-yyyy' ),2850, NULL ,30);
INSERT INTO emp VALUES (7782, 'CLARK' , 'MANAGER' ,7839,to_date( '9-6-1981' , 'dd-mm-yyyy' ),2450, NULL ,10);
INSERT INTO emp VALUES (7788, 'SCOTT' , 'ANALYST' ,7566,to_date( '19-04-1987' , 'dd-mm-yyyy' )-85,3000, NULL ,20);
INSERT INTO emp VALUES (7839, 'KING' , 'PRESIDENT' , NULL ,to_date( '17-11-1981' , 'dd-mm-yyyy' ),5000, NULL ,10);
INSERT INTO emp VALUES (7844, 'TURNER' , 'SALESMAN' ,7698,to_date( '8-9-1981' , 'dd-mm-yyyy' ),1500,0,30);
INSERT INTO emp VALUES (7876, 'ADAMS' , 'CLERK' ,7788,to_date( '23-05-1987' , 'dd-mm-yyyy' )-51,1100, NULL ,20);
INSERT INTO emp VALUES (7900, 'JAMES' , 'CLERK' ,7698,to_date ( '3-12-1981' , 'dd-mm-yyyy' ),950, NULL ,30);
INSERT INTO emp VALUES (7902, 'FORD' , 'ANALYST' ,7566,to_date( '3-12-1981' , 'dd-mm-yyyy' ),3000, NULL ,20);
INSERT INTO emp VALUES (7934, 'MILLER' , 'CLERK' ,7782,to_date( '23-1-1982' , 'dd-mm-yyyy' ),1300, NULL ,10);
#插入测试数据 salgrade
INSERT INTO salgrade VALUES (1,700,1200);
INSERT INTO salgrade VALUES (2,1201,1400);
INSERT INTO salgrade VALUES (3,1401,2000);
INSERT INTO salgrade VALUES (4,2001,3000);
INSERT INTO salgrade VALUES (5,3001,9999);

#事务提交
COMMIT ;

oracle12c刚安装好，还没有详细使用，不知道后续会不会出问题。
Oralce的链接好数据库的时候，退出使用命令，否则下次登录可能会登录不上去

shutdown immediate