10 Replies Latest reply: Jan 29, 2013 1:16 PM by CKPT RSS

    error databse connection closed

    899401
      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