Solution: 1. Use the "select value from v$diag_info where name ='Diag Alert';" command to obtain the location of the alert log; 2. Use the obtained location to open the "log.xml" file to find The real cause of the error; 3. Use "Lsnrctl status" to check the monitor status, and restart Oracle after modifying the "host" parameter in the parameter file.
The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.
In the service, when starting the oracleDBConsolenewdb service, error 1053 occurred: The service did not respond to the startup or control request
After checking online, you will find that this is a very common error. However, our suggestion is to look at the legendary Oracle alert log. Where is the alert log?
1. Use the command
select value from v$diag_info where name ='Diag Alert';
2. The Alert log is in C:myoracle hinkdiag dbms ewdb ewdbalert. Do not press Click the directory one by one. It is fastest to enter directly in the address bar
. Open log.xml and you will find the real cause of the error
3. TNS-12560: TNS: Protocol adapter error
The problem is still on the listener
Check the listener status
Lsnrctl status
It is found that there is no newdb service, and the protocol adapter error is still lsnrctl stop lsnrctl start to load the modified parameter files tnsnames.ora and listener.ora
(in the parameter file Change the host=localhost to the local computer name)
It will be fine after restarting
Recommended tutorial: "Oracle Video Tutorial"
The above is the detailed content of How to solve error 1053 in oracle. For more information, please follow other related articles on the PHP Chinese website!