Sir,
I have implemented asynchronous replication on 2 database located in 2
different system. I did it with Replication Management GUI Tool.
Before explaining the error i will explain my replication environment.
The details of the systems are
Hostname1- node2 Hostname2- node3
ip address- 192.168.0.232 id adress- 192.168.0.236
DB name- apple DB name- ibm
OS- Red Hat Linux 9
Master Group is named 'HA' and it contains some tables and views of HR
and other users.The replication system works very fine with the above
mentioned naming. I can see synchronisation of data to be completed in
few seconds.
Here is my Test Case... I changed the ip address of the two system to
192.168.0.25 and 192.168.0.30 respectively. i changed the hostname
field in the Oracle Net Manager (as I use ip address in place of
hostname) with respect to Service Naming & Listener's listening
Locations. I started the Listener in each system for their respective
DB. I took OEMAPP CONSOLE. I logged in as the replication user
/propagator. i expanded Distributed>Adv anced Replication
choosing Administration) diagram between two systems. The Dark Black
Line changed to Red Doted Line indicating that link has been broken.
Can you guide me..about the problem. I cant rectify, Wat the problem
is? Why is it so. What all Oracle files use IP address?
I have verified the database availability of "apple" and "ibm" by
'Test' button in the Oracle Net Manager. The result was .. 'The Test
is Successful'. This shows two system have link What else could be the
fault ?
pls do give suggestions...
regards
Cherrish Vaidiyan
I have implemented asynchronous replication on 2 database located in 2
different system. I did it with Replication Management GUI Tool.
Before explaining the error i will explain my replication environment.
The details of the systems are
Hostname1- node2 Hostname2- node3
ip address- 192.168.0.232 id adress- 192.168.0.236
DB name- apple DB name- ibm
OS- Red Hat Linux 9
Master Group is named 'HA' and it contains some tables and views of HR
and other users.The replication system works very fine with the above
mentioned naming. I can see synchronisation of data to be completed in
few seconds.
Here is my Test Case... I changed the ip address of the two system to
192.168.0.25 and 192.168.0.30 respectively. i changed the hostname
field in the Oracle Net Manager (as I use ip address in place of
hostname) with respect to Service Naming & Listener's listening
Locations. I started the Listener in each system for their respective
DB. I took OEMAPP CONSOLE. I logged in as the replication user
/propagator. i expanded Distributed>Adv anced Replication
>Administration . It took few seconds to refresh the Topology(on
Line changed to Red Doted Line indicating that link has been broken.
Can you guide me..about the problem. I cant rectify, Wat the problem
is? Why is it so. What all Oracle files use IP address?
I have verified the database availability of "apple" and "ibm" by
'Test' button in the Oracle Net Manager. The result was .. 'The Test
is Successful'. This shows two system have link What else could be the
fault ?
pls do give suggestions...
regards
Cherrish Vaidiyan