| Unable to extend extent [message #246137] |
Wed, 20 June 2007 01:40  |
kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi
|
Member |
|
|
I have oracle 10gR1 on solaris and database is using ASM. Yesterday i have found the error in alert.log file:
ORA-1653: unable to extend table
ORA-1654: unable to extend index
The error belongs to a particular tablespace TBS01.
The datafile belong to this tablespace is 19GB and autoextend on for this datafile upto 32GB.
I have run the below queries:
SQL> select sum(bytes/1024/1024/1024) from dba_segments;
SUM(BYTES/1024/1024/1024)
-------------------------
994.232666
SQL> select sum(bytes/1024/1024/1024) from dba_free_space;
SUM(BYTES/1024/1024/1024)
-------------------------
212.42511
I have 39 disk of 32GB each for ASM. So the size of ASM is 32x39=1248GB.
SQL> select sum(free_mb/1024) from v$asm_diskgroup;
SUM(FREE_MB/1024)
-----------------
0
SQL> select sum(free_mb/1024) from v$asm_disk;
SUM(FREE_MB/1024)
-----------------
0
But still it is showing this error. I am unable to find out the cause for this issue.
Please tell me the resolve the issue.
Thanks in Advance.
|
|
|
|
|
|
| Re: Unable to extend extent [message #246144 is a reply to message #246137] |
Wed, 20 June 2007 01:55  |
kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi
|
Member |
|
|
The message in alert.log file is
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:13:54 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:13:58 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:15:00 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:15:01 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
Wed Jun 20 01:15:13 2007
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 128 in tablespace TBS01
ORA-1653: unable to extend table METAINFODB.SI_LINE_INFO by 8192 in tablespace TBS01
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
