SOmething that i forgot to mention is that both of them ate using different listeners
If the standby is mounted I would expect this:
ORA-01219: database not open: queries allowed on fixed tables/views only
or are you asking a streams question in the Data Guard forum??
if yes your question should be here:
What else is different about your test?
.i just mentioned streams.i cant see of any other difference as i deleted all datafiles on the dr from the db and used only the same tnsnames.ora and listener.ora
HOw possible is to mount dr database with the pfile without adding the unique name and the production db stops accepting connections from 3rd party applications???
This does not make sense to me. The only thing that comes to mind is "Protection Mode" and that Maximum Protection is set. But I would expect the Primary to shut down then.
I did see this:
PPM Console Drops Primary DB Connection (Doc ID 1458949.1)
E-AS: DBFlags=8 Sometimes Gives Intermittent ORA--00022 (Doc ID 1277904.1)
For me is very strange as well thats why i wanted to share it in the forum To see if anyone else has an idea of what it it it it could be