Oracle Service failed to start, always reported: Windows could not start the Oracleoradb10g_home1tnslistener service, error 1067: The process terminated unexpectedly.
On the internet for a long time also did not fix. What do you mean? The reconfiguration of the environment variable is not set up, inadvertently click the operation
Run the configuration and the net configuration Assistant in the Migration tool to configure the listener. Delete the configuration, and then reconfigure it.
Remember to remove the configuration and reconfigure it first, not the new configuration.
This problem has been bothering me for a long time, plsql can connect to the remote database, the cmd command can be connected to the local database, Plsql but not the local database. The above is my solution. Hope to be of help to everyone.
Note: The first picture is my connection to the remote database
The second picture is my local database service
The third picture is my listener configuration.
It's finally settled! Very happy! Hope to have the same problem can learn from the next!