Oracle12C配置对外访问
第一步:
开放端口或者关闭防火墙
第二步:
配置Oracle net manager
打开Net manager 修改为共享服务器
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112142748-2050644243.png)
第三步:
配置连接数
打开Database Configuration Assistant
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112154987-1947564826.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112203961-1195407785.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112214675-414117691.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112225424-2113152663.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112234914-1419346601.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112306011-675225985.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112324635-890611122.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112336430-108682471.png)
第四步:
修改监听ip
找到安装Oracle的ADMIN目录:
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112358120-526896141.png)
文件夹下打开下述文件:
修改如下(主要是修改HOST的值):
tnsnames.ora
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112409210-2038780169.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112421949-1518971199.png)
listener.ora
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112439263-863363805.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112445891-1329503848.png)
![](https://img2020.cnblogs.com/blog/1979837/202011/1979837-20201104112456065-227519060.png)
修改完毕后重启所有服务(这点非常重要)!
作者:彼岸舞
时间:2020\06\23
内容关于:Oracle
本文属于作者原创,未经允许,禁止转发