oracle-Local Connection No problem, remote connection problem solution

1. Questions

My environment is ORACLE11GR2, local with plsql or toad connection is not any problem, and the other machine remote connection prompts no listener and other errors.

2. Causes

Oracle Installation Path---For example: F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN the following Listener.ora and Tnsnames.ora these two files open to see A bit

From the above two files can see the local monitoring and network monitoring, monitoring is localhost is only listening to the machine, so the connection to the database, the local can be connected, and remote connection is not!

3. Workaround

Replace all of the highlighted localhost in the above two files with the computer name of the cost machine. Then restart the Oralce service and listen to it.