Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06508: problem
ORA-06508: problem [message #398118] Wed, 15 April 2009 05:16 Go to next message
manns
Messages: 59
Registered: March 2006
Location: Bangalore
Member

I have a very strange error.
We have a database with multiple schemas, now in one schema now error occurs

This is the situation:
I have a view, with a call to package 'A' which calls package 'B'.
When I do a select on the view in SQL/Plus , I get error
ORA-06508: PL/SQL: could not find program unit being called
Here all the units are valid. if i recopile the units wich are called problem disappers but after a few hours it re-appeared.
we try to increase server shared memory also but that dint help.
can any one suggest the solution for this..

regards
Manju
Re: ORA-06508: problem [message #398144 is a reply to message #398118] Wed, 15 April 2009 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post a test case that we can reproduce.

Regards
Michel
Re: ORA-06508: problem [message #398628 is a reply to message #398144] Thu, 16 April 2009 23:58 Go to previous messageGo to next message
manns
Messages: 59
Registered: March 2006
Location: Bangalore
Member

Hi,

After SGA & PGA increase in Oracle database we compile all the abjects. Now its fine. thanks.
Re: ORA-06508: problem [message #398636 is a reply to message #398628] Fri, 17 April 2009 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.
Did you have any error in the alert.log file when the problem occured?

Regards
Michel
Re: ORA-06508: problem [message #398651 is a reply to message #398636] Fri, 17 April 2009 01:36 Go to previous messageGo to next message
manns
Messages: 59
Registered: March 2006
Location: Bangalore
Member

yes, In log thre was error abt insufficiant shared memory. This error is thre in DB log, but in application it was ORA-06508. can not find program unit.

Regards,
Manju
Re: ORA-06508: problem [message #398655 is a reply to message #398651] Fri, 17 April 2009 01:40 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good, your error is more understandable now.
Generally speaking, when you have such a problem, have a look at alert.log and also post the errors you find in it, it will be easier to find the root cause and answer.

Regards
Michel
Previous Topic: Extracting values from comma separated string and loop through them
Next Topic: to update mulitple columns based on the multiple column values from other table
Goto Forum:
  


Current Time: Sat Dec 03 03:50:35 CST 2016

Total time taken to generate the page: 0.09508 seconds