Oracle

ORA-01655: unable to extend cluster SYS.SMON_SCN_TO_TIME_AUX

While we were checking our Alert.log for possible error, we noticed that there was an error that was saying that our tablespace was having a lack of space:

———-
Errors in file /u01/install/PROD/11.2.0/admin/TEST_DBMACHINE/diag/rdbms/test/TEST/trace/TEST_smon_1166.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.SMON_SCN_TO_TIME_AUX by 128 in tablespace SYSAUX
Wed Mar 11 11:36:24 2015

Solution:

We added a datafile to the system in order to add more space to the tablespace:

The following is the sql:

—————–
ALTER TABLESPACE SYSAUX ADD DATAFILE
‘/u01/oracle/PROD/data/sysaux03.dbf’
SIZE 1024M
AUTOEXTEND ON
NEXT 50M
MAXSIZE UNLIMITED;

ref : Tablespace Clauses:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_3002.htm#SQLRF01002

Advertisements
Standard

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s