Open the database with a problem: unable to connect to the database, at first I don't know why, later found to be the newly created themselves table space and under the Windows to delete the temporary table space, lead to the database connection is not on (in addition to the sysdba) , and then create table can query before , then baidu for a long time, finally found a lecture more detailed solutions:
Up sqlplus/as sysdba//as a dba login database

Shutdown immediate;//close the database

Startup the mount;//open the control file

The alter database datafile 'D: \ app \ WHPLATFORM_ZX1. DBF' offline drop;
//(my table space created in the F: set) cancellation was mistakenly deleted tablespace file
The alter database open;//open the database

Finally solved the
(is really owe to play, not encounter this problem, is a problem, your hand more than make a mistake, but also let I learned a lot

CodePudding user response:

Good, can be placed in a blog

CodePudding user response:

Thanks for sharing, it is suggested that wrote in a blog post,

CodePudding user response:

reference 1st floor Mricoo_ weeks response:

good, can be placed in blog

Novice, also don't know where to write??????