Not Equal C && !=C && 不等于西
RSS icon Email icon Home icon
  • ORACLE databse can not start by missing tablespace file

    Posted on February 13th, 2010 Sean 1 comment

         Today, as usual, trying to login to Oracle database do something, but when typing “sqlplus” and username/password, it showing:

         It seems like Oracle database was not starting somehow. After connect the database as SYSDBA, type some command for trying to restart the datadase:

         Now finally realized what happened and how this happened. There is a tablespace file “XXX.dbf” missing. To solve this issue, connect database as SYSDBA, then:

    1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...Loading...
    558 views

    Leave a Reply

    1 Comment on "ORACLE databse can not start by missing tablespace file"


    Guest
    Johnod
    07/03/2010

    Do you have copy writer for so good articles? If so please give me contacts, because this really rocks! 🙂