问题:
执行sql语句:SELECT utl_inaddr.get_host_address dbip FROM DUAL在安装了oracle服务端的环境中执行,不报错,但是在只安装oracle客户端的环境中执行就报如下错误:
ora-29257 host pongo unknown
ora-06512 at "SYS.UTL_INADDR", line 35
我想解决,怎样能够在只按照oracle客户端的环境下,也能正确执行这条sql语句
执行sql语句:SELECT utl_inaddr.get_host_address dbip FROM DUAL在安装了oracle服务端的环境中执行,不报错,但是在只安装oracle客户端的环境中执行就报如下错误:
ora-29257 host pongo unknown
ora-06512 at "SYS.UTL_INADDR", line 35
我想解决,怎样能够在只按照oracle客户端的环境下,也能正确执行这条sql语句
Cause: The specified host was unknown.
Action: Check the spelling of the host name or the IP address. Make sure that the host name or the IP address is valid.检查你的TNSNAMES配置,将host name改为IP试试!
Connected as testuser
SQL> SELECT utl_inaddr.get_host_address dbip FROM DUAL ;
DBIP
--------------------------------------------------------------------------------
133.64.39.143
SQL> SQL> SELECT utl_inaddr.get_host_address('133.64.39.142') dbip FROM DUAL ;
DBIP
--------------------------------------------------------------------------------
133.64.39.142
SQL> SELECT utl_inaddr.get_host_address('133.64.39.1422') dbip FROM DUAL ;
SELECT utl_inaddr.get_host_address('133.64.39.1422') dbip FROM DUAL
ORA-29257: 未知的主机 133.64.39.1422
ORA-06512: 在 "SYS.UTL_INADDR", line 19
ORA-06512: 在 "SYS.UTL_INADDR", line 40
ORA-06512: 在 line 1
SQL>
执行sql语句:SELECT utl_inaddr.get_host_address dbip FROM DUAL 新发现:报ora-29257 host pongo unknown
ora-06512 at "SYS.UTL_INADDR", line 35
错跟客户端没关系。同一个客户端,同一个sql语句,我分别连接三个oracle服务端,得到3种结果:1、连接一台linux虚拟机中的9i数据库,主机名为 pongo
报错:ora-29257 host pongo unknown 2、连接一台linux服务器中的 10g数据库
没报错,但返回的结果是 127.0.0.13、连接一台windows下的9i oracle数据库
没报错,返回正确的结果 192.168.88.54不明所以,请高手指教!
连WINDOWS服务器中的 10g也成功
返回的结果都正确
看看这个吧!