OraFAQ Forum: Server Administration » Problem with Undo tablespace.

Home » RDBMS Server » Server Administration » Problem with Undo tablespace.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with Undo tablespace. [message #253445]

Tue, 24 July 2007 00:44

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Problem with Undo tablespace. [message #253471 is a reply to message #253445]

Tue, 24 July 2007 01:27

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Problem with Undo tablespace. [message #253504 is a reply to message #253500]

Tue, 24 July 2007 02:35

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:58:02 CDT 2024