Re: ORA-12612

From: Hans-Peter Sloot <H.G.Sloot_at_kpn.com>
Date: 2 Feb 1999 09:11:14 GMT
Message-ID: <01be4e8b$fe7677b0$0a0c010a@hans_peter>

Hello Josef,

It is an oracle bug and has to do with DeadConnectionDetection. Contact Oracle for the patch
664171 for HPUX 10.x.
683163 for Digital Unix.

De patch.sh of #683163 for DCUX is not correct. You'll have to perform te following commands after running the patch.sh. cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk ioracle
cd $ORACLE_HOME/network/lib
make -f ins_network.mk install

A workaround to avoid 12612 errors is setting the SQLNET.EXPIRE_TIME to 0. This means that dead connections will not be detected.

Regards Hans-Peter Sloot

Josef Scherm <j.scherm_at_t-online.de> wrote in article <36B607BA.1F8CE7A8_at_gmx.de>...
> Hello!
>
> We use an Oracle 7.3.4 database and sql*net to connect our application
> to the database. We often get the Error-Message ORA-12612.
>
> Can anybody give me some hints to solve this problem?
>
> josef.scherm_at_gmx.de
>
>
Received on Tue Feb 02 1999 - 03:11:14 CST