Re: new statspack install seems to hang

On Sep 26, 5:16 pm, eAddict <eAdd..._at_gmail.com> wrote:
> > As a first step run utlrp.sql while connected as sysdba.
> > If that does not fix it, list the objects (non-user) which
> > are marked invalid.
>
> I tried running it but it seemed to hang. So I did this:
>
> SQL> Select 'alter package '||object_name||' compile body;'
> 2 From user_objects
> 3 where status <> 'VALID'
> 4 And object_type = 'PACKAGE BODY';
>
> 'ALTERPACKAGE'||OBJECT_NAME||'COMPILEBODY;'
> --------------------------------------------------------------------------------
> alter package DBMS_UTILITY compile body;
>
> I then tried to run the line that came up and it hung as well.
> So...

THAT invalid dbms_utility is probably the root cause of the issue. dbms_shared_pool references dbms_utility (and thus is dependent on it).
Open a Tar with Oracle and ask their advise. DBMS_UTILITY should not be invalid. If you don't want to take the time to open a Tar with Oracle, look into metalink on running catproc.sql which is the one that creates dbms_utility.

Good luck,
Anurag Received on Wed Sep 26 2007 - 16:52:35 CDT