Oracle Listener boot Cannot connect

Phenomenon

Remote Client Toad connection, the card is not responding. The Oracle server uses the tsping {IP address} prompt to connect.

1. Follow the prompts to query the appropriate questions, prompting for possible configuration problems, checking Listener.ora (path F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora) The path is viewed according to the actual installation path;
2. Check configuration file Configuration

   (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))

   The configured host is also the computer name, not the dynamic IP

3. Attempt to restart the Oracleoradb11g_home1tnslistener service, reconnect, no effect
4. Check that the corresponding listening log file is too large, actually only a few k.
5. Suspect a computer with the same computer name under the same workgroup (workgroup), modify the native computer name, modify the computer name in the configuration file, including the Listener.ora and Tnsnames.ora two configuration files.
6. Restart the computer, using tsping {IP address} detection, there is a return result.
7. The client tries to connect successfully on the connection.

Useful tools

1. Can be used in cmd lsnrctl status to view the status of the listening service
2. sqlplusoperation with access to the database
3. show parameter listenView the configuration of the listener in the database
4. alter system set local_listener=‘(ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))‘(Modify the parameters in the listening configuration list, the parameters in the quotation marks are only examples)

Oracle Listener boot Cannot connect