Oracle 8i and ODT
-
After installing the Oracle ODT I find that now I can access all my Oracle 10 databases perfectly, but the older Oracle 8i systems are no longer available. I understand this is a known problem, has anyone else encountered this and knows of a work around ? Thanks
-
After installing the Oracle ODT I find that now I can access all my Oracle 10 databases perfectly, but the older Oracle 8i systems are no longer available. I understand this is a known problem, has anyone else encountered this and knows of a work around ? Thanks
One thing to look at is the tnsnames.ora files. The ODT stuff creates a new set for 10g (separate from the ones for 9i etc.), and they may be different but the 10g version is sometimes the only one used after it is created. If the name resolutions of all your databases are not in the 10g version of tnsnames.ora, then you might consider merging the tnsnames.ora files. Another potential problem is that ODT also creates a sqlnet.ora file that works sort of like your hosts file (helps resolve server names). In my case, the sqlnet.ora file had incorrect domain information that was overriding what was in my tnsnames.ora file and causing server names not to resolve. After some fiddling with the file, I finally just deleted it, reasoning that it had not been there prior to ODT, and everything had worked fine anyway. Everything worked after that. Hope this helps.
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’