Home » RDBMS Server » Server Administration » Problem with Undo tablespace.
Problem with Undo tablespace. [message #253445] Tue, 24 July 2007 00:44 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

My Undo tablespace takes 3 GB space. In my drive no space is left.
ERROR:
ORA-09817: Write to audit file failed.
Solaris-AMD64 Error: 28: No space left on device
ORA-01075: you are currently logged on

So, I could not enter as sysdba into database.How I can clear my undo tablespace.
Re: Problem with Undo tablespace. [message #253448 is a reply to message #253445] Tue, 24 July 2007 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Make space on the device.
The current problem (the one you display) comes from auditing SYS.
There is no relation with UNDO.

Regards
Michel
Re: Problem with Undo tablespace. [message #253471 is a reply to message #253445] Tue, 24 July 2007 01:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Ok, No relation. How I can make free space in my drive by clearing undo tablespace. ( Until I restart if I delete any file by rm command then it still shows no space remaining)
Re: Problem with Undo tablespace. [message #253500 is a reply to message #253471] Tue, 24 July 2007 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove other files. I can't see what's inside your file system.
Quote:
it still shows no space remaining

But maybe there is or maybe not, don't know which command you execute.

In the end, shut down the database.

Regards
Michel
Re: Problem with Undo tablespace. [message #253504 is a reply to message #253500] Tue, 24 July 2007 02:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:


In the end, shut down the database.

Regards
Michel



How? I cant enter by issuing as sysdba.

[Updated on: Tue, 24 July 2007 03:12]

Report message to a moderator

Re: Problem with Undo tablespace. [message #253505 is a reply to message #253504] Tue, 24 July 2007 02:37 Go to previous message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Kill the processes.
But it's surprising you can't remove file in the AUDIT FILE SYSTEM.

Regards
Michel
Previous Topic: upgrading 9206 to 9207
Next Topic: Materialized View
Goto Forum:
  


Current Time: Tue Dec 06 02:27:30 CST 2016

Total time taken to generate the page: 0.17128 seconds