Oracle PL/SQL获取服务器的IP v4? [英] Oracle PL/SQL get server's IP v4?

问题描述

如何使用PL/SQL获取服务器的IP v4? UTL_INADDR.GET_HOST_ADDRESS给我IPv6，而我需要IPv4

我在服务器上禁用了IPv6，但仍然为我带来了隧道适配器Teredo Tunneling Pseudo-Interface"的IPv6！

我正在Windows 2008 R2 Server上使用Oracle 11g数据库

解决方案

UTL_INADDR.GET_HOST_ADDRESS仅返回一个无用的ip，因为服务器可能有数十个.最好的选择是创建一个Java方法的pl/sql包装器，该包装器使用NetworkInterface.getNetworkInterfaces();

返回每个可能的IP地址.

How can I get the IP v4 Of the server by using PL/SQL ? UTL_INADDR.GET_HOST_ADDRESS gives me IPv6, while I need IPv4

what I did I disabled the IPv6 on the sever, still it's bringing me the the IPv6 of the "Tunnel adapter Teredo Tunneling Pseudo-Interface" !!

I'm using Oracle 11g database on Windows 2008 R2 Server

解决方案

UTL_INADDR.GET_HOST_ADDRESS returns just an ip which is nonsense since a server may have dozens of them. Probably your best bet it's to create a pl/sql wrapper of a Java method which returns every possible ip address using NetworkInterface.getNetworkInterfaces();

这篇关于Oracle PL/SQL获取服务器的IP v4?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！