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/install/PROD/data/sysaux03.dbf'
SIZE 1024M
AUTOEXTEND ON
NEXT 50M
MAXSIZE UNLIMITED;
---------------
References:
1- Tablespace Clauses:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_3002.htm#SQLRF01002
2- Unable To Extend Error
https://community.oracle.com/thread/950421
Do you realize there's a 12 word sentence you can speak to your partner... that will induce intense emotions of love and impulsive attractiveness for you deep within his heart?
YanıtlaSilBecause deep inside these 12 words is a "secret signal" that triggers a man's impulse to love, please and guard you with all his heart...
12 Words That Trigger A Man's Desire Response
This impulse is so built-in to a man's mind that it will make him try better than ever before to take care of you.
Matter of fact, triggering this influential impulse is absolutely important to achieving the best possible relationship with your man that the second you send your man one of these "Secret Signals"...
...You'll soon notice him expose his heart and mind for you in a way he never expressed before and he'll see you as the one and only woman in the galaxy who has ever truly fascinated him.