The host of oracle listener. ora cannot be set to localhost, but should be the machine name. Otherwise, the connection cannot be performed by IP address, listener. ora
# 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 = ay1401_135826z) (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 /)
)
)
Oracle connection, localhost can be connected, and 19216812 cannot be connected. For more information, see !!!
Disable the firewall on this machine. Try 192.168.1.2.
The host in ORACLE tnsnamesora and listenerora is automatically generated as localhost.
After listener. ora is modified, restart the listener.