Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Error running CGI on tomcat

by rdfield (Priest)
on Sep 11, 2007 at 09:14 UTC ( #638258=note: print w/ replies, xml ) Need Help??


in reply to Error running CGI on tomcat

Can you connect using sqlplus?

rdfield


Comment on Re: Error running CGI on tomcat
Re^2: Error running CGI on tomcat
by sdeshpan (Initiate) on Sep 11, 2007 at 18:01 UTC
    Yes, I can connect using sqlplus as well as toad. I can also ping the DB machine and tnsping is successful. This makes me believe that everything on the oracle client is ok. I am also providing the "connect" code here that I am using:
    # DBI Initializations my $driver = 'Oracle'; my $hostname = 'host=oradev;sid=oradev;port=1521'; my $user = 'user'; my $password = 'password'; my $dsn = "DBI:$driver:$hostname"; my $dbh = DBI->connect($dsn,$user,$password) or croak "Error $DBI::err +str connecting to $dsn\n";
    the last line is where it fails and gives me the error message!
      Does
      my $dsn = "DBI:$driver:oradev"; my $dbh = DBI->connect($dsn,$user,$password);
      make any difference?

      The code you currently have bypasses the tns alias, the code above uses the alias.

      rdfield

        Hi, I tried this format of the connection string, but it now gives this error:

        Error ORA-12560: TNS:protocol adapter error (DBD ERROR: OCIServerAttach) connecting to DBI:Oracle:ORADEV

        Any ideas? I am banging my head, wondering what environment variables etc might be missing!!!

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (8)
As of 2015-07-04 17:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls