This discussion is archived
10 Replies Latest reply: Jan 29, 2013 11:16 AM by CKPT RSS

error databse connection closed

899401 Newbie
Currently Being Moderated
Hi,

I am gettting error message databse connection closed

itried

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 335545236 bytes
Database Buffers 192937984 bytes
Redo Buffers 5844992 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'C:\APP\VSHADMIN\ORADATA\ORCL01\SYSAUX01.DBF'


SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'C:\APP\VSHADMIN\ORADATA\ORCL01\SYSAUX01.DBF'

SYSAUX01.DBF' file is corrupted due to virus

thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points