手把手叫你安装Oracle

àì夳堔傛蜴生んèń 2022-11-04 11:13 47阅读 0赞

前言

> 这是我听老师讲课做的笔记,考试要看的。 [这是视频地址][Link 1]  
> 作者：陈运智  
> 关注我的[csdn博客][csdn]，更多Linux笔记知识还在更新  
> 本人只在csdn写博客

## 环境 ##

1.  VMware虚拟机
2.  Windows2003
3.  oracle数据库

> 虚拟机官网里面有，可以自己找到安装

## 安装Windows2003 ##

> 首先打开虚拟机  
> 获取安装包解压提取到你放置的目录

![在这里插入图片描述][20210302095603797.png]

点击打开

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

## 配置网络 ##

我这里是配置了本地。

> 也可以配置nat，虽然安装oracle时候有警告，但是貌似不要紧，方法差不多，可以借鉴这篇文章（借鉴而已）  
> [https://chenyunzhi.blog.csdn.net/article/details/107232983][https_chenyunzhi.blog.csdn.net_article_details_107232983]

![在这里插入图片描述][20210302100634663.png]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 1]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 3]

虚拟机内  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 4]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 5]

测试一下在本地计算机能否ping通

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 6]

## 安装oracle ##

1.  拷贝包到虚拟机中，输入口令，（相当于密码，别忘记了）

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 7]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 8]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 9]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 10]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 11]

在windows虚拟机中测试  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 12]

## 可视化的工具的安装和配置（以下工具在本地主机上安装） ##

解压以下这个文件  
![在这里插入图片描述][20210302223608377.png]  
在这个目录下远程连接

sqlplus system/chenyunzhi@192.168.17.10:1521/orcl

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 13]

**安装PLSQL**

![在这里插入图片描述][20210302223833899.png]  
**双击然后选择自己需要安装的目录，下一步下一步就行了**，安装好了在桌面就有图标了  
![在这里插入图片描述][20210302124430474.png]

打开然后点击取消就可以进入界面  
![在这里插入图片描述][2021030212470137.png]

打开下面另一个软件，破解  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 14]

**在重新打开登录**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 15]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 16]

## 查看中文编码 ##

进入本地主机

查看编码： select userenv('language') from dual;

![在这里插入图片描述][20210302222349122.png]

## 错误 ##

> PL/SQL报错：Initialization error Oracle client not properly installed

![在这里插入图片描述][20210302220245958.png]  
这个文件的路径放错（如果还错就放入到）  
![在这里插入图片描述][20210302220405935.png]

![在这里插入图片描述][20210309112037628.png]

![在这里插入图片描述][20210309112533195.png]

## 直接拖动文件到虚拟机出现蓝屏 ##

解决办法：[https://mbd.baidu.com/ma/s/PgHUjiYq][https_mbd.baidu.com_ma_s_PgHUjiYq]

> 本人博客：[https://blog.csdn.net/weixin\_46654114][csdn]  
> 本人b站求关注：[https://space.bilibili.com/391105864][https_space.bilibili.com_391105864]  
> 转载说明：跟我说明，务必注明来源，附带本人博客连接。

请给我点个赞鼓励我吧  
![在这里插入图片描述][20200507113619405.png_pic_center]

[Link 1]: https://www.bilibili.com/video/BV1KJ411h7NH?p=5
[csdn]: https://blog.csdn.net/weixin_46654114
[20210302095603797.png]: /images/20221023/f53931c9ce824dca9ec3d6e9d56d9b83.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70]: /images/20221023/a9cc29edfa21485694e898b476aa602f.png
[https_chenyunzhi.blog.csdn.net_article_details_107232983]: https://chenyunzhi.blog.csdn.net/article/details/107232983
[20210302100634663.png]: /images/20221023/bbfeb93370764baeb7768f5a84bd050f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 1]: /images/20221023/879f76239f384ddb880228b82d5dcca7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 2]: /images/20221023/cc62b9b4159541e49c2fb62c1d1d1c34.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 3]: /images/20221023/c870052fe76c482095111957f4bf8b07.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 4]: /images/20221023/f21ee1aef5d34a20b2a8b9460edf0d15.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 5]: /images/20221023/51447c1b27724aa4b5c3b35a12c9633d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 6]: /images/20221023/100553b7ca044bf690b83456efbee643.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 7]: /images/20221023/9755d236502447a4ae110ac343f0b630.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 8]: /images/20221023/be0935a64a3e419f8a4184b84c4389e7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 9]: /images/20221023/099a1036757441dd966376e9752f6e80.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 10]: /images/20221023/50c223bac0e54a3994f283cb5e3bae86.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 11]: /images/20221023/7b4ef9b97d2f4a6695124cc62084c50b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 12]: /images/20221023/4db15a5cd9534623801f52e693bb4e86.png
[20210302223608377.png]: /images/20221023/3fb3570116cc46768dce6d548648be24.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 13]: /images/20221023/e19b8392ff6743acb4a4018e938b5d9b.png
[20210302223833899.png]: /images/20221023/1874df75687b4931be078a863ecacfe3.png
[20210302124430474.png]: /images/20221023/05ac61afae454740941eb4143ab0bb66.png
[2021030212470137.png]: /images/20221023/879ea35f68344b7dbd0173c214a948af.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 14]: /images/20221023/d1d108fc72d840d8953905e32336a71f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 15]: /images/20221023/8b054023db73483a9a9fb5e96b696aa3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjY1NDExNA_size_16_color_FFFFFF_t_70 16]: /images/20221023/f8e0742c71e34bcdb57e2fe05997c1d0.png
[20210302222349122.png]: /images/20221023/4c1de6eef1e74d5dadbb41f670a770b2.png
[20210302220245958.png]: /images/20221023/c722129a88d74b2ea5b1bff365a61207.png
[20210302220405935.png]: /images/20221023/caea0b7726f64d1bad058f5cbbffff34.png
[20210309112037628.png]: /images/20221023/d53473ba407a45069bc913677e9af82a.png
[20210309112533195.png]: /images/20221023/cca87f68a65d49368852ee5017e1b4e4.png
[https_mbd.baidu.com_ma_s_PgHUjiYq]: https://mbd.baidu.com/ma/s/PgHUjiYq
[https_space.bilibili.com_391105864]: https://space.bilibili.com/391105864
[20200507113619405.png_pic_center]: /images/20221023/bfbda196cc904b80a4d721e388144be4.png