ORA-12571: TNS:packet writer failure

dataservices administration
1

Hi all, I have a problen with DI 5.1 (Yes Still 5.1).

I get this eror: ORA-12571: TNS:packet writer failure. The error seems to be aleatory, sometimes happens, sometimes not.

We have changed from oracle 8.1.7 (Unix) to Oracle 9.i (W2003, Itanium 64), the servers were out of our offices, and now they are in here. Perhaps is a conexion fairule??

Other reason could be the instalation of an antivirus, but we have desinstalled and we get the error again.

Thak you.

juananra :es: (BOB member since 2006-05-24)

2

Some things to look at:

http://www.cryer.co.uk/brian/oracle/ORA12571.htm
http://www.experts-exchange.com/Databases/Oracle/Product_Info/Q_21101591.html
http://ora-12571.ora-code.com/

  • Ernie

eepjr24 :us: (BOB member since 2005-09-16)

3

I don’t think this will help but… DI not able to load data to oracle target tables

Werner Daehn :de: (BOB member since 2004-12-17)

4

Assuming you have worked out the fact that the database is functional from the client using sqlplus, and that you are able to create tables, load data etc etc from sql.

Do you have any bitmap indexes?

If you do have bitmap indexes… (especially if you have more than one load job running into the table in question). But even with a single load job oracle parallism can be killing you.

Drop the bitmap’s… replace them with regular b-tree indexes.

If you don’t have bitmaps… then forget what I just said :slight_smile:

sbauer :us: (BOB member since 2006-03-31)