My Oracle Support Banner

Creating Logon Trigger On Primary Database We Get Errors On Physical Standby ORA-604 ORA-1552 (Doc ID 785885.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Generic (Platform Independent)
Oracle Server Enterprise Edition - Version: 9.0.1.0 to 11.2.0.1.0



Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Schema: ORA_AUDIT
Table Name: LOG_AUDIT_SESS_INFO
Trigger Name: LOG_AUDIT_SESS_INFO

************

-- Problem Statement:
Following error occurs when logon trigger attempt to modify the data in physical standby database when database in READONLY mode.
ORA-604: error occurred at recursive SQL level 1
ORA-1552: cannot use system rollback segment for non-system tablespace

Changes

Write an on-logon trigger in primary database, which inserts/modify data of tables.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.