Home » RDBMS Server » Server Administration » ORA-12801 error
ORA-12801 error [message #276368] Thu, 25 October 2007 00:49 Go to next message
neelabh_SE
Messages: 20
Registered: October 2007
Junior Member

Hello,

I'm getting the below error. Please help!
I would like to know the cause and possible solution.

Database error:
ORA-12801: error signaled in parallel query server P002
ORA-01114: IO error writing block to file 202 (block # 1737481)
ORA-27072: File I/O error
Linux Error: 28: No space left on device Additional information: 4 Additional information: 1737481 Additional information: -1
ORA-01114: IO error writing block to file 202 (block # 1737481)
ORA-27072: File I/O er .

The background is it is a Oracle 10g DB server.

thanks
neel

Report message to a moderator

Re: ORA-12801 error [message #276373 is a reply to message #276368] Thu, 25 October 2007 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:

No space left on device

Regards
Michel

Report message to a moderator

Re: ORA-12801 error [message #276375 is a reply to message #276368] Thu, 25 October 2007 01:11 Go to previous messageGo to next message
neelabh_SE
Messages: 20
Registered: October 2007
Junior Member
Yes actually I just checked the filesystem.
One of the file system is full.

Also I happen to check the temporary tablespace which is on same filesystem( one got full). The tablespace utilization is 0 but respective datafiles are completely full.( I use OEM to view the details).
How can i reduce the size of datafiles, if i can or what could be the possible solution?

neel

[Updated on: Thu, 25 October 2007 01:11]

Report message to a moderator

Re: ORA-12801 error [message #276381 is a reply to message #276368] Thu, 25 October 2007 01:17 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Quote:

How can i reduce the size of datafiles


alter database .. resize clause.

Either keep autoextend off or give bound to maxsize.

Report message to a moderator

Re: ORA-12801 error [message #276382 is a reply to message #276368] Thu, 25 October 2007 01:22 Go to previous messageGo to next message
neelabh_SE
Messages: 20
Registered: October 2007
Junior Member
Actually i wanted to ask how can i resize the temporary datafiles?
also how can i estimate maximum space ever used of temporary tablespace by transactions?

Report message to a moderator

Re: ORA-12801 error [message #276392 is a reply to message #276368] Thu, 25 October 2007 01:32 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Quote:

wanted to ask how can i resize the temporary datafiles?

same procedure,

Alter database tempfile location_from_querying dba_temp_files resize your_size;

Report message to a moderator

Re: ORA-12801 error [message #276401 is a reply to message #276382] Thu, 25 October 2007 01:55 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't do it now.
You have to follow your system but it is not easy to get the real temporary space used.

By the way, space utilization from grid or this kind of tools is meaningless for temporary tablespace/files.

Regards
Michel

[Updated on: Thu, 25 October 2007 01:56]

Report message to a moderator

Previous Topic: Optimum value of Temporary tablespace Oracle 10g
Next Topic: ORA-00201:While trying to mount DB
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 07:15:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.