Skip to content

ORA-19502: write error on file

11/05/2015

Description:
Adding a new tablespace threw the following Oracle error, the sql file contained the following statement:

PROMPT Creating Tablespace TS_SCHMASK2
create tablespace TS_SCHMASK2
datafile '/data/oradata/FTEST2/TS_SCHMASK201.DBF' SIZE 32000M REUSE autoextend on next 1000M,
 '/data/oradata/FTEST2/TS_SCHMASK202.DBF' SIZE 32000M REUSE autoextend on next 1000M,
 '/data/oradata/FTEST2/TS_SCHMASK203.DBF' SIZE 32000M REUSE autoextend on next 1000M,
 '/data/oradata/FTEST2/TS_SCHMASK204.DBF' SIZE 20000M REUSE autoextend on next 1000M;

Symptom:

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 8 10:30:34 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @ebs_storage_schmask2_02

Creating Tablespace TS_SCHMASK2
create tablespace TS_SCHMASK2
*
ERROR at line 1:
ORA-19502: write error on file “/tribal/oradata/FTEST2/TS_SCHMASK201.DBF”,
block number 3633792 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 3633792
Additional information: 491520

Cause:
The filesystem has insufficient disk space available.

Resolution:
Free up disk space.

You can drop any tablespaces and datafiles which are no longer required if there are any with the following statement:
DROP TABLESPACE  INCLUDING CONTENTS AND DATAFILES;

Other housekeeping on the filesystem can be carried out as necessary.

Advertisements

From → ORA Errors

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: