Creating Logon Trigger On Primary Database We Get Errors On Physical Standby ORA-604 ORA-1552
(Doc ID 785885.1)
Last updated on DECEMBER 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [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: 220.127.116.11 to 18.104.22.168.0
***Checked for relevance on 21-JAN-2013***
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:
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
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