Home » Server Options » Data Guard » ora-1552 (Oracle 10.2.0.4 AIX 6L )
ora-1552 [message #497810] Mon, 07 March 2011 05:38 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hello Experts,

I have configured physical standby database successfully but when open the database in read only mode after cancel the log apply service and trying to connect with other than sys user it prompt error "ora-1552".

It is working fine when i open the database in read only mode. Please suggest for further action need to be done.

Revert will be humbly awaited.
Regards,
Jay vardhan.
Re: ora-1552 [message #497812 is a reply to message #497810] Mon, 07 March 2011 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think we know ALL error codes by heart?
ALWAYS post the complete error message:
ORA-01552: cannot use system rollback segment for non-system tablespace '%s'
 *Cause: Tried 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), shutdown and then
           startup again. May need to modify the INIT.ORA parameter
           rollback_segments to acquire private rollback segment. If this is
         a clone database being used for tablspace point in time recovery
         then this operation is not allowed.  If the non-system tablespace
         has AUTO segment space management, then create an undo tablespace.


It is not clear what you can do and what you can't.
ALWAYS copy and paste your SQL*Plus session, the WHOLE session.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Re: ora-1552 [message #497831 is a reply to message #497812] Mon, 07 March 2011 07:18 Go to previous messageGo to next message
John Watson
Messages: 8347
Registered: January 2010
Location: Global Village
Senior Member
You could check for any logon trigger that tries to write to the database, also whether there is any auditing. 11.2 is clever enough to adjust the audit_trail parameter to OS when you open read only, I don't know if 10.2 could do that.
Re: ora-1552 [message #497833 is a reply to message #497831] Mon, 07 March 2011 07:25 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Having get this error a couple of times, I can tell you: no, it does not.

Regards
Michel
Re: ora-1552 [message #497835 is a reply to message #497833] Mon, 07 March 2011 07:54 Go to previous message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks for the update.

I apologize for the mistake. I will take care of in future.

Jay vardhan
Previous Topic: 11.1.0.7 RAC prmary to single instance standby using 11.1.0.6
Next Topic: Physical standby configuration
Goto Forum:
  


Current Time: Fri Sep 25 18:35:53 CDT 2020