Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

shared pool memory

Prabhakar KOct 6 2020

Hi
I am getting this error every day ..
Errors in file /opt/oracle/admin/QTFEEDB/bdump/diag/rdbms/qtfeedb/QTFEEDB/trace/QTFEEDB_dm00_20139.trc (incident=21331):
ORA-04031: unable to allocate 81160 bytes of shared memory ("shared pool","KUPM$MCP","PLMCD^86cf633e","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPM$MCP"

Every day I am commented ORA-Errors as .. my name initials in the log file . then flushing the shared pool memory ..
SQL >alter system flush shared_pool;
for that day .. it won't repeat this error . again next day .. alerting ..
Shared pool memory , we have 2G. Senior DBAs saying that .. flushing shared pool memory is not a solution .. and don't increase the shared pool memory.
so I am bit confused here .. Please give me the solution .. it is very nice of you .. Adv. Thanks.
BR
Frd

Comments

Timo Hahn
Hi,
you did not mention which version of JDev you are using.
Check your libraries.xml file in the jedev/system<....> folder. My guess is that this file is corrupt.
Depending on the version you have to look for the files below in different directories.

You can try to rename the system directory and restart JDev. The newer version recreate this directory and you get a clean libraries.xml file. Copy the clean file back to the original system folder, delete the newly created folder, and rename the original on back to its original name.

If you JDev version dosn't recreate the folder you have to do an clean install and start JDev. This will recreate the folder.

Hope this helps

Timo
1 person found this helpful
562298
My JDeveloper version is 10.1.3.3.0.4157 if that helps. I'll try the suggestions but doesn't that imply I will lose my libraries settings?

Thanks for help
Timo Hahn
Yes, you'll loose the libraries but only temorary.
It just as a test if the system folder causes the error.
As mentioned before you shouldn't remove the folder but just rename it. so it's possible to retrieve the information later.

Timo
562298
Thanks for the effort Timo. But guess what. I started the JDeveloper today when I came to work and there was no stack trace. Everything just works. I think that is ridiculous (is there some sort of date/time based error going on or something) but I won't complain as long as I can go back to work as usual.

Thank you again for your time and effort.
Timo Hahn
This happens quit often. We have to close JDev and restart it to see some changes to take affect.
Sometimes it's a good idea to reboot the whole machine and see if the error persists.

Nevertheless you should make a copy of your system folder, in case you get a similar error in future. Then you can switch back to the working copy of the system folder and see what happens.


Timo
1 - 5

Post Details

Added on Oct 6 2020
#developer-studio, #developer-studio-ide-debugging-and-analysis-tools
10 comments
1,280 views