Solved

Error ORA-06508

Posted on 2004-10-13
4
633 Views
Last Modified: 2013-12-12
Hi,

     I'm using Oracle 5.0 and lately I've been getting ORA-06508 error messages. Its a client server application and I'm using Pro-C for my Comms. I tried to debug it and i found out that it's not passing through one of the procedures that I'm trying to call.. When I checked the status of the procedure, its valid.. I tried to kill the process and after killing it, it worked fine.. but after a while it returned back to displaying the same error messages again.. There seems to be no problem with the procedures. What do you think can happen? Could it be a hardware problem (do i need an upgrade in memory)? Btw, the procedures are stored in the database. Are the packages that are stored in the database depended on how much memory is allocated for the packages and procedures? Thanks in advance for any help you can offer.

Jrobles
0
Comment
Question by:jrobles1232000
4 Comments
 
LVL 9

Expert Comment

by:konektor
ID: 12295432
u have to re-connect.

simulate 6508 :
1. logon to your application
2. call the procedure stored in DB - everything will work
3. logon to sqlplus and recompile the procedure
4. call the procedure from application (still connected from step 1) - u'll get ora-6508 and nothinh helps u only reconnecting
0
 
LVL 8

Expert Comment

by:sapnam
ID: 12297612
We had a similar problem.  We dropped the procedures and re-created them and that solved the problem.  You should have the procedure scripts for re-creating them. You can always get that from user_source.  Also, check for any invalid objects before and after dropping as some objects may get invalidated due to object dependency. About memory, that can be an issue. Just post your total RAM on the server and the SGA size to get some idea on this
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12563506
PAQed with no points refunded (of 250)

modulo
Community Support Moderator
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question