Oracle Database Discussions

Hello Guru´s

i have one master database running oracle 11.2.0.1 on uniix hpux. clients have tnsnames to run the application that use this database.

tns is like this:

Prod.appmill.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1522))
)
(CONNECT_DATA =
(SID = prod)
)
)


the standby database is running in another server ip = 192.168.30.25 and the standby database have different ORACLE_SID = prodmill.

when we activate the standby i have to update tns to all clients to run application. i´d like to have this automatic with multiple entries in tns for both servers and both SID then when master site whent down, we open the standby and application will back to work just need maybe close and open again.

thanks for your help.

br