ORA Oracle common errors and Solutions

ORA-01650: unable to extend rollback segment NAME by NUM intablespace NAME

causes:

ORACLE errors for rollback segment space are caused due to lack of ORACLE error information that is most common ORACLE data administrator.

Solution:

Use “ALTER TABLESPACE tablespace_name ADD DATAFILE filename SIZE size_of_file” command to increase surface space of the specified data as per the specific situation can be increased by one or more table space. It is also related to the host on bare disk device if you host a bare disc device that don’t have spare space then it is advised to increase rollback segment size. To do so use the following statement:

Select user_name,sql_text from V$open_cursor where user_name='<user_name>’;

If the extra space is more than it can be appropriate to add large rollback segment to the table space to avoid this error. To detect use the following statement

Rollback segment competition:

Choose class,count from V$waitstat where calss in(‘system undo header’,’

system undo block’,’undo header’,’undo block’);

And

Choose sum(value) from V$sysstat where name in (‘db_block_gets’,’consistents gets’);

If any of the class in count/sum (value) greater than 1%, then consider adding rollback segment.

ORA-00600: internal error code, arguments:[num],[?],[?],[?],[?]

Causes:

This error message is an internal error ORACLE which is found in OSS and ORACLE development. ORA-600 errors are accompanied by the state dump trace file (system state and process of the state). The system state include current object storage ORACLE RDBMS that store the data. The process of the state dump is to display object holds special process. When process is in line with the conditions of mistake which is because some information from it’s holdings of block. If you come to know the error process-holding block then it is quite easy to trace source of the problem.

Solution:

In general this error is not itself solved just by improving the system to fix internal problems like increasing the hardware device, adjusting system performance, use of OPS. First variable of ORA-600 error for wrong position marking codes from the second to fifth variables to show additional details is said to be due to wrong OSS code.

Examples:

ORA-00600: internal error code, arguments: [1237], [], [], [], [], [], [], []

ORA-03113: end-of-file on communication channel

Causes:

Communication isn’t the normal end, resulting the termination of communication channel

Solution:

1>.Check whether there is an abnormal wear process crashes ypou can check that from alert.log

2>.Check whether sql*Net Driver is connected to ORACLE executable program

3>.Check whether server network is normal like network access or unstable

4>.Node checks same online of the same name

5>.Check same online with duplicate IP address

Well I have mentioned only few Oracle common errors and Solutions but there many others that stop you from accessing your oracle database.