RE: Question on DBI connection to Oracle

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 01/09/05

  • Next message: Ron Reidy: "RE: connection from Perl 5.8.5 to Oracle 7.3.4 database" 
    Date: Sun, 9 Jan 2005 10:00:59 -0700
To: "Zhou, Qing" <Qing_Zhou@intuit.com>, <dbi-users@perl.org>

    The error message says it all. You need to set (at a miniumu) ORACLE_HOME and ORACLE_SID.

    Read all the README* files in the DBD::Oracle distribution.

    -----------------
    Ron Reidy
    Lead DBA
    Array BioPharma, Inc.

    -----Original Message-----
    From: Zhou, Qing [mailto:Qing_Zhou@intuit.com]
    Sent: Saturday, January 08, 2005 5:46 PM
    To: 'dbi-users@perl.org'
    Subject: Question on DBI connection to Oracle

    Hello,

     

    First of all, thank you for taking the time to help me. I am a beginner to
    DBI, and I am very frustrated with not being able to connect to Oracle from
    my Sun Solaris box. I installed DBI and DBD modules, and tried to run the
    following test script:

     

    #!/usr/bin/perl

     

    use CGI;

    use DBI;

     

    my $dbname = 'skidev01';

    my $dbaddress = 'oraskidev01.bosptc.intuit.com';

    my $username = 'dev2';

    my $pass = 'XXXXX;

    my $db = "DBI:Oracle:$dbname:$dbaddress";

     

    my $dbh = DBI->connect($db, $username, $pass) || die "Database connection
    failed: $DBI:errstr" ;

    $dbh->disconnect();

     

    The following error occurred:

     

    $ perl test.pl

    ORACLE_HOME environment variable not set!

    DBI connect('skidev01:oraskidev01.bosptc.intuit.com','dev2',...) failed:
    Error while trying to retrieve text for error ORA-06401 (DBD ERROR:
    OCIServerAttach) at test.pl line 13

    Database connection failed: :errstr at test.pl line 13.

     

    I don't have Oracle server or client installed on the box. Is that the cause
    of the problem?

     

    Thanks a lot!

    Qing

     

    This electronic message transmission is a PRIVATE communication which contains
    information which may be confidential or privileged. The information is intended
    to be for the use of the individual or entity named above. If you are not the
    intended recipient, please be aware that any disclosure, copying, distribution
    or use of the contents of this information is prohibited. Please notify the
    sender of the delivery error by replying to this message, or notify us by
    telephone (877-633-2436, ext. 0), and then delete it from your system.

  • Next message: Ron Reidy: "RE: connection from Perl 5.8.5 to Oracle 7.3.4 database"

    Relevant Pages

    • RE: Unix: Oracle User Identified Externally
      ... Subject: Unix: Oracle User Identified Externally ... use DBI; ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • Re: DBD::Oracle - prepare() and the utf-8 flag.
      ... > distribution, nor is it derived from this distribution. ... I can't see at all how to fix it for DBD::Oracle. ... such a change to the DBI seems ... This change to Driver.xst enables drivers to define a dbd_st_prepare_sv ...
      (perl.dbi.users)
    • RE: Oracle functions through DBI?
      ... Subject: Oracle functions through DBI? ... I was wondering, can I use DBI ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • RE: oracle win2k ORA-1222 problems
      ... AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com. ... Oracle is listed as "failed" if I recall correctly. ... Data Source is DBI:Oracle:Space ...
      (perl.dbi.users)
    • RE: How to perform JOINs with DBI
      ... How to perform JOINs with DBI ... This electronic message transmission is a PRIVATE communication which contains ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)