users can not login into the database

Enter user-name: ap@IAQ
Enter password:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
ORA-06512: at line 6


They are getting this error

please provide me with some solution.
ajaybeldeAsked:
Who is Participating?
 
schwertnerCommented:
https://forums.oracle.com/forums/thread.jspa?threadID=308187

ORA-01552 cannot use system rollback segment for non-system tablespace 'string'

Cause: An attempt was made to use the system rollback segment for operations involving non-system tablespace. If this is a clone database then this will happen when attempting any data modification outside of the system tablespace. Only the system rollback segment can be online in a clone database.

Action: Create one or more private/public segment(s), shut down and restart. May need to modify the initialization parameter ROLLBACK_SEGMENTS to acquire private rollback segment. If this is a clone database being used for tablespace point in time recovery then this operation is not allowed.


Or:


Incorrect AUDIT_TRAIL Parameter Setting
This problem may return error messages similar to the following:

ORA-00604: error occurred at recursive SQL level string
ORA-01552: cannot use system rollback segment for non-system tablespace
'string'
ORA-02002: error while writing to audit trail


You will encounter these errors only under the following conditions:

The AUDIT_TRAIL initialization parameter is set to either DB or to TRUE
The SYS.AUD$ table is located in a tablespace other than SYSTEM
To correct this problem, complete the following steps:

Shut down the database if it is running.
Set the AUDIT_TRAIL initialization parameter in the initialization parameter file in the following way:
AUDIT_TRAIL = NONE


 
 
 

0
 
sdstuberCommented:
you need to create an undo (rollback) tablespace


for example....

CREATE UNTO TABLESPCE YOUR_UNDO DATAFILE '/your/path/undo.dbf' SIZE 300M AUTOEXEND ON NEXT 100M MAXSIZE UNLIMITED
ONLINE RETENTION NOGUARANTEE BLOCKSIZE 8K FLASHBACK ON;


adjust path, sizing and other parameters as appropriate for your instance
0
 
slightwv (䄆 Netminder) Commented:
Before you just create a new undo tablespace:

What happened since the last time the database 'worked'?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.