Home » RDBMS Server » Server Administration » Unable to create tablespace (SunOS CMPA 5.8 Generic_108529-13 i86pc i386 i86pc - oracle 8.1.7.0.0)
Unable to create tablespace [message #385197] Sat, 07 February 2009 05:57 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member


dear sir,

when we create tablespace we are getting below error:


*************************
SQL> create tablespace cashin20042
datafile '/data 2 5/oradata/cmpa/070209_mst_01.dbf' size 1024m;
create tablespace cashin20042
*
ERROR at line 1:
ORA-19502: write error on file "/data5/oradata/cmpa/070209_mst_01.dbf", blockno
48513 (blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Intel SVR4 UNIX Error: 28: No space left on device
Additional information: -1
Additional information: 524288
ORA-19502: write error on file "/data5/oradata/cmpa/070209_mst_01.dbf", blockno
48385 (blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 409600
Additional information: 524288
********************************

proving df -k output..


$ df -k
Filesystem kbytes used avail capacity Mounted on
/dev/dsk/c0t0d0s0 5063990 1222116 3791235 25% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
mnttab 0 0 0 0% /etc/mnttab
swap 2257856 8 2257848 1% /var/run
swap 2257860 12 2257848 1% /tmp
/dev/dsk/c0t1d0s0 17653246 12423740 5052974 72% /data1
/dev/dsk/c0t2d0s0 18579609 8914003 9479810 49% /data2
/dev/dsk/c0t3d0s0 16774585 1300046 15306794 8% /data4
/dev/dsk/c0t2d0s1 16403116 13522507 2716578 84% /data3
/dev/dsk/c0t4d0s0 18579609 13473379 4920434 74% /data6
/dev/dsk/c0t3d0s1 16774585 1687748 14919092 11% /data5
/dev/dsk/c0t4d0s1 16403116 16235220 3865 100% /data7
/dev/dsk/c0t0d0s7 10361628 9664815 593197 95% /export/home
/export/home/oracle 10361628 9664815 593197 95% /home/oracle

pls cfm the reason...eventhough we have 14gb free space in patricular partition at o/s level.

thank you
kesavan.
Re: Unable to create tablespace [message #385199 is a reply to message #385197] Sat, 07 February 2009 07:11 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Oracle : Intel SVR4 UNIX Error: 28: No space left on device

You : eventhough we have 14gb free space in patricular partition at o/s level.


in 99.9 percent of cases Oracle is right.

1) /data7 is full. Maybe there are some temp datafiles there that oracle would need to create a new tablespace
2) You create a datafile in "/data 2 5/", which isn't really mounted extra so it would wind up on /dev/dsk/c0t0d0s0 which has't enough free space it seems.

But it's hard to tell since the unformatted df -k output is basically impossible to read. Post it code - formatted in the future. ( Read the forum guide on how to )
Re: Unable to create tablespace [message #385292 is a reply to message #385199] Mon, 09 February 2009 00:28 Go to previous messageGo to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,

there is no partition "/data 2 5/" mounted in the system..
when we just cut and paste the tablespace creation syntax from notpead to SQL PROMPT,
the no.2 has generated due to line wrapping...sorrry for the incon(.) in this case....

Further we tried to create the same tabelspace in /data4 partition also as it has more space ( around 15gb )
but , we get the same error....

pls adv.

for your reference, formatting the "df -k" outupt....

$ df -k
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/dsk/c0t0d0s0    5063990 1222116 3791235    25%    /
/proc                      0       0       0     0%    /proc
fd                         0       0       0     0%    /dev/fd
mnttab                     0       0       0     0%    /etc/mnttab
swap                 2257856       8 2257848     1%    /var/run
swap                 2257860      12 2257848     1%    /tmp
/dev/dsk/c0t1d0s0    17653246 12423740 5052974    72%    /data1
/dev/dsk/c0t2d0s0    18579609 8914003 9479810    49%    /data2
/dev/dsk/c0t3d0s0    16774585 1300046 15306794     8%    /data4
/dev/dsk/c0t2d0s1    16403116 13522507 2716578    84%    /data3
/dev/dsk/c0t4d0s0    18579609 13473379 4920434    74%    /data6
/dev/dsk/c0t3d0s1    16774585 1687748 14919092    11%    /data5
/dev/dsk/c0t4d0s1    16403116 16235220    3865   100%    /data7
/dev/dsk/c0t0d0s7    10361628 9664815  593197    95%    /export/home
/export/home/oracle  10361628 9664815  593197    95%    /home/oracle


thank you,
kesavan.

[Updated on: Mon, 09 February 2009 00:45] by Moderator

Report message to a moderator

Re: Unable to create tablespace [message #385303 is a reply to message #385292] Mon, 09 February 2009 00:47 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I recommend you to execute a fsck on your disks (c0t3d0) if you are sure you have space enough.

Regards
Michel
Previous Topic: Move an entire instance
Next Topic: LWGR - when will trigger DBWR ?
Goto Forum:
  


Current Time: Sat Dec 03 22:14:37 CST 2016

Total time taken to generate the page: 0.05746 seconds