Re: new statspack install seems to hang

I should have left good enough alone... but I ran the drop and create again to try to get spauto.sql
working. Now nothing works. I ran the spdrop.sql and spcreate as sysdba.

     sqlplus '/ as sysdba' @spdrop
     sqlplus '/ as sysdba' @spcreate

then granted the permission

sapdb:oraprd 8> sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 26 11:09:10 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> grant execute on dbms_shared_pool to perfstat;

Grant succeeded.

SQL> connect perfstat/**********
Connected.
SQL> exec statspack.snap; <-30 min wait again!

BEGIN statspack.snap; END;

*
ERROR at line 1:

ORA-01013: user requested cancel of current operation
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at "PERFSTAT.STATSPACK", line 2708
ORA-06512: at line 1

Log files:
sapdb:oraprd 10> more spdusr.lis

View dropped.
Synonym dropped.
View dropped.
Synonym dropped.
View dropped.
Synonym dropped.
View dropped.
Synonym dropped.
View dropped.
Synonym dropped.
View dropped.
Synonym dropped.
User dropped.
NOTE:
SPDUSR complete. Please check spdusr.lis for any errors.

sapdb:oraprd 15> more spcpkg.lis

Creating Package STATSPACK...
Package created.
No errors.
Creating Package Body STATSPACK...
Package body created.
No errors.

NOTE:
SPCPKG complete. Please check spcpkg.lis for any errors.

In fact, all the .lis files show no errors. Argh! Received on Wed Sep 26 2007 - 11:17:35 CDT