oracle11g ORACLE Not available

After using Oracle to do something for the roommate, I just used shutdown abort to shut down the database, the file created in the table space to send him, and then the original file * * * dropped, and then reconnect to Oracle there is a problem,,,

First, log in to Sqlplus/nolog,

Sql> conn System input Password: error:ora-01034:oracle not availableora-27101:shared memory realm does not exist process id:0 session id:0 Serial Number: 0

Startup will appear:

Sql> startupora-01031:insufficient Privileges

Then there is Google, Baidu,,, to draw on the command line with:

Sqlplus "Sys/password as SYSDBA"

Connected to an idle routine. After startup, the database starts successfully, but also with errors

The sql> startuporacle routine has been started. Total System Global area 1670221824 bytesfixed size 2176328 bytesvariable size 1006635704 byte Sdatabase buffers 654311424 Bytesredo buffers 7098368 bytes database loaded. ORA-01157: Unable to identify/lock data file 6-see DBWR trace file ORA-01110: Data file 6: ' D:\MYTBS1. DBF '

See here I know the original is I deleted the tablespace file to cause the database to open when the configuration is not the same, so can not start, retrieve files after everything OK

This article is from the "Prairie Wolf" blog, please be sure to keep this source http://falcon1106.blog.51cto.com/6638492/1423746