Connect without an entry in TNSNAMES.ORA

Is it possible to do a connect to a database when there is no entry in
the local machines TNSNAMES.ORA file?

I've tried the following, but to no avail.

....
my $conn = "dbi:Oracle:HOST=$host;SID=$sid;port=1521";
my $db_h = DBI->connect ( $conn,
$user,
$pwd,
{
AutoCommit => 0, # 0 = false
RaiseError => 0,
PrintError => 0,
ChopBlanks => 1 # CHAR chopped
}
) || BEGIN { print color 'red on_black';
warn "\n" . "x" x 70 . "\n" .
"\t--> Connecting to " .
uc ( $sid ) . " as " .
uc ( $user ) . " <--\n\n"
..
$DBI::errstr .
"\n" . "x" x 70 . "\n";
print color 'reset';
print "\n";
return undef;
};
....


I get the following errors

***********************************************************************
Fatal NI connect error 12541, connecting to:

(DESCRIPTION=(ADDRESS=(HOST=machineA.com)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SID=aaa)(CID=(PROGRAM=t2.pl@bbb)
(HOST=aaa)(USER=uuuuu))))

***********************************************************************
Fatal NI connect error 12535, connecting to:

(DESCRIPTION=(ADDRESS=(HOST=machineA.com)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SID=aaa)(CID=(PROGRAM=t2.pl@bbb)
(HOST=aaa)(USER=uuuuu))))

***********************************************************************
Fatal NI connect error 12505, connecting to:

(DESCRIPTION=(ADDRESS=(HOST=machineA.com)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SID=aaa)(CID=(PROGRAM=t2.pl@bbb)
(HOST=aaa)(USER=uuuuu))))

.

Relevant Pages

  • Sendmail - did not issue MAIL/EXPN - problem with one company.
    ... mail log I see them connecting but the log file has the "did not issue ... entry for every connection they try to make. ... filtering and invalid address filtering happens behind the firewall on ... We don't seem to be having problems resolving their mail server ip's ...
    (comp.mail.sendmail)
  • RE: sendmail log entry
    ... An entry like that would be generated if something on the local system ... the service by connecting to it, ... misconfigured and identifying itself as localhost? ...
    (RedHat)
  • Any Pythonic GTK Undo library?
    ... Entry, ... simply connecting such an object to an "UndoableUIManager" would take ... which doesn't implement any actual undo operations; ...
    (comp.lang.python)
  • Re: Connect without an entry in TNSNAMES.ORA
    ... the local machines TNSNAMES.ORA file? ... At the beginning of the DBD::Oracle documentation, ... "Connecting without environment variables or tnsname.ora file ...
    (perl.dbi.users)
  • Re: Active Sync Only Connects as Guest via Network
    ... found that after I installed movianVPN, the "WINS" entry ... I had added to the network adapter settings was not there ... I had no trouble connecting with the USB cradle, ...
    (microsoft.public.pocketpc.activesync)