Once again thank to you all 
I'll try it later and let you know of the results



-----Original Message-----
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 6:35 PM
To: Ron Peled
Cc: [EMAIL PROTECTED]; Scott T. Hildreth
Subject: RE: Oracle 9i



If you want to use the 9i libraries, you definitely have to recomplie
DBD::Oracle.  If the 8.0.5 instance is still on the machine you could
use the current DBD::Oracle and connect through sqlnet,

$dbh = DBI->connect("dbi:Oracle:", 'user/passwd@sid', '', {});

                                                 /\ 
                                                  this would be the 9i
instance.

On 04-Dec-01 Ron Peled wrote:
> Hey Scott,
> 
>    First of all thanks for the quick answer.
> Second :Connecting via SQLPLUS connects me to the DB just fine.Looking in
> the tnsnames.ora it looks just fine and so is the ORACLE_SID .
> I have to admit that I'm quite new at this.
> 
> some facts that might help is that on the same machine(SUN) the same
program
> worked fine with an oracle 8.0.5 until yesterday when our DBA upgraded the
> DB .
> maybe I should remake the DBD:Oracle on the machine(sounds weired to me?)
> 
> thanks
> 
> 
> 
> -----Original Message-----
> From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 5:04 PM
> To: Ron Peled
> Cc: [EMAIL PROTECTED]
> Subject: RE: Oracle 9i
> 
> 
> 
> I found it works fine.  You have a listner problem,
> 
> 12514, 00000, "TNS:listener could not resolve SERVICE_NAME given in
connect
> descriptor"
> // *Cause:  The SERVICE_NAME in the CONNECT_DATA was not found in the
> listener's tables.
> // *Action: Check to make sure that the SERVICE_NAME specified is correct.
> // *Comment: This error will be returned if the database instance has not 
> // registered with the listener; the instance may need to be started.
> 
> ....the message from DBD::Oracle is that it can't find the above text,
which 
>    is extracted from the Oracle Home directories.  Try 'oerr ora 12514'
from
>    a shell prompt, see if the above message is printed.
> 
> On 04-Dec-01 Ron Peled wrote:
>> Hello every one
>>  
>> Does anybody know if there is a DBD:oracle that connects/work good with
>> Oracle 9i???
>> HELP!!!!!!!!!!!!!!!!!!!!!!!!!
>>  
>> I'm currently using DBI 1.20 and the DBD:ORACLE 1.12 and I keep getting
> the
>> lines :
>> Message 12514 not found; product=RDBMS;facility=ORA (DBD ERROR:
>> OCIServerAttach)
>>  
>>  
>> Thanks
>> Ron
> 
> ----------------------------------
> E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
> Date: 04-Dec-01
> Time: 08:59:33
> ----------------------------------

----------------------------------
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 04-Dec-01
Time: 10:31:22
----------------------------------

Reply via email to