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