Do you have your ORACLE_HOME correctly set within the webpage? I would make sure that your environment is set correctly before debugging anything else.
Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.
| [reply] |
What dragonchild said, and I would check TWO_TASK as well.
| [reply] |
Also, make sure that the database name can be found in your $ORACLE_HOME/network/admin/tnsnames.ora file (unless you're using some other kind of name resolution mechanism, like oranames server... which I doubt). By this I mean: your database connect probably looks something like:
my $dbh = DBI->connect("dbi:Oracle:FOO", ...);
In which case "dbi:Oracle:FOO" is called your "connect descriptor", and "FOO" is the database name (in oracle-speak, this is a "TNS name"). Anyway, you should be able to find the information needed to connect to your oracle database listed under FOO (or equivalent) in your $ORACLE_HOME/network/admin/tnsnames.ora file.
Oh, and by the way: it's not a firewall issue. The error for that would be either hanging indefinitely on connect attempt or an error to the affect that the connection was refused. You are getting "could not resolve service name", which specifically means that the oracle client cannot figure out who you are trying to talk to (i.e. can't turn a TNS name into a: host, SID, and listener-port).
Good luck.
------------
:Wq
Not an editor command: Wq
| [reply]
[d/l]
[select] |