oracle只能用localhost登陆，不能用ip访问

2019年3月5日

oraclelistener.ora的host不能使localhost，而应该是该机器名，否则不能用ip地址进行连接

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = AY140316135826Z)(PORT = 1521))
)

)

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl)
(SID_NAME=orcl)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/)
)
)


如果给你带来帮助，欢迎微信或支付宝扫一扫，赞一下。