Category Archives: oraerror

Solution to: ORA-1691: unable to extend lobsegment

This ORA happens allways a lob segement cannot extended itself to fit the new data being inserted.
Tipical solution is extending the data file and adding a datafile, but sometimes, not often, error only apears in alert log (no client side) when space taken by the lob segment is allocated for reuse, before the undo retention period is expired.

Continue reading


Solution to: ORA-01555: snapshot too old


Many times like all Oracle DBAs have face with this problem sometimes is easy avoid sometimes you discover for example that table have LOBS and this LOBs dont use the UNDO tablespace and datbase UNDO_RETENTION parameter and have his own paramter and stores  undo on data tablespace.

This problem can cause a lot of waste time because it is more likely to occur when you are running long queries so the return to process them again will be a big waste of time.

Continue reading

ORA-12518: TNS:listener could not hand off client connection

Today in a multiple instance server i configured a new instance on Windows platform and  i encounter next problem when i try connect from my laptop:

sqlplus / as sysdba

SQL*Plus: Release – Production on Sun Aug 26 09:21:56 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.

ORA-12518: TNS:listener could not hand off client connection.

Continue reading