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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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)

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Kill the processes.
But it's surprising you can't remove file in the AUDIT FILE SYSTEM.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 09:13:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.