Re: new statspack install seems to hang

From: Gerry Sinkiewicz <sinkiege_at_snet.net>
Date: Tue, 25 Sep 2007 22:16:49 GMT
Message-ID: <lNfKi.697$4V6.394@newssvr14.news.prodigy.net>

"eAddict" <eAddict_at_gmail.com> wrote in message news:1190732160.628076.161190_at_g4g2000hsf.googlegroups.com...
> On Sep 24, 7:31 pm, joel garry <joel-ga..._at_home.com> wrote:

>> On Sep 24, 3:15 pm, eAddict <eAdd..._at_gmail.com> wrote:
>>
>>
>>
>> > I just finished installing statspack on a bunch of servers (6) all
>> > running 9.2.0.8.
>> > My last one, running 9.2.0.4, there is an issue.  Statspack just seems
>> > to
>> > hang.  When I finally cancel the job I get:
>>
>> > SQL> exec statspack.snap;
>>
>> > BEGIN statspack.snap; END;
>> > *
>> > ERROR at line 1:
>> > ORA-01013: user requested cancel of current operation
>>
>> > or
>> > SQL> exec statspack.snap
>> > ;
>> > 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 35
>> > ORA-06512: at "SYS.DBMS_SHARED_POOL", line 43
>> > ORA-06512: at "PERFSTAT.STATSPACK", line 2708
>> > ORA-06512: at line 1
>>
>> > SP2-0223: No lines in SQL buffer.
>>
>> > So....  I can't upgrade the 9.2.0.4 server to 9.2.0.8 right now.
>> > What are my options? What is statspack doing that is making
>> > it hang?
>>
>> > Thanks for any help!
>> > Vince
>>
>> Did you forget to run dbmspool.sql?
>>
>> jg
>> --
>> @home.com is bogus.
>> "Blimey, this is complicated." - Mark Rittman
>

> Didn't help...

>

> sapdb:oraprd 7> sqlplus '/ as sysdba'

>

> SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 25 09:53:24 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> @dbmspool

>

> Package created.
> Grant succeeded.
> View created.
> Package body created.

>

> SQL> connect perfstat/**************
> Connected.
> SQL> exec statspack.snap; <----30 min wait before cancel
> 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

>
>

If you ran $ORACLE_HOME/rdbms/admin/spcreate.sql as sysdba?

Try using a dbms_job at regular intervals. See $ORACLE_HOME/rdbms/admin/spauto.sql (as perfstat). Received on Tue Sep 25 2007 - 17:16:49 CDT