bushido2006
asked on
TNS Adapter Erorr / Undotbs01 cannot be opened
Hellow all,
About a week ago, a small oracle 9i database on Windows 2000 Server stopped taking logins. The error was Shared Memory realm does not exist, stopping and starting the services produce this message in the log. File 2 cannot be read <path>\undotbs01.dbf . I have tried to remove the undo entries in the .ora file and bring it up in manual mode with no luck, that just produces the same error. Here is the problem, if I log into the service in no log mode sqlplus / nolog I get a TNS Adapter error when I try to connect. No matter what I do I keep getting this TNS error when I try to authenticate. Any idea how I can drop the Undo table and get this db online.
About a week ago, a small oracle 9i database on Windows 2000 Server stopped taking logins. The error was Shared Memory realm does not exist, stopping and starting the services produce this message in the log. File 2 cannot be read <path>\undotbs01.dbf . I have tried to remove the undo entries in the .ora file and bring it up in manual mode with no luck, that just produces the same error. Here is the problem, if I log into the service in no log mode sqlplus / nolog I get a TNS Adapter error when I try to connect. No matter what I do I keep getting this TNS error when I try to authenticate. Any idea how I can drop the Undo table and get this db online.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I finally resolved this by myself, this is what I did.
SQLPLUS /nolog
connect as sys/password@sid as sysdba
startup mount;
recover datafile 'pathto undotbs01.dbf'
alter database datafile 'pathto undotbs01.dbf' online
alter database open;
Thanks Sandy for trying to help, I think you should get partial credit because your solution did point me in the right direction.
SQLPLUS /nolog
connect as sys/password@sid as sysdba
startup mount;
recover datafile 'pathto undotbs01.dbf'
alter database datafile 'pathto undotbs01.dbf' online
alter database open;
Thanks Sandy for trying to help, I think you should get partial credit because your solution did point me in the right direction.
ASKER
But that is the nature of my problem, I run sqlplus /nolog and type startup mount (or nomount for that matter) and I get an tns adapter error. I have tried tnsping and it returns ok. Any more thoughts.