The company I work for has recently purchased a "turn-key solution" that uses Oracle8 as its db. It came preconfigured and partially broken (no functioning sqlplus, netasst, perl), most likely to keep us out of it. I need to connect to the db to sync it with our existing mysql db. I have managed to connect to the db with a simple java program. The problem is, it only listens on localhost and I want the scripts to reside on a different server. I need to be able to make it listen on its public IP. I am assuming I need to change the listener.ora file and possibly tnsnames.ora as well, however if anyone has any better ideas, I would love to hear them. Here is my current listener.ora file. It seems like it would be relatively simple, but I have tried numerous changes but nothing seems to work.
So yeah, all I needed to do was to change all of the IPs to the public IP. I had tried that before, but only reloaded the listener. It turns out because it is running 9iAS as well, that I needed to reboot the entire server. This all came straight from the vendors mouth after some leaning on them. I will know for sure a little later tonight though when I test it out.
Support contract? The whole reason I am doing this is because we have been waiting 3 months for their nice java interface.
Thanks for your suggestion though.
I don't know, I am only going off of what they told me. When I told them I tried doing that and reloading the listener, they said that both 8i and 9iAS need to be restarted as well as some other services and that it would be easiest to reboot. I know more needs to happen than just reloading the listener because that didn't work before. Most likely that is why none of the changes I tried worked. I will post again to let you know how it worked out. I will be doing the reboot late tonight when I can minimize the affects of it. From what I can tell about this server, it appears to be a very substandard installation anyways, so maybe that is why reloading the listener didn't work. "Locate listener.ora" comes up with about 17 files. I don't think that is normal, is it? Either way, I will be personally flying to their headquarters and strangling their "head" DBA if this doesn't work!