I encountered this problem when I used Oracle today, mainly in creating tablespaces. When I added a data file, I started to dislike it. Later I wanted to delete it and I stopped the service, this error occurs when you delete it in the resource manager and enable oracle. I found a solution on the Internet to record the feasibility of the Final Experiment for later use.
Enter cmd and enter sqlplus sys as sysdba;
Enter the password and an SQL statement is displayed.
Enter shutdown immediate to stop the service.
Enter startup to start the service. If there is a mistake, the system prompts that the file cannot be loaded, such as datafile 6...
Record the wrong file number (6 here)
Then stop the service shutdown immediate again, and then enter start mount. Then, the service is started again.
If the deleted file is still in the recycle bin, use recover datafile 6 to restore it. If the file has been completely deleted, you can use alter database datafile 6 offline drop to delete and delete files offline.
Then input alter database open;
For the sake of insurance, you can delete the name of the drop tablespace together with the wrong tablespace;
And then reconnect to the conn.