switchover tnsnames client
I have created primary and standby database, and both are working perfectly fine, when I performed switchover, I am having one issue.
The client users can not access the database The reason they have only one primary database entry in tnsnames.ora file, when I added one entry for standby in one users tnsnames file, the user can access the database sucessfully.
primary------ machine: test9 sid: primary
standby------machine: standby sid: standby
-----------------------------------------------------
What should we do ? Do i need to modify/add new entry in all users/clients TNSNAMES.ora file ? or there is anyother parameter what we need to set ?
Waiting for reply.