develooper Front page | perl.dist | Postings from October 2004

Re: ERROR OCIEnvInit

Thread Previous | Thread Next
From:
e_crewe
Date:
October 6, 2004 16:23
Subject:
Re: ERROR OCIEnvInit
Message ID:
20041006204304.5417.qmail@lists.develooper.com
Hi,

I had this problem in that I had both oracle 8 and 9 libraries on my box.
You need to install DBD::Oracle against the one you are using by setting
the environment variables to version of the oracle client you are using to
connect e.g. 
ORACLE_BASE=/usr/local/Ora8Inventory
ORACLE_HOME=/usr/local/oracle-8.1.7.0.1
and then make sure that this is in 
LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib

On reinstalling DBD::Oracle e.g.

perl -MCPAN -e shell
cpan>force install DBD::Oracle

it should be OK 
(fingers crossed)

Ed Crewe
------------------

Elena Ogayon wrote:

> Hi ,

> Good Morning. I have sent one email few days back to perl-dist@perl.org
> id. Can any one help me to resolve the below said
> Problem.FYI, I am new to perl programming.


> Expecting your reply.
> Thanks in advance.





> -----Original Message-----
> From: Ogayon, Elena 
> Sent: Wednesday, September 01, 2004 3:54 PM
> To: 'perl-dist@perl.org'
> Subject: Fw: ERROR OCIEnvInit 


>  Hi perl.dist,

> Currently we upgraded our oracle version form 8.1.7 to 9.2.0,after
> upgare I ran one perl script that contains the ora_login command,and got
> the following error. Can you please give me some idea / solution for
> this problem

> - Cannot read database. SQL  ERROR OCIEnvInit 

> Error due to the following statement


> $lda = &ora_login($oracle_sid, $oracle_user, $oracle_user_password);




> Thanks
> Expecting reply.



Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About