ORA-00604: error occurred at recursive SQL level1ORA-16000: database openforread-only access 怀疑是触发器导致的问题,自己的测试环境进行测试。 测试一、dg环境开启审计参数是否影响 [oracle@adg1 dbs]$ sqlplus tt/tt@adgtns SQL*Plus: Release11.2.0.4.0Production on Sat May416:56:552019SQL>audit_tr...
在DG中对primary增加tempfile不会同步到standby上,所以增加tempfile需要在standby上操作,但这次在standby上增加tempfile却报错ORA-00604 ORA-16000 (mount状态,MRP cancel 报错依旧)。 分析: 这里ORA-00604通常是trigger在影响,因为时间紧迫没有做10046 trace,直接查询官方得到权威解释。 原来是因为DB安装了OGG其中trigger...
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]: Unable to connect to read only database, Getting error ORA-00604 ORA-16000
In a standby environment this could also be: Bug 7581964 - Incorrect login to primary causes ORA-16000 on login to standby database Applying the fix for bug 7581964 may resolve the issue.
近日一套dataguard 物理备库使用rman备份恢复 迁移到新的服务器上,数据库只读打开开启同步后 ,由于备库还承担查询业务,手动添加临时表空间临时文件报如下错误: 按道理说物理备库是可以增加临时表空间临时文件的,怀疑是bug,查找mos ,发现有如下文档说明: 主库有配置ogg
触发器引起的删除对象报错ORA-00604 ORA-20001的排查,近期,某客户反馈应用厂商在数据库维护时,出现视图不能删除问题。检查报错信息后,初步判断可能是账户权限或触发
ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access 00604. 00000 - "error occurred at recursive SQL level %s" *Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables). *Action: If ...
ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access 00604. 00000 - "error occurred at recursive SQL level %s" *Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables). *Ac...
Unable to connect to read only database, GettingerrorORA-00604ORA-16000 (Doc ID 461653.1) Applies to: Oracle Server - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]Information in this document applies to any platform.SymptomsA read-only database is cloned fr ...