Nothing special,just keep track the history.
C:\Users\Administrator>tnspic
'tnspic' is not recognized as an internal or external command,
operable program or batch file.
C:\Users\Administrator>tnsping orcl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-MAY-2013 11:06:32
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HP580)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = orcl)))
^C
C:\Users\Administrator>
C:\Users\Administrator>set oracle_sid=orcl
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 17 11:08:31 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2185160 bytes
Variable Size 6174017592 bytes
Database Buffers 4496293888 bytes
Redo Buffers 16977920 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> conn businessdata/businessdata
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 419 Serial number: 3
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
Warning: You are no longer connected to ORACLE.
SQL> show user
USER is ""
SQL> exit
Check diskspace and find there is no diskspace on datafile filesysystem.
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 17 14:33:20 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2185160 bytes
Variable Size 6174017592 bytes
Database Buffers 4496293888 bytes
Redo Buffers 16977920 bytes
SQL> alter database rename datafile 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.DBF';
alter database rename datafile 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.DBF'
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
SQL> abase rename datafile 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.D
SP2-0734: unknown command beginning "abase rena..." - rest of line ignored.
SQL> rename datafile 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.DBF';
rename datafile 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.DBF'
*
ERROR at line 1:
ORA-00946: missing TO keyword
SQL>
SQL>
SQL> alter database rename file 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.DBF';
alter database rename file 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.DBF'
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
Database altered.
SQL> alter database rename file 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.DBF';
alter database rename file 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.DBF'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 31 - new file 'E:\DATALRG15.DBF' not found
ORA-01110: data file 31: 'F:\BBCLDB\ORCL\DATALRG15.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) ???????????
SQL> select name from v$database;
NAME
---------
ORCL
cut and paste the file to the target drive.
SQL> alter database rename file 'F:\BBCLDB\orcl\DATALRG15.DBF' to 'E:\DATALRG15.DBF';
Database altered.
SQL> alter database open;