No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48742 | | Total active users | 1337 | | Act. users last 24h | 1 | | Act. users last hour | 0 | | Registered user hits last week | 108 | | Registered user hits last month | 471 |
|
Go up
database can't open due to sysaux tablespace is full
| Message |
Score |
Author |
Date |
   when trying to "alter database open", it hangs,
...... |
|
tom hello |
Apr 25, 2023, 18:24 |
|
https://www.google.com/search?hl=fr&source=hp&bi...... |
|
Michel Cadot |
Apr 25, 2023, 18:36 |
| thank you, while I didn't see any right solution f...... |
|
tom hello |
Apr 25, 2023, 18:57 |
|
The first thing to do is to set to FALSE all aud...... |
 |
Michel Cadot |
Apr 25, 2023, 20:26 |
| Thats a good idea.
Also worth noting that a dat...... |
|
Adam Hudspith |
Apr 26, 2023, 17:54 |
|
Any feedback?
... |
|
Michel Cadot |
Apr 27, 2023, 22:02 |
| Subject: |
database can't open due to sysaux tablespace is full |
| Author: |
tom hello, United States |
| Date: |
Apr 25, 2023, 18:24, 38 days ago |
| Os info: |
linux 7 x86_64 |
| Oracle info: |
19c |
| Error info: |
ORA-01688 |
| Message: |
when trying to "alter database open", it hangs,
in alert.log, showing :
ORA-01688: unable to extend table AUDSYS.AUD$UNIFIED partition SYS_P8887 by 8192 in tablespace SYSAUX
Looks like the SYSAUX tablespace is full,
startup mount, then
ALTER TABLESPACE SYSAUX ADD DATAFILE 'xxx' SIZE 200M AUTOEXTEND ON NEXT 20M MAXSIZE 5120M;
*
ERROR at line 1:
ORA-01109: database not open
how to add space to open the database?
Thanks |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: database can't open due to sysaux tablespace is full |
| Author: |
Michel Cadot, France |
| Date: |
Apr 25, 2023, 18:36, 38 days ago |
| Message: |
https://www.google.com/search?hl=fr&source=hp&biw=&bih=&q=%22database+can%27t+open+due+to+sysaux+tablespace+is+full%22
Regards
Michel
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: database can't open due to sysaux tablespace is full |
| Author: |
tom hello, United States |
| Date: |
Apr 25, 2023, 18:57, 38 days ago |
| Message: |
thank you, while I didn't see any right solution for this problem
basically it is a dead loop.
need to open database to add sysaux free space
need to have free space in sysaux to open datase.
hmm, thinking.... |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: database can't open due to sysaux tablespace is full |
| Author: |
Michel Cadot, France |
| Date: |
Apr 25, 2023, 20:26, 38 days ago |
| Score: |
|
| Message: |
The first thing to do is to set to FALSE all audit parameters in init.ora/spfile.
Regards
Michel
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: database can't open due to sysaux tablespace is full |
| Author: |
Adam Hudspith, United Kingdom |
| Date: |
Apr 26, 2023, 17:54, 37 days ago |
| Message: |
Thats a good idea.
Also worth noting that a database can "survive" losing the SYSAUX tablespace, so this situation is surely recoverable.
Can you mount the database? I dont have a test instance at the moment I can (potentially) trash to test on, but a little playing around should see you get part this problem in short time. |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: database can't open due to sysaux tablespace is full |
| Author: |
Michel Cadot, France |
| Date: |
Apr 27, 2023, 22:02, 36 days ago |
| Message: |
Any feedback?
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
|