Re: ORA Errors

hi,

believe me i am not trying to patronize you, but the best way to diagnose oracle errors is to read the error code and description and any errors in the alert log, then look at the error messages manual which often expands on this,

http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76999/toc.htm

then to read the relevant section in either the concepts manual;

http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76965/toc.htm

or the specific manual relating to the problem...

so for example, your errors are; ORA-01562 & ORA-01650

so we read the error desc and see we tried to extend the 5th rollback segment and we failed
also the next error gives us some detail, ie; the rollback seg in question is called R04 and it lives in RBSB

so lets look the errors up;;
ORA-01562 failed to extend rollback segment number string

Cause: Failure occurred when trying to extend rollback segment.

Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintenance. Use SELECT SEGMENT_NAME FROM DBA_ROLLBACK_SEGS WHERE SEGMENT_ID=string (where string is the segment number from the message) to determine the rollback segment name. Then use the ALTER ROLLBACK SEGMENT OFFLINE command to take the rollback segment offline.

and;
ORA-01650 unable to extend rollback segment string by string in tablespace string

Cause: Failed to allocate an extent for rollback segment in tablespace.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

so now lets go read about rollback segs just in case;

http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76965/c02block. htm#8401

and then about space in tablespaces;

http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76965/c03space. htm#4346

you may then want to read the oracle administrators guide

about managing rollback segs;

http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76956/rollbak.h tm#414

and managing tablespaces;

http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76956/tspaces.h tm#544

you will then have the knowledge to fix the problem and prevent it again; if its a horrible complex thing then search the web using google and or post here where you will find a host of friendly oracle people...

good luck...

--
Regards,

Daniel.


"Casey J. Ratliff" <cratliff_at_adaytum.com> wrote in message
news:dfd9ec3.0203271109.12c483e9_at_posting.google.com...


> All:

>

> I have an application I work with that often has multiple different

> ORA- 2222 errors like:

>

> ORA-01562: failed to extend rollback segment number 5

> ORA-01650: unable to extend rollback segment R04 by 640 in tablepsace

> RBSB

>

> And many more.  Is there a listing of the error codes for reference

> somewhere?  Is there a trouble shooting technique I can use for these?

>

> Thanks in Advance!

>

> Casey