Oracle database link error - ppm upgrade problem
From: Tony Adolph (Tony.Adolph_at_o2.com)
Date: 07/29/04
- Next message: Ron Reidy: "RE: Oracle database link error - ppm upgrade problem"
- Previous message: vj: "Re: Pls HELP - Perl DBI installation problems"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: dbi-users@perl.org Date: Thu, 29 Jul 2004 15:14:04 +0200
Hi all,
A couple of problems....
Firstly an ORA-03113: end-of-file on communication channel problem:
---------------------------------------------------------------------------------------------------------
my perl script is running from a win2000 box using perl v5.8.0 built for
MSWin32-x86-multi-thread connecting to an Oracle 8.1.7.3 database. DBI
version: 1.34 and DBD::Oracle 1.13
My code is trying to query across a database link (the another database is
also 8.1.7.3). The code from sqlplus works, but from DBI I get ORA-03113:
end-of-file on communication channel, here's trace(1):
DBI 1.34-ithread dispatch trace level set to 1
<- prepare('select object_name FROM user_objects@CSC_T.BGENDB1 WHERE
object_type ='SYNONYM'')= DBI::st=HASH(0x1e62a00) at dwh.pl line 195
!! ERROR: 3113 'ORA-03113: end-of-file on communication channel (DBD
ERROR: OCIStmtExecute)'
<- execute= undef at dwh.pl line 196
execute error: ORA-03113: end-of-file on communication channel (DBD ERROR:
OCIStmtExecute) at dwh.pl line 196, <STDIN> line 4.
error: 3113 'ORA-03113: end-of-file on communication channel (DBD
ERROR: OCIStmtExecute)'
<- DESTROY= undef
<- DESTROY= undef
<- DESTROY= undef
<- DESTROY= undef
<- disconnect_all (not implemented)
<- disconnect_all= (not implemented) at DBI.pm line 641
error: 3114 'ORA-03114: not connected to ORACLE (DBD ERROR:
OCITransRollback)'
<- DESTROY= undef during global destruction
<- DESTROY= undef during global destruction
I did a few google searches, but didn't find too much, so decided to try to
upgrade both DBI and DBI::Oracle.
2nd problem: ppm problem
-----------------------------------------
ppm> upgrade DBI
DBI 1.34: new version 1.43 available in ActiveState PPM2 Repository
DBI 1.34: new version 1.40 available in temp
DBI 1.34: new version 1.35 available in ActiveState Package Repository
ppm> upgrade -install -follow -force DBI
DBI 1.34: new version 1.43 available in ActiveState PPM2 Repository
DBI 1.34: new version 1.40 available in temp
DBI 1.34: new version 1.35 available in ActiveState Package Repository
Note: DBI version 1.34 is available from more than one place.
Which repository would you like to upgrade from?
1. ActiveState PPM2 Repository
2. temp
3. ActiveState Package Repository
Repository? [ActiveState Package Repository] 3
ppm returns immediately obviously having done nothing:
ppm> query DBI
Using cached query result set 1.
1. DBI [1.34] Database independent interface for Perl
I've tried the other reposities, but get the same result. the -follow and
-force were after thoughts, but as you can see had the same result.
Any help would be appreciated,
Regards
Tony
Tony Adolph
o2 (Germany) GmbH & Co.OHG
Georg Brauchle-Ring 23-25, D80992 München
Tel +49 (0)89 2442 6167
Mobil +49 (0)179 509 0840
Fax +49 (0)89 2442 4162
----------------------------------------------------------------------------------------------------
This electronic message contains information from the mmo2 plc Group which
may be
privileged or confidential. The information is intended to be for the use
of the
individual(s) or entity named above. If you are not the intended recipient
be aware
that any disclosure, copying, distribution or use of the contents of this
information
is prohibited. If you have received this electronic message in error,
please notify
us by telephone or email (to the numbers or address above) immediately.
- Next message: Ron Reidy: "RE: Oracle database link error - ppm upgrade problem"
- Previous message: vj: "Re: Pls HELP - Perl DBI installation problems"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
