I'm caught up in a strange situation here. I have had this test DB server in my laptop since one year. But I didn't start it since 3 months as another test server was available in my workplace.
Now when I try to connect to it using Sql*Plus and run it again, it keeps saying:
I found my login was not included in the Ora_Dba group and also I was missing the pwdfile, which I've created now. I can connect to the instance now. However, it is still not allowing me to start the DB. Throws out same error message when I do Startup. Please advise.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
I started the DB with PFILE this time and it started without any problem. And then I recreated spfile and shutdown the DB. I again started the DB with spfile and it started the DB without any problem this time. So, it makes me think that my earlier spfile was corrupted.
Thanks to all for your suggestions.