[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 746
  • Last Modified:

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.
0
ajaybelde
Asked:
ajaybelde
1 Solution
 
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
 
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
 
slightwv (䄆 Netminder) Commented:
Before you just create a new undo tablespace:

What happened since the last time the database 'worked'?
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now