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 ----------------------------------