How can I change the computer name to make Oracle unable to start?

1. after oracle is installed, changing the Windows computer name causes some Oracle third-party tools such as PLSQL developer to be unable to log on and prompts ORA-12541: TNS: No listener or ORA-12547: TNS: solutions for lost contact and other error messages.

A: According to the Oracle error message, TNS: No listener is used. It is estimated that a certain service has not been started. Open the windows management tool> service, there is a service such as oracleorahome90tnslistener, which is consistent with the error message. It is certainly a problem caused by this service. Again, the service was not started, and it was manually started. After refreshing, the service was automatically closed immediately. Retry n times. The result is the same. Looking at Google search, I didn't expect this to be a common problem. One person proposed to open listener. ora in the installation directory. For example, D: \ oracle \ ora90 \ Network \ admin \ listener. ora.
Open the configuration file and find the following configuration information:
Listener =
(Description_list =
(Description =
(Address_list =
(Address = (Protocol = IPC) (Key = extproc0 ))
)
(Address_list =
(Address = (Protocol = TCP) (host = Local) (Port = 1521 ))
)
)
)

When the host = Local line is displayed, the problem is solved. It turned out that after installing Oracle for a few days, the Windows computer name was changed, and the listening host name recorded in this configuration file was still the original name. This is no wonder that the oracleorahome90tnslistener service cannot be started, change to the current computer name immediately. Restart oracleorahome90tnslistener again. PL/SQL developer is successfully connected to the Oracle database and cannot log on to troubleshooting.

Summary: Oracle emphasizes manual function adjustment and places some configuration information in the configuration file. Unlike sqlserver, almost all information is stored in the registry. Of course, this is in line with the spirit of Oracle as a cross-platform database. However, it is difficult for beginners to solve this problem. Unlike SQL Server's "Dummies", Oracle was almost re-installed again when the problem was solved. It seems that there were many problems such as Google analysis, and it was still time-tested.