Re: Help, what's going wrong?

It always amazes me that one can find out his Oracle Sid just by asking a question on the right newgroup 8-)

Richard

Matthew Lam <yklam308_at_yahoo.com> wrote in message news:92f4lv$kct3_at_rain.i-cable.com...
> Try to add these lines in your perl script before you connect to Oracle:
>
> $ENV{"ORACLE_HOME")= "ABC";
> $ENV{"ORACLE_SID"}="XYZ";
>
>
> Stanley <stanley_woo_at_yahoo.com> wrote in message
> news:92c1p5$s3m129_at_imsp212.netvigator.com...
> > Hi,
> > I'm newbie to oracle, just wrote a perl script to insert some data into
> > database daily. It doesn't work and with error message as below. But
 worked
> > fine if executed the script under ksh. Enclosed with
> >
> > part of code :-
> > sub connect_DB
> > {
> > use DBI;
> > $DSN = "DBI:Oracle:CCS1";
> > $user = "ccsdba";
> > $pw = "ccsdba";
> > $dbh = DBI->connect($DSN, $user,$pw)
> > || die "cannnot connect: $DBI::errstr\n" unless $dbh;
> > return;
> > }
> >
> > Error message :-
> > From ccs Wed Dec 27 14:00:01 2000
> > Date: Wed, 27 Dec 2000 14:00:01 +0800
> > From: ccs (calling card statistics)
> > Message-Id: <200012270600.OAA29065_at_ccshost.>
> > To: ccs
> > Subject: Output from "cron" command
> > Content-Length: 403
> >
> > Your "cron" job on ccshost
> > /opt/ccs/bin/insertlog > /export/home/iLife/insertlog.log
> >
> > produced the following output:
> >
> > ORACLE_HOME environment variable not set!
> > DBI->connect failed: Error while trying to retrieve text for error
 ORA-12154
> > (DBD ERROR: OCIServerAttach) at /opt/ccs/bin/insertlog line 96
> > cannnot connect: Error while trying to retrieve text for error ORA-12154
> > (DBD ERROR: OCIServerAttach)
> >
> > ?
> >
> > Could someone tell what going wrong, I have check environment varibles
 under
> > ksh is good.
> > Any words would be appreciated.
> >
> > Stanley
> >
> >
>
>
Received on Thu Dec 28 2000 - 19:01:14 CST