Geek Answers Handbook

Oracle SqlError: protocol violation / OALL 8 is in inconsistent state

I get a protocol violation, and OALL8 are inconsistent state exceptions trying to execute SELECT queries, but only in some of my tables. I first noticed this in a test application that wrote what I did SELECT * FROM SOMETABLE. It will go through several hundred records, and then just shut me down. I tried running the same query in Oracle SQLDeveloper and got a protocol exception for some tables. In the end, it reaches the point where it indicates that "OALL8 is in an inconsistent state" for any request.

Does anyone know why this is happening and how to solve the problem? Where is my inconsistent state? Is Oracle SqlDeveloper its own standalone client or relies on ODAC or Instant Client (link to PATH envi var)?

The only thing that has changed recently is that I installed ODAC so that I can use odp.net to replace System.Data.OracleClient in .NET. It was ODAC 11.2.0.3.0 with Oracle Developer Tools for Visual Studio, 32 bit. I updated my PATH environment variable to point to my standalone instant client.

  • Instant Client - 11.2.0.2.0, running on Win XP SP3, 32-bit Oracle database:

  • Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production running on Windows Server 2003, x64

  • ODAC: 11.2.0.3.0

SqlDeveloper was installed before I installed ODAC, but somehow SqlDeveloper seems to go through ODAC as a client, even though ODAC does not reference the PATH environment variable.

Update: When I initially installed ODAC, all my requests functioned normally. Then they stopped functioning every other day, and I can’t explain why. I tried to remove ODAC, which failed while searching for .DLL to remove. Then I manually uninstalled my ORACLE_HOME and reinstalled ODAC, and now it works fine. I do not understand why this is so.

+5
source share
1 answer

SQL Developer ORACLE_HOME , . , , , ORACLE_HOME - , JDBC, SQL Developer.

"" - , oracle sqldev, . - show jdbc

show jdbc
-- Database Info --
Database Product Name: Oracle
Database Product Version: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
Database Major Version: 12
Database Minor Version: 1
-- Driver Info --
Driver Name: Oracle JDBC driver
Driver Version: 12.2.0.1.0
Driver Major Version: 12
Driver Minor Version: 2
0

More articles:


All Articles