Re: ora 6550 error

Rick Kramer wrote:
>
> Hello out there,
> I am in need of some assistance with an export problem.
> Nightly, I have a cron job that runs a oracle export of the
> entire database. This database is a development playground so,
> we are not running log archive and the database could be restored
> from last weeks backup if neccesary. However, the last few nights
> I have received the following errors:
>
> EXP-00008: ORACLE error 6550 encountered
> ORA-06550: line 0, column 0:
> PLS-00801: internal error [76180]
> EXP-00222:
> System error message 2
>
> these errors have not occurred in a consistent fashion: meaning
> they are happening at different points in the backup process each night.
>
> Rick Kramer
> Database Administrator
> Ford Motor Co.

The main error causing all the errors in the stack is the System error message 2 at the end. This is some sort of Operating System error. You should check your Oracle Installation Manual for your OS to see what this error message means. A guesses at what it might be.

The error could be cause by insufficient disk space or user disk space quotas. I have also had problems before where the maximum file size that a regular joe user (ie. not root) could create was limited to a few MB (using ulimit I think) and this caused things to die whenever they hit that limit.

I hope this helps.

-- 
-------------------------------------------------
Ken Johnson -  Senior Technical Consultant
Tapestry Computing, Inc. http://www.tapestry.com