Oracle entry series (2)

Oracle has not been used for a long time. If you want to verify an SQL statement tonight, the Oracle service cannot be started. Cold!
since the Oracle service was started automatically every time it was started, the Oracle service was started manually.
you have to solve the problem by yourself. Check the Oracle startup log. Where is the log? Long time don't forget, cold!
fortunately, we finally found the Oracle installation path/product/10.2.0/db_1/Network/log/listener. log
see the following error:
start with PID = 5108
listener: (description = (address = (Protocol = IPC) (pipename = //. /pipe/extproc1ipc)
An error occurred while listening to this object: (description = (address = (Protocol = TCP) (host = 192.168.1.102) (Port = 1521)
TNS-12545: connection failed because the target host or object does not exist
TNS-12560: TNS: protocol adapter error
TNS-00515: because the target host or object does not exist, connection Failed
32-bit Windows Error: 49: unknown error
no listening: (description = (address = (Protocol = IPC) (pipename = //. /pipe/extproc1ipc)

the problem is clear. If the server IP address is incorrect, run the ipconfig command to check that the IP address is no longer 1.102! In the future, dynamic IP addresses cannot be used to specify machines.
solution:
1. Changing the dynamic IP address to the current IP address may cause such problems in the future
changing the Oracle installation path/product/10.2.0/db_1/Network/tnsname. ora
Oracle installation path/product/10.2.0/db_1/Network/listener. ora
2. Change to the machine name. Generally, this problem does not occur if the machine name is not used.