Analysis and solution of the problem of Oracle not starting properly after computer name modification _oracle
Source: Internet
Author: User
A while ago, in the next to the old sister installed Oracle, found that the old sister's computer name is very long, not easy to remember, so a moment of preface, his computer name changed, did not expect this step operation, can be bitter bad my old man, a tragedy is about to begin!
When you change the computer name and restart the computer, Oracle is not able to start. At that time I think Ah, poor ah, installation is completed, Oracle can still start it, how to do it now. After a careful recollection of the elderly, I found that the culprit is the name of the computer I have changed conveniently. Because of the listener initiated by Oracle, the agents are all tied together with the computer name.
I immediately resorted to my only killer Jian--google, after the online predecessors of the guidance, and my efforts to fight, this tragedy was finally I stopped!
My solution is this: 1.%oracle installs all the directories under the%\network\agent directory. Q File deletion 2. Modify the%oracle installation directory%\network\admin\lisntr.ora file and update the host name to the current name 3. Modify%oracle installation directory%\network\admin\ Tnsmar.ora file, update the host name to the current name 4. After restarting the computer reboot, the problem is resolved. Oh, it seems that careless operation, can cause so much trouble, but also learned a new thing. Salute to our predecessors!
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.