ORA-00257

Error

Archiver error. Connect internal only, until freed.

Issue

There is no longer any space for the archive logs to write to.  This is either caused by running out of disk space or by db_recovery_file_dest directory being filled to db_recovery_file_dest_size.

Resolution

Make sure there is free disk space on the file system where Oracle is installed.  If there is then check the db_recovery_file_dest  and db_recovery_file_dest_size parameters by:

sqlplus /nolog
SQL> connect / as sydba
SQL> show parameters db_recovery_file_dest

To increase the db_recovery_file_dest_size to 20G issue the following SQL:

SQL> alter system set db_recovery_file_dest_size=20G scope=both;

If the db_recovery_file_dest directory is full, check to see if the backups are running and that they are deleting the old archive logs properly.

ORA-01653

Error

Unable to extend table <table name> by <size> in tablespace <tablespace name>

Issue

The tablespace the table is residing in is unable to extend.  The cause of this error is because of the datafile is full and autoextend is turned off or there is not enough disk space on the file system.

Resolution

Check the datafiles attached to the tablespace and whether or not the tablespace is allowed to autoextend.

sqlplus /nolog
SQL> connect
SQL> select file_name, bytes, autoextensible, maxbytes
     from dba_data_files
     where tablespace_name='TABLESPACE_NAME'

To enlarge the datafile:

SQL> alter database datafile '<loaction of datafile>' 
     resize <size>;

To set the autoextensible flag on:

SQL> alter database datafile '<location of datafile>' 
     autoextend on next <size> maxsize <maximum size>; 

For example, to increase the size of tablespace SYSTEM and turn on autoextend:

SQL> alter database datafile 'C:\oraclexe\oradata\xe\SYSTEM.dbf'
     resize 1G;
SQL> alter database datafile 'C:\oraclexe\oradata\xe\SYSTEM.dbf' 
     autoextend on next 100m maxsize 2G;