ORA-01628: max # extents (32765) reached for rollback segment _SYSSMUxxx

Recently I came across "ORA-01628: max # extents (32765)" error. The database had resumable_timeout parameter set I received page for a session in resumable state. Looking into the alert log showed statement in resumable session 'User USER_E3(375), Session 9028, Instance 1' was suspended due to ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU375_247595031$ … Continue reading ORA-01628: max # extents (32765) reached for rollback segment _SYSSMUxxx

Advertisement

ORA-17629 ORA-20079

Yesterday I received page for " ORA-17629: Cannot connect to the remote database server"  reported in Primary Database alert log. Fri Apr 10 06:47:41 2015 Errors in file /oracle/app/diag/rdbms/testdb/testdb/trace/testdb_ora_161991.trc: ORA-17627: ORA-17629: Cannot connect to the remote database server Errors in file /oracle/app/diag/rdbms/testdb/testdb/trace/testdb_ora_161991.trc: ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-17629: Cannot connect to … Continue reading ORA-17629 ORA-20079