Re: Oracle Connection Error - have you seen this?

I noticed and contacted my 'team lead' and seems that our 'manager' was fooling around on that server. The application 'Oracle Discoverer 3i' has been set up on the system. I have never seen this application before. I know I have made database connections in the past (when I knew the machine was clean without all other applications) with perl on this same server, but now with this error and seeing this "Discoverer" application, could this possibly cause the error?
Just thinking out loud...
Zo

Comment on Re: Oracle Connection Error - have you seen this?

Replies are listed 'Best First'.

Re: Re: Oracle Connection Error - have you seen this?
by Rhose (Priest) on Dec 13, 2001 at 21:48 UTC

If your script has worked on this server before, Discoverer was recently installed, and now it does not work, I'm gonna put a better than 50% chance this is the problem. (Besides, there are a lot of "features" with the Oracle 8i OCI, and changing a lib or two can make things more "interesting". *Smiles*)

There is one additional problem -- the Oracle installer is horrid. I am not sure uninstalling Discoverer will remove everything which it added. (I am an Oracle DBA, and I cannot tell you how many times I have had to scrap my local install and start all over when adding new components.) If you have a recent backup which can be restored (including the reg keys under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE) this is where I would start. If not, and you can take the machine down, I would uninstall the Oracle software, remove the ORACLE_HOME directory, remove ORACLE_HOME\bin from the PATH, and remove the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE reg keys. Then I would start from square one with a new Oracle client install.

[reply]