Hello, thanks to reply, can you provide a sample based on my tns above and informations regarding servers ip and oracle_sids used for master and standby ?
still not clear for me.
799458 wrote:As Robert said, don't use SID, use SERVICE_NAME.
Hello, thanks to reply.
that´s the doc i was reading since before i made the post here.
about address i think i understood , but what about SID ? as i said my standby database has a different SID from Master database, and this is what i´m struggling with.
thanks a lot for your help.
Edited by: 799458 on Feb 11, 2013 12:34 PM
Edited by: EdStevens on Feb 11, 2013 2:58 PM
FUBAR = (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS=(PROTOCOL = TCP)(HOST = myprimary)(PORT = 1521)) (CONNECT_DATA= (SERVICE_NAME=FUBAR_PRI))) (DESCRIPTION= (DESCRIPTION= (ADDRESS=(PROTOCOL = TCP)(HOST = mysecondary)(PORT = 1521)) (CONNECT_DATA= (SERVICE_NAME=FUBAR_SEC)))