OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » ora-1552 (Oracle 10.2.0.4 AIX 6L )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-1552 [message #497810]

Mon, 07 March 2011 05:38

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.

Report message to a moderator

Re: ora-1552 [message #497812 is a reply to message #497810]

Mon, 07 March 2011 05:42

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ora-1552 [message #497831 is a reply to message #497812]

Mon, 07 March 2011 07:18

John Watson
Messages: 8979
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.

Report message to a moderator

Re: ora-1552 [message #497833 is a reply to message #497831]

Mon, 07 March 2011 07:25

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Having get this error a couple of times, I can tell you: no, it does not.

Regards
Michel

Report message to a moderator

Re: ora-1552 [message #497835 is a reply to message #497833]

Mon, 07 March 2011 07:54

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

Report message to a moderator

Previous Topic:	11.1.0.7 RAC prmary to single instance standby using 11.1.0.6
Next Topic:	Physical standby configuration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 10 17:20:27 CDT 2025