Oracle与PL/SQL安装

一、Oracle服务器、客户端的安装
1、Oracle服务器的安装
首先，找到安装包，双击打开。勾选选项，点击下一步
https://img-blog.csdnimg.cn/20190305094229577.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
接着，确认默认选项，直接点击下一步
输入全局数据库名（db11g） 和管理口令（任意输入）
https://img-blog.csdnimg.cn/2019030509443555.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
执行先决条件，点击全部忽略，然后点击下一步
https://img-blog.csdnimg.cn/20190305094708487.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
安装产品
https://img-blog.csdnimg.cn/20190305095658919.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70

https://img-blog.csdnimg.cn/20190305095623152.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70

https://img-blog.csdnimg.cn/20190305100123383.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
安装成功
https://img-blog.csdnimg.cn/20190305100258951.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
网页链接进入
https://img-blog.csdnimg.cn/20190305100707298.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
网页链接结果
https://img-blog.csdnimg.cn/20190305100814735.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70

2、Oracle客户端的安装
首先，找到安装包，双击打开。勾选管理员选项，点击下一步
https://img-blog.csdnimg.cn/2019030510131885.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
产品语言选择默认，点击下一步
安装位置选择默认（最好是不常用的），点击下一步
https://img-blog.csdnimg.cn/20190305101502915.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70)
执行先决条件，点击全部忽略，然后点击下一步
https://img-blog.csdnimg.cn/20190305101812394.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
安装产品
https://img-blog.csdnimg.cn/20190305101850612.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
安装成功
https://img-blog.csdnimg.cn/20190305102244561.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70

二、PL/SQL的安装
首先，找到安装包，双击打开。勾选第一个选项，点击下一步
https://img-blog.csdnimg.cn/20190305102442828.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
默认其选项，点击下一步
https://img-blog.csdnimg.cn/20190305102515100.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70

https://img-blog.csdnimg.cn/20190305102545735.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
安装
https://img-blog.csdnimg.cn/20190305102618597.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
登录
https://img-blog.csdnimg.cn/20190305103030596.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
找到help，点击Register
https://img-blog.csdnimg.cn/20190305103129527.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
输入内容
https://img-blog.csdnimg.cn/20190305104523162.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
双击Chinese安装包，选择目标目录
https://img-blog.csdnimg.cn/20190305104807362.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70)
勾选项目，点击下一步
https://img-blog.csdnimg.cn/2019030510483896.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70
勾选全部选项，点击完成
https://img-blog.csdnimg.cn/20190305104906809.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70

三、创建表空间、创建用户、赋予权限

打开PL/SQL软件
点击 文件–新建–命令窗口
输入
create tablespace Soft863
logging
datafile ‘E:\app\Administrator\oradata\db11g\Soft863_1.dbf’
size 50m
autoextend on
/

点击 新建-- SQL窗口
输入
create user prjSoft identified by prjSoft default tablespace Soft863;
grant dba to prjSoft;
两个语句分别执行
最后重新登录
https://img-blog.csdnimg.cn/20190305131438994.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQU4wXw==,size_16,color_FFFFFF,t_70