Analysis and solution of the problem that Oracle can't start normally after the computer name is modified
- 2021-07-24 11:55:42
- OfStack
A while ago, after installing oracle for my sister, I found that my sister's computer name was so long that it was not easy to remember, so my hand itched at 1 o'clock and changed her computer name for 1 time. I didn't expect this one-step operation to hurt my old man, and a tragedy was about to begin!
After changing the computer name and restarting the computer, it was found that oracle could not be started. At that time, I thought, poor ah, after the installation is completed, oracle can still be started, how can it not be done now? After careful recollection of my old man, I found that the culprit was the computer name I changed conveniently. Because oracle starts listening, proxies, etc. are all bound to the computer name from 1.
I immediately use my only 1 killer-google, through the online predecessors of the guidance, and my efforts to fight, the tragedy was finally stopped by me!
My solution is as follows: 1. Install% oracle directory%\ network\ agent directory under all. q file deletion 2. Modify the% oracle installation directory%\ network\ admin\ lisntr. ora file to update the host name to its current name 3. Modify the% oracle installation directory%\ network\ admin\ tnsmar. ora file to update the host name to its current name 4. Restart the computer. Ha ha, it seems that 1 careless operation can cause so much trouble, but also learned new things. Pay tribute to the predecessors!
After changing the computer name and restarting the computer, it was found that oracle could not be started. At that time, I thought, poor ah, after the installation is completed, oracle can still be started, how can it not be done now? After careful recollection of my old man, I found that the culprit was the computer name I changed conveniently. Because oracle starts listening, proxies, etc. are all bound to the computer name from 1.
I immediately use my only 1 killer-google, through the online predecessors of the guidance, and my efforts to fight, the tragedy was finally stopped by me!
My solution is as follows: 1. Install% oracle directory%\ network\ agent directory under all. q file deletion 2. Modify the% oracle installation directory%\ network\ admin\ lisntr. ora file to update the host name to its current name 3. Modify the% oracle installation directory%\ network\ admin\ tnsmar. ora file to update the host name to its current name 4. Restart the computer. Ha ha, it seems that 1 careless operation can cause so much trouble, but also learned new things. Pay tribute to the predecessors!