Database connection problem from Teamsite Server

Hi,
We are working on TSv6.7 on Solaris.
However we are not able to connect from our Teamsite Server to the DB server.

The error given is as follows:
DBI connect('host=prod-db-i;sid=TESTING;port=1521','test',...)
failed: ORA-12535: TNS Smiley Surprised

peration timed out (DBD ERROR: OCIServerAttach) at /apps/iw-home/iw-perl/site/lib/DBConnect.pm line 20 Can't call method "prepare" without a package or object reference at /iwmnt/default/main/Pampers_Village/WORKAREA/Staging/Perl/
locale.pl line 13.

Please note that we could connect to other DB server using the same script.
Can any one suggest the areas we need to debug?

Find more posts tagged with

Comments

chicka

try setting the env parmaeters explicitly in your code.

Vishakha

We have already added the ENV variable:
$ENV{ORACLE_HOME} = '/home/oracle';

This works while connecting to one DB oracle server.

Do not know the reason why the connection to other DB oracle server fails.