【数据库基础知识】oracle client安装及配置

不念不忘少年蓝@ 2024-04-19 10:36 64阅读 0赞

费了一上午的功夫，安装配置oracle client，终于成功。下面记录下安装配置方法，以便将来用到。

首先下载oracle client，我下载了几个小时，![20190917130546750.png][]

下载链接暂时找不到了，可以直接百度上述文件名搜一下，后续找到后再添加。

官网地址：[http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html][http_www.oracle.com_technetwork_database_enterprise-edition_downloads_112010-win64soft-094461.html]

然后解压安装，教程如下：

1、点击setup.exe

![70][]

2、![20180318021236254][]

3、![20180318021451945][]

4、![20180318021725488][]

5、![70 1][]

6、![70 2][]

7、在安装目录下新建network\\admin

![20190917131414883.png][]

放入配置文件tnsnames.ora 若无，可从上面sample中复制

![20190917131439192.png][]

8、配置环境变量。

![20190917131121694.png][]

![20190917131248704.png][](oracle client安装目录)

![20190917131055891.png][]

![20190917131158424.png][]

9、cmd命令行验证

![20190917131602631.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTUyMzk5_size_16_color_FFFFFF_t_70][]

OK!

[20190917130546750.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/e6d72c6a015045ae86a17b4b8e1064b9.png
[http_www.oracle.com_technetwork_database_enterprise-edition_downloads_112010-win64soft-094461.html]: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
[70]: https://img-blog.csdn.net/20180318005136329?watermark/2/text/Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NDQyNTUz/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[20180318021236254]: https://img-blog.csdn.net/20180318021236254
[20180318021451945]: https://img-blog.csdn.net/20180318021451945
[20180318021725488]: https://img-blog.csdn.net/20180318021725488
[70 1]: https://img-blog.csdn.net/20180318021830912?watermark/2/text/Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NDQyNTUz/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 2]: https://img-blog.csdn.net/20180318022052288?watermark/2/text/Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NDQyNTUz/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[20190917131414883.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/1a9314a6417a415f98d36ba4feae8060.png
[20190917131439192.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/83cb0663b0e84cac80b83cc04cebd1dd.png
[20190917131121694.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/a7960eef3a3840278a1f8a68f64b6ab4.png
[20190917131248704.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/20cbbbe831024d78a07f8a5520ddf6c1.png
[20190917131055891.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/f8dcf3e66b7a4084869ca651059267fa.png
[20190917131158424.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/88245bf70fdb4d1ca5cb994233f8a527.png
[20190917131602631.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/12abed10d6504789b8c644280e10e10d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTUyMzk5_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/96bc2b086ce54a2eb54aac8dffec9a65.png