# Listener.ora Network Configuration File:d:\app\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST =myserver) (PORT = 1521))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
)
Adr_base_listener = D:\app\Administrator
In the monitoring configuration, pay attention to the host= computer name, if written in 127.0.0.1, will cause the remote computer can not connect,
The remote port does not open because port 1521 is running on the 127.0.0.1
Attention:
D:\app\Administrator\product\11.2.0\dbhome_1\database\oradim.log This file is saved with the log on when the service is opened
The following error is reported:
ORA-00119:INVALID specification for system parameter Local_listener
Ora-00132:syntax error or unresolved network name ' LISTENER_ORCL '
Problem-handling process:
1. Modify the Tnsnames.ora file and add the following statement:
# Tnsnames.ora Network Configuration File:d:\app\administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORA11 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(Connect_data =
(Service_Name =ora11)
)
)
LISTENER_ORA11 =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
Problems with Oracle 11g configuration