ORA-12592/ORA-12569 when querying SYS.AUD$

[MjH]

We are in the process of installing a new 11g cluster and examining the use of Oracle's auditing. When querying SYS.AUD$, the connection to the database fails with an ORA-12592 or ORA-12569 error (v7.1.5.1398). The problem seems to be related to the number/size of the results of the query. A query returning less than 15 rows (plus or minus a couple) works consistently.

The same queries with Oracle's tools (SQL*Plus, SQL*Worksheet) do not have any problems.

Is there any dump/log that I can send that would help you track down the problem?

 

[Marco Kalter]

That is a very low-level client/server communication error. Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[MjH]

I have sent the information in an email to support@allroundautomations.com.

I was using a 10g Oracle client install for my home, so I downloaded and installed the 11g client as well. With the 11g client, the error generated is "ORA-03135: connection lost contact".

Thanks, Maury