Adding another dispatcher for xml db when there is one dispatcher already existing
I have an xml db install problem. The problem is as follows:
I have a running oracle 10.2.0.4 database on HP-UX 11.2.3 OS. My oracle database does not contained xml db as of now. It was an upgraded database from 8.1.7 to 10.2.0.4 recently. It is working fine since its upgrade in April 2010. Now we need to install xml db component on it. We have test installed it on our test databases, and find working good. When it comes to Production Database, problem arises when adding the following entry to pfile.
dispatchers="(PROTOCOL=TCP) (SERVICE=<sid>XDB)"
In case of our test databases, I have simply added this dispatcher entry just like the above line at the end of test database pfile.