Resolving oracle database connection exceptions caused by IP changes ORA-12541: TNS: no listeners"

Solve oracle database connection exceptions caused by IP changes "ORA-12541: TNS: no listening program" before the local machine installed oracle, several databases are commonly used, no exception. But today I use PLSQL to connect to the database, and found that the ORA-12541: TNS: No listener program ". To save content resources, oracle-related services are stopped when the database is not used. So we started oracle-related services. After starting the oracle service, try again and still cannot connect. Strange things. Simply restart the machine again and still cannot connect. Suddenly, in order to expand the IP address of the company, the IP addresses of all employees have changed recently. This IP address may change. Then set the relevant IP address. Finally. I changed "tnsnames" under the "product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN" directory. ora "and" listener. ora "configuration in two files," tnsnames. not to mention the configuration of ora, you should be familiar with oracle shoes, "listener. the configuration of ora is easy to understand, because the IP address is changed, you only need to modify the following Configuration:

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.83) (PORT = 1521 ))))

 

Among them, "HOST" is the focus. After modification according to your own situation, restart oracle and related services to solve the problem.