Originally posted by Ben Souther: "rohithrs", Please check your private messages. -Ben
i am having the same problem will you please help......
Joined: Oct 06, 2007
Originally posted by rohith rs: Oracle 10g installed in my Linux OS.
# su - oracle # sqlplus log/logpwd as sysdba ; // once above command entered
sql> startup; ......... ......... database mounted; //then its giving these error message ora-01115 : IO error reading blick from file 2 (block # 2252) ora-01110 : data file 2: '/u02/oradata/orcl/undotbs01.dbf' ora-27072 : file I/O error Linux error : 2: No such file or directory Additional Info : 2251
sql> shutdown; database not open
how to solve these problem..... give me a solution
is U02 mounted?
Joined: Nov 10, 2009
Hi folks, hope this message is not considered as spam because I suggest a good solution to the question, raised by rohithrs. I can recommend trying the sql server data file secondary restore program that automatically eliminates dbf errors. It is a good solution, if you experience any difficulties with dbx files. Hope this helps