New User ? Sign Up  |  Sign In  |  Help
ask
answer
discover
     
Search for questions :
My Profile
Categories

Brian Turner

Open Question Bookmark and Share

Unable to resolve the error”Instance could not be started” ?

Today when I was mounting my Oracle database in my office using administrative privileges by starting the instance using the command: oradim -new -sid %ORACLE_SID% -pfile c:\path\to\your\init.ora
But instead of starting up of instance, an error message displayed on the screen

‘Instance could not be started”

Since then, I am unable to access the records stored in the database as the database was unmounted. What should I do in this situation? Give me some suggestion.

522 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

David Thomas 		The “Instance could not be started “error appears when you attempt to mount your Oracle database. After getting this error, you are unable to access the data existing in the database because of following reasons:

The error you stated occurs either in these situations:

• The parameter file could not be opened.
• You do not have enough privileges that allow you to start the instance.
• Your oracle database got corrupt

Resolution:

Make sure that the parameter file is located at its default location.

Check whether you have sufficient privileges and they are part of DBA group.

If the database is corrupted, restore it from backup. In other case, use Oracle Repair Software that will repair the corrupted database and bring it back to accessible condition. It is integrated with efficient scanning algorithms that perform the task of repairing the database efficiently. This tool allows both DBAs as well as home users to do database repair easily.



Posted 522 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0