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

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

by Rhose (Priest)
on Dec 13, 2001 at 21:48 UTC ( [id://131673]=note: print w/replies, xml ) Need Help??


in reply to Re: Oracle Connection Error - have you seen this?
in thread Oracle Connection Error - have you seen this?

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.

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

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (5)
As of 2024-04-20 01:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found