Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: Oracle Connection Error - have you seen this?

by Zo (Scribe)
on Dec 13, 2001 at 21:37 UTC ( #131669=note: print w/replies, xml ) Need Help??

in reply to 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...
  • 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
    Oracle Discoverer is a GUI data browsing/query tool, and it's installation would change the libraries installed on the local ORACLE_HOME.

    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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://131669]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (6)
As of 2019-05-20 02:38 GMT
Find Nodes?
    Voting Booth?
    Do you enjoy 3D movies?

    Results (123 votes). Check out past polls.