Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Oracle Connection Error - have you seen this?

by Zo (Scribe)
on Dec 13, 2001 at 20:49 UTC ( #131655=perlquestion: print w/replies, xml ) Need Help??

Zo has asked for the wisdom of the Perl Monks concerning the following question:

I came across a new one that I haven't seen and I've done a search here, and on CPAN, and on and have no luck. Has anyone seen this error:
It's during the connection to Oracle. I have used the same exact perl code on other similar server configurations and I know it works (reason for not posting the code again), but now I have to do a test run on one of our development servers and it's not working... maybe I'm missing something? My past postings have all been database connection issues and I have learned a lot from you all, so if there's anything else maybe I'm missing.. another pair of 'eyes' would help.
FYI - W2K platform, Oracle8i, Latest verson from ActiveState Perl (5.6.*), PPMs: DBI and DBD-Oracle8 from ActiveState
Thanks in advance for any input, or help, or anything.
  • Comment on Oracle Connection Error - have you seen this?

Replies are listed 'Best First'.
Re: Oracle Connection Error - have you seen this?
by Rhose (Priest) on Dec 13, 2001 at 21:09 UTC

    Could you check out a few things for me?

    1. As the user under which the script runs, execute "tnsping db_tns_name" where db_tns_name is the Oracle TNS name of the instance to which your script is attempting to connect
    2. See if there is any additional error information in the Apache error log and if so, post it here
    3. See if the file sqlnet.log was generated. If so, and it contains any additional information, please post it here

    I am guessing this is an Oracle OCI problem, and not really a perl problem.


    Is there any chance the instance to which you are trying to connect is an Oracle 9i instance, and the previous ones were 8i? Looking on Oracle Metalink (support site) I did see some problems with the 8i OCI talking to 9i instances.

Re: Oracle Connection Error - have you seen this?
by Zo (Scribe) on Dec 13, 2001 at 21:37 UTC
    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...
      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.

Re: Oracle Connection Error - have you seen this?
by Zo (Scribe) on Dec 13, 2001 at 21:56 UTC
    I have a gut feeling that the Discoverer did through off the settings and such.
    Thanks though for all the other information, and I hope if it can't help me, that others reading will learn such as I have.
    Have a happy holidays (hanukah, christmas, kwanzaa, festivus, etc.etc.) and a Happy New Year

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://131655]
Approved by root
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (8)
As of 2019-07-23 11:59 GMT
Find Nodes?
    Voting Booth?
    If you were the first to set foot on the Moon, what would be your epigram?

    Results (25 votes). Check out past polls.