Hi all, have an issue hopefully someone can help with. Many thanks in advance!
We have a setup where our production has primary (live) and backup (DR) databases. Every 6 months or so we switch between them and ideally a TNS setup should be able to cope with this without needing to be changed. There is a single TNS entry for PROD which has references to both these databases and in theory it should check the first one and if it is active it'll connect to it. If it's not active (because it's in DR) it should move onto the second which should be primary.
The problem is that our DR database isn't fully shutdown, we're getting an ORA 1033 (shutdown or restart in progress). Don't know why this is but we can't change it. In order to resolve this we must (in order of preference) -
1) Alter the TNS so it ignores half shutdown databases - I have no idea if this is even feasible
2) Point the TNS at the primary database and switch it around every time we swap primary and DR around
3) Remove the TNS entry which will cause a minor issue (only affects small part of the application)
So really I'm hoping someone can provide an answer to 1) or we'll have to go for 2).
Cheers.