Re: Cannot Open Physical Standby Read Only
Date: Wed, 8 Dec 2010 09:00:30 -0800 (PST)
Message-ID: <3f549db5-adc7-4a9b-a607-e43e225f342e_at_u9g2000pra.googlegroups.com>
On Dec 7, 11:55 am, Myles <myl..._at_gmail.com> wrote:
>
> *** 2010-12-07 11:09:27.172
> *** SESSION ID:(4.1) 2010-12-07 11:09:27.169
> error 604 detected in background process
> ORA-00604: error occurred at recursive SQL level
You can set the 604 event to find out what it is failing on, check the
trace file.
alter system set events '604 trace name errorstack level 10';
First thing that pops up in MOS is a profile has been set for users. In the Primary, a user failed a login. When a user that has failed a login later succeeds, there is a failed login counter that is reset. So in a standby opened read-only, a successful login attempts to write to this counter, but throws 604 because - well, it should be obvious!
Another obvious thing is a on-logon trigger that does something DML.
And so on...
jg
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2010/dec/06/jacob-calls-investigation-sempra/Received on Wed Dec 08 2010 - 11:00:30 CST