| Unable to create tablespace [message #385197] |
Sat, 07 February 2009 05:57  |
kesavansundaram
Messages: 183
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  |
ThomasG
Messages: 3211
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 |
kesavansundaram
Messages: 183
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
