Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle error, can not figure out

SOLVED
Go to solution
Ratzie
Super Advisor

Oracle error, can not figure out

I keep getting this oracle error that I can not figure out, I was hoping you can share some light into what it means...
unknown object??
sga heap??
state objects??


SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Aug 31 07:24:21 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")
6 REPLIES
Cheryl Griffin
Honored Contributor
Jean-Luc Oudart
Honored Contributor
Solution

Re: Oracle error, can not figure out

Hi,

This error is due to the shared pool being too small and/or fragmented.

cf. attachment

Regards,
Jean-Luc
fiat lux
Jean-Luc Oudart
Honored Contributor

Re: Oracle error, can not figure out

Hi Again,

you can check the space available in your shared pool with this SQL script.

cf. attachment

Regards,
Jean-Luc
fiat lux
Jean-Luc Oudart
Honored Contributor

Re: Oracle error, can not figure out

Also,

it seems you're not on the latest of oracle8i.
You should patch your oracle install and databases.
8.1.7.4

Regards,
Jean-Luc
fiat lux
Indira Aramandla
Honored Contributor

Re: Oracle error, can not figure out

Hi,

If your Oracle RDBMS release is 8.1.7.0 and you are experiencing the error ORA-604 that precedes the ORA-4031 the error was encountered during the execution of recursive SQL.

This appears to be due to bug 1397603 which effects 8.1.7.0 and 8.1.7.1 releases.
It is fixed in later releases.

There is a workaround for this.
Use the workaround as an interim solution which is setting _db_handles_cached = 0 in the init.ora file. Shutdown and restart the database in order for the parameter change to take effect. Remember to unset this parameter after applying the patchset release.


Indira A
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: Oracle error, can not figure out

hi,

i also recommend the installation of the latest patches to 8.1.7.4.

This contain fixes to many more bugs.

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)