OraFAQ Forum: Programming Interfaces » Problem on connecting with DBD to Oracle DB with ORA-03135

Home » Open Source » Programming Interfaces » Problem on connecting with DBD to Oracle DB with ORA-03135 (HP-Itanium64 11.31, Oracle 10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem on connecting with DBD to Oracle DB with ORA-03135 [message #444805]

Wed, 24 February 2010 05:18

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi all,

We have a problem which we get at customer side. Only one cust has this problem, others with same OS-Version and same Oracle Version runs fine.

OS     : HP/UX Itanium 11.31
ORACLE : 10.2.0.4
DBD    : 1.21 or 1.24
perl   : 5.8.8

We have an application which connects via DBD (originally V1.21, but also with 1.24) into DB. Whn we start a perl-command which usese DBD to connect it works for seconds but crashes with ORA-03135 and ORA-03113.

I tried several Informations and Solutions from Internet and Metalink, but nothing works.

Originally server sqlnet.ora

NAMES.DEFAULT_DOMAIN = pribasys.ch
NAMES.DIRECTORY_PATH= (TNSNAMES)
SQLNET.EXPIRE_TIME = 0
# NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
# NAMESCTL.NOCONFIRM = ON


#trace_level_client=16
#trace_directory_client=/opt/oracle/10.2.0.4/db_1/network/log
#trace_file_client=sqltrc_client.trc
#trace_unique_client=true
#tnsping.trace_level=16
#tnsping.trace_directory=/tmp

Also tried with :

NAMES.DEFAULT_DOMAIN = pribasys.ch
NAMES.DIRECTORY_PATH= (TNSNAMES)
[color=red]SQLNET.EXPIRE_TIME = 10
SQLNET.INBOUND_CONNECT_TIMEOUT = 300
SQLNET.SEND_TIMEOUT = 300
SQLNET.RECV_TIMEOUT = 300[/color]
# NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
# NAMESCTL.NOCONFIRM = ON


#trace_level_client=16
#trace_directory_client=/opt/oracle/10.2.0.4/db_1/network/log
#trace_file_client=sqltrc_client.trc
#trace_unique_client=true
#tnsping.trace_level=16
#tnsping.trace_directory=/tmp

But all the same.
We get NO Entries in alert.log nor tracefiles in *dump directories. The Program runs on same server - so no client is invoked.

SQLPLUS works fine, TOAD works fine - only perl connections via DBD crashes

Any suggestions ?
Thanx
uwe

Report message to a moderator

Re: Problem on connecting with DBD to Oracle DB with ORA-03135 [message #444921 is a reply to message #444805]

Wed, 24 February 2010 14:52

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

after modifying your SQLNET.ora; have you reloaded your LISTENER?

-Babu

Report message to a moderator

Re: Problem on connecting with DBD to Oracle DB with ORA-03135 [message #445200 is a reply to message #444921]

Fri, 26 February 2010 07:16

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Yes, Babu.
I stopped and started the listener. Not even reload.

Problem is still on

Uwe

Report message to a moderator

Re: Problem on connecting with DBD to Oracle DB with ORA-03135 [message #445331 is a reply to message #445200]

Sun, 28 February 2010 20:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

you might have to change line #1 below to work on your system

#!/usr/bin/perl -w

use DBI;


@ary = DBI->available_drivers;
for (@ary) {
   print;
   print "\n";
}

@ary = DBI->data_sources("dbi:Oracle:");
for (@ary) {
   print;
   print "\n";
}

run code above & post results back here.
please send me a PM since I rarely monitor this subforum

Report message to a moderator

Previous Topic:	php with oracle
Next Topic:	Odbc driver returned an error (SQLExecDirectW

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 21:33:35 CST 2024