Hi everyone,
I'm having that age-old problem of trying to connect with Oracle. On one server there
are two Oracle
databases, say called db1 and db2. I'm connecting to them from another server. I've
had no problem
connecting with db1 with a call like:
my $dbh = DBI->connect('DBI:Oracle:db1.host.edu','userid/passwd', '');
I should mention that the name of the host where the databases are is called
db1.host.edu. So I may be
confusing the name of the server and the first database because they have the same
name.
Anyway, I can't seem to connect to the second database, db2, even when I set up all
the environment
variables to point to the second instance of Oracle. I do know db2 is using port
1522. It wasn't clear
to me from the documentation in Oracle.pm where to put the port number in the
connection string, or even
if I need to.
I am setting ORACLE_SID to the name of the database instance.
Any suggestions? This is using DBD-Oracle 0.59 and Oracle 8.1.7.
Thanks,
Andy
| Andy Squires -- Programmer / Analyst |
| E-Administration -- American University |
| (202) 885-2785 |
