?
Solved

ORA-00907 Cannot load library unit SYS.SYS_STUB_FOR_PURITY_ANALYSIS

Posted on 2010-08-26
3
Medium Priority
?
2,579 Views
Last Modified: 2013-12-19
Cannot compile a simple oracle procedure...it's in one database and connected to another via dblink...error is
PLS-00907: cannot load library unit SYS.SYS_STUB_FOR_PURITY_ANALYSIS@NLDB_REMOTE_CONNECT.NL.EDU
(referenced by BANINST1.F_STUDENT_GET_DESC@NLDB_REMOTE_CONNECT.NL.EDU)

the dblink user HAS execute privs on the sys.sys_stub_for_purity_analysis package!!

Many OTHER load procedures in the same schema using the same dblink...DO compile...any thoughts?
0
Comment
Question by:ScoutsDad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 

Author Comment

by:ScoutsDad
ID: 33531717
Attached is the load plsql procedure that will not compile...oracle version is 10.2.4.0
file.sql
0
 

Accepted Solution

by:
ScoutsDad earned 0 total points
ID: 33541339
OK...found the solution to this:

The buffer_cache was full!...i.e. when the error message said it couldn't load the sys module: SYS.SYS_STUB_FOR_PURITY_ANALYSIS...it was due to the fact that the buffer_cache was full...for once...the error message was literally telling me what the problem was...ha!

so a quick alter system flush buffer cache...resolved the issue...!!!!
0
 

Author Closing Comment

by:ScoutsDad
ID: 33541354
I found my own solution...but that's ok that no one else chimed in...this one was a doozy....
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
In this post we will learn different types of Android Layout and some basics of an Android App.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month11 days, 20 hours left to enroll

752 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