Unknown Series Of ORA Messages ' Very Weird'
718168Aug 19 2009 — edited Aug 20 2009Hello,
I have a db on 11g test. Everything was fine yesterday until i went this morning to work to discover i am not able to log in as sysdba.
When i log in i get this error ORA-21561: OID generation failed.
When i log in again it says connected to an idle instance. When i do ps -ef | grep db_name it shows me that all background processes are started. i ahve all enviromental variable correctly
I then tried to start the db with the startup command and i get this message
ORA-00000: normal, successful completion
then i do
SQL> select name from v$database;
ERROR:
ORA-01012: not logged on
when i use shu immediate it gives me again ORA-00000 normal, successful completion.
i then used shu abort and then started up the db again and then again the same sequence starts.
There is nothing in alert.log file and it shows a normal startup.
I also used startup pfile=, startup nomount and various options but i not able to get or view anything inside the db.
Could some please help me. I tried everything possible.