Database Administration (MOSC)

MOSC Banner

read only dabase login problem

edited Jul 24, 2010 8:00PM in Database Administration (MOSC) 4 commentsAnswered
Hi all,

we have physical standby database. we openned it  read only. 

while users connecting this database  they are getting error below.

ORA-01552: cannot use system rollback segment for non-system tablespace  "AUDIT_TABLESPACE"

SQL> show parameter audit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string     .................
audit_sys_operations                 boolean     FALSE
audit_syslog_level                   string
audit_trail                          string      NONE

What is the problem ?  you have any idea about cause of problem ?

Best Regards....

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center