HI people. I would like to share with you a strange situation for me which it might make sense for you.
I have a production cluster database 10.2.0.4 no asm(proddb), which before was configured for oracle streams.And i have the same enviroment on the dr site With different db_name (drdb). The drdb was not working at all so i deleted all the datafales from aix and cotrol files as well. I created standby control file from proddb from sqlplus and i copied to the path on the dr site that it was supposed to be. Then i created a pfile from proddb i copied it to drdb server and then i edit it to make the changes needed. DB_UNIQUE_NAME parameter was not in the pfile( I am assuming the reason is because was never alterred to spfile on proddb and it was using the db_name as unique name as well).So i didnt add unique name parameter for the drdb and the db_name i left it the same as on production db.Then when i mounted the standby db with pfile modified production database was not aacepting connections from any 3rd party applications. I could connect on the prodb from sqlplus and do queries.alert log shows no errors. Then i shutdown drdb i insert db_unique_name =drdb and then started on mount again the drdb from that pfile and proddbworks perfect.
Does this sounds reasonable for you?
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?
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)