Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^2: Error running CGI on tomcat

by sdeshpan (Initiate)
on Sep 11, 2007 at 18:01 UTC ( #638379=note: print w/replies, xml ) Need Help??


in reply to Re: Error running CGI on tomcat
in thread Error running CGI on tomcat

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!

Replies are listed 'Best First'.
Re^3: Error running CGI on tomcat
by rdfield (Priest) on Sep 12, 2007 at 10:19 UTC
    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!!!
        There should be an error stack in your sqlnet.log file, the error above is a generic error, and more detailed infomation should be recorded in the log file.

        rdfield

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (4)
As of 2021-04-17 03:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?