Archive

Archive for June, 2013

ORA-01536: space quota exceeded for tablespace ‘TBS_VOIP’

June 30, 2013 Leave a comment

1. Tonight, I got error message from the production support. They passed the message below.

ORA-01536: space quota exceeded for tablespace ‘TBS_VOIP’

2. Check user quota on the tablespace, it clearly showed that there was no quota unlimited on the tablespace TBS_VOIP ( since if there is quota unlimited on the tablespace, MAX_Bytes show -1.)

SQL> select * from user_ts_quotas;

TABLESPACE_NAME                     BYTES  MAX_BYTES     BLOCKS MAX_BLOCKS DRO
------------------------------ ---------- ---------- ---------- ---------- ---
TBS_VOIP                        141819904          0      17312          0 NO

3. Then I granted the user with quota unlimted on the tablesapce

SQL> alter user VOIP02  quota unlimited on TBS_VOIP;

SQL> select tablespace_name, username, bytes / 1024 / 1024 “Used MB”,
2  decode(max_bytes,-1,’UNLIMITED’,max_bytes / 1024 / 1024) as “Max MB”
3  from dba_ts_quotas
4  where tablespace_name = ‘TBS_VOIP’ and username = ‘VOIP02’
5  /

TABLESPACE_NAME                USERNAME                          Used MB Max MB
—————————— —————————— ———- —————————————-
TBS_VOIP                       VOIP02                             138.25 UNLIMITED

The problem got fixed.

Advertisements
Categories: ORA-XXX

WARNING: oradism did not start up correctly.

June 25, 2013 Leave a comment

WARNING: ——————————-
WARNING: oradism did not start up correctly.
When starting database instance, the following returned.

Dynamic ISM can not be locked.—————————————-
oradism creation failed for unknown reasons 0 8 100
WARNING: ——————————-
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.—————————————-
oradism creation failed for unknown reasons 0 8 100
WARNING: ——————————-
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.—————————————-
oradism creation failed for unknown reasons 0 8 100
WARNING: ——————————-
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.—————————————-
oradism creation failed for unknown reasons 0 8 100
2013-06-25 17:55:55.804000 +08:00
DISM started, OS id=23152

Finally, I found that the owner of the $ORACLE_HOME/bin/oradism is not root. After changing the owner to root, the problem was fixed

 

Categories: TroubleShooting