Oracle Database Discussions

Hi All,

I am not able to login to database.after performing this activities .Please help.



I have run the following commands. I checked tablespace datafile size and try to re-sizing the datafile size. I get following error.

Would you please help me.


Regards,
GS

=============================================
SQL>select * from DBA_DATA_FILES where TABLESPACE_NAME='TLAPP';

FILE_NAME
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_
------------------------------ ---------- ------------ --- ---------- ---------- -------
/HRPRODDATA/oradata/tlapp.dbf
118 TLAPP 2306867200 281600 AVAILABLE 118 YES 3.4360E+10 4194302 640 2306736128 281584 ONLINE

SQL> alter database datafile '/HRPRODDATA/oradata/tlapp.dbf' resize 9900m

SQL> alter database datafile '/HRPRODDATA/oradata/tlapp.dbf' resize 9900m;
alter database datafile '/HRPRODDATA/oradata/tlapp.dbf' resize 9900m
*
ERROR at line 1:
ORA-01135: file 118 accessed for DML/query is offline
ORA-01110: data file 118: '/HRPRODDATA/oradata/tlapp.dbf'

SQL> alter database datafile '/HRPRODDATA/oradata/tlapp.dbf' resize 9900m ;
alter database datafile '/HRPRODDATA/oradata/tlapp.dbf' resize 9900m
*
ERROR at line 1:
ORA-00376: file 118 cannot be read at this time
ORA-01110: data file 118: '/HRPRODDATA/oradata/tlapp.dbf'

SQL> select * from DBA_DATA_FILES where TABLESPACE_NAME='TLAPP';

FILE_NAME
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_
------------------------------ ---------- ------------ --- ---------- ---------- -------
/HRPRODDATA/oradata/tlapp.dbf
118 TLAPP AVAILABLE 118 RECOVER

SQL>

======================================================