An error occurred during Oracle logon, which prevented the user from logging on

An error occurred during Oracle logon, causing the user to be unable to log on with the following error

-------------------------------------------------------------------------

ORA-00604: A recursive SQL Level 1 error occurred

ORA-01653 table sys.aud$ cannot be extended by 1024 (in tablespace system)

ORA-02002: Error writing audit trail

ORA-01653 table sys.aud$ cannot be extended by 1024 (in tablespace system)

-------------------------------------------------------------------------

One of the solutions: scaling. aud$ the size of the table space (log on to Oracle with DBA)

--Query the remaining size of table space FreeSpace

Select Tablespace_name,count (*) as Extends,round (sum (bytes)/1024/1024,2) as mb,sum (blocks) as blocks

From dba_free_space where tablespace_name = ' Audtbs '

GROUP BY Tablespace_name

--Query The total size of the tablespace tablespace

Select Tablespace_name,sum (bytes)/1024/1024 as MB

From dba_data_files where tablespace_name = ' Audtbs '

GROUP BY Tablespace_name

--Query Table space location

SELECT * from dba_data_files where tablespace_name = ' Audtbs '

--Change Table space size

ALTER DATABASE datafile ' D:\App\ADMINISTRATOR\ORADATA\ORCL\AUDTBS_01.DBF ' resize 5524M

Complete, log in again.

An error occurred during Oracle logon, which prevented the user from logging on