oracle12C安装说明

逃离我推掉我的手 2021-11-26 14:38 384阅读 0赞

安装说明： windows 2012 操作系统  
oracle 12C 第二版本 64位服务端  
下载地址：[https://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html][https_www.oracle.com_technetwork_cn_database_enterprise-edition_downloads_index.html]

oracle 12C 第二版 32位客户端  
下载地址：[https://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/oracle12c-windows-3633015-zhs.html][https_www.oracle.com_technetwork_cn_database_enterprise-edition_downloads_oracle12c-windows-3633015-zhs.html]

# 服务端安装 #

解压下载下来的压缩包，打开解压出的文件夹，找到setup.exe进行安装（建议使用管理员权限进行安装，并且关闭杀毒软件，防火墙等）  
软件更新页面点击不接受更新，下一步

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70]  
安装选项界面点击创建和配置数据库下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 1]  
选择服务器类  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 2]  
选择单实例数据库安装

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 3]  
选择高级安装  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 4]  
选择企业版安装  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 5]  
这里博主使用的是内置账户，为了安全考虑正式环境使用建议使用独立账户  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 6]  
安装路径设置  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 7]  
选择一般用途  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 8]  
创建数据库标识符，容器数据库根据需要进行创建  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 9]  
自动内存管理设置，如果内存大于4G不进行设置，否则会报错  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 10]  
字符集默认选择UTF-8  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 11]  
默认使用文件系统，如果是rac安装这里建议使用asm  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 12]  
默认不选择  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 13]  
这里可以选择不启动恢复。该功能至少需要25G硬盘。服务器正式环境安装建议启动。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 14]  
管理员账户设置  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 15]  
查看安装环境概要  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 16]  
进行安装  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 17]  
安装完成  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 18]

# 客户端安装 #

选择管理员版本  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 19]

使用windows内置账户  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 20]  
设置安装位置

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 21]

检查安装环境  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 22]  
安装信息概要  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 23]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 24]  
安装完成  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 25]

# 测试 #

lsnrctl status  #检测监听状态

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 26]

tnsping orcl

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 27]

# PLSQL 连接 ora-12514问题 #

安装完成之后 可以在其他机器上tnsping 通oracle的服务。但是使用plsql无法连接。修改net manager之后也是不行。最后发现是计算机host文件限制了访问地址。只能使用localhost或者网络IP访问。

C:\Windows\System32\drivers\etc # 修改IP地址 将127.0.0.1的前面的#去除

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 28]

参考文件：

安装过程中INS-30131问题解决。  
[https://blog.csdn.net/hairi1234/article/details/85111062][https_blog.csdn.net_hairi1234_article_details_85111062]

[https_www.oracle.com_technetwork_cn_database_enterprise-edition_downloads_index.html]: https://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html
[https_www.oracle.com_technetwork_cn_database_enterprise-edition_downloads_oracle12c-windows-3633015-zhs.html]: https://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/oracle12c-windows-3633015-zhs.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70]: /images/20211126/a2a334159b304eb0b3cc8f0459e12c06.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 1]: /images/20211126/5745b93110bf41b284ed62823aa8b4ae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 2]: /images/20211126/3d6c799ab86142688a2359c0454a429d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20190723104906841.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20190723105026820.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20190723105242543.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20190723105413374.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20190723105447163.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20190723105531643.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20190723105640465.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20190723110513494.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 11]: https://img-blog.csdnimg.cn/20190723110608466.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20190723110753194.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 13]: https://img-blog.csdnimg.cn/20190723110822195.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 14]: https://img-blog.csdnimg.cn/20190723110919823.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 15]: https://img-blog.csdnimg.cn/2019072311140737.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 16]: https://img-blog.csdnimg.cn/2019072311150350.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 17]: https://img-blog.csdnimg.cn/20190723111942810.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 18]: https://img-blog.csdnimg.cn/20190723133045440.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 19]: https://img-blog.csdnimg.cn/20190723163810822.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 20]: https://img-blog.csdnimg.cn/20190723163858771.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 21]: https://img-blog.csdnimg.cn/20190723163926951.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 22]: https://img-blog.csdnimg.cn/20190723163938825.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 23]: https://img-blog.csdnimg.cn/20190723163952840.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 24]: https://img-blog.csdnimg.cn/20190723164018166.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 25]: https://img-blog.csdnimg.cn/20190723164234548.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 26]: https://img-blog.csdnimg.cn/20190723174521475.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 27]: https://img-blog.csdnimg.cn/20190723175103327.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll_size_16_color_FFFFFF_t_70 28]: https://img-blog.csdnimg.cn/20190723175327495.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tydWll,size_16,color_FFFFFF,t_70
[https_blog.csdn.net_hairi1234_article_details_85111062]: https://blog.csdn.net/hairi1234/article/details/85111062