How to solve error 1053 in oracle

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.

How oracle solves error 1053

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!