The first question should be: "Can you connect to the database
from that server via SQLPLUS?"
If the answer is no, then you need to resolve the Oracle network
configuration before resolving anything in your Perl script.
Jared
On Thu, 2004-01-15 at 07:33, Andy Squires wrote:
> 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 |
