From oracle-l-bounce@freelists.org Mon Mar 1 03:01:03 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i21913D09488 for ; Mon, 1 Mar 2004 03:01:03 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i21912o09483 for ; Mon, 1 Mar 2004 03:01:02 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0531F394DC1; Mon, 1 Mar 2004 04:01:47 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 01 Mar 2004 04:00:06 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from inet-mail4.oracle.com (inet-mail4.oracle.com [148.87.2.204]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66253394D6D for ; Mon, 1 Mar 2004 04:00:04 -0500 (EST) Received: from rgmgw4.us.oracle.com (rgmgw4.us.oracle.com [138.1.191.13]) by inet-mail4.oracle.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id i2192C22007418 for ; Mon, 1 Mar 2004 01:02:13 -0800 (PST) Received: from rgmgw4.us.oracle.com (localhost [127.0.0.1]) by rgmgw4.us.oracle.com (Switch-2.1.5/Switch-2.1.0) with ESMTP id i2193Ub17616 for ; Mon, 1 Mar 2004 02:03:30 -0700 (MST) Received: from oracle.com ([141.147.144.209]) by rgmgw4.us.oracle.com (Switch-2.1.5/Switch-2.1.0) with ESMTP id i2193Sb17573 for ; Mon, 1 Mar 2004 02:03:29 -0700 (MST) Message-ID: <4042FC5F.4000901@oracle.com> Date: Mon, 01 Mar 2004 14:33:27 +0530 From: vidya kalyanaraman Organization: Oracle Corporation User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: Statspack error : ORA-06564: object HTP_PERFSTAT.STATSPACK does not exist References: <4042FA32.1040707@oracle.com> In-Reply-To: <4042FA32.1040707@oracle.com> Content-Type: multipart/alternative; boundary="------------010705080307090102050809" X-archive-position: 64 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: vidya.kalyanaraman@oracle.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --------------010705080307090102050809 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Hi Server: HP-UX Oracle Ver: 9.2.0.4 64 bit Sorry I missed this info in my previous post. Thanks Vidya vidya kalyanaraman wrote: > Hi All > While trying to use statspack to generate snaps, got the following > error. > $sqlplus perfstat/perfstat > SQL> execute statspack.snap > BEGIN statspack.snap; END; > > * > ERROR at line 1: > ORA-06564: object HTP_PERFSTAT.STATSPACK does not exist > ORA-06512: at "SYS.DBMS_UTILITY", line 114 > 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 > > Please note that spcreate.sql did not throw any error. Object > STATSPACK is in valid state in 'PERFSTAT' schema but in invalid state > for 'HTP_PERFSTAT' schema. > Could not compile the body, because of 1353/16 PL/SQL: ORA-00942: > table or view does not exist error. > > Any idea why this package is not getting compiled? We are totally > lost as the output file has not thrown any error. Do I have to > explicitly grant privileges to HTP_PERFSTAT schema? > > TIA > Vidya > > --------------010705080307090102050809 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi
Server: HP-UX
Oracle Ver: 9.2.0.4 64 bit
Sorry I missed this info in my previous post.

Thanks
Vidya

vidya kalyanaraman wrote:

Hi All
While trying to use statspack to generate snaps, got the following error.
$sqlplus perfstat/perfstat
SQL> execute statspack.snap
BEGIN statspack.snap; END;

*
ERROR at line 1:
ORA-06564: object HTP_PERFSTAT.STATSPACK does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 114
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

Please note that spcreate.sql did not throw any error. Object STATSPACK is in valid state in 'PERFSTAT' schema but in invalid state for 'HTP_PERFSTAT' schema.
Could not compile the body, because of 1353/16 PL/SQL: ORA-00942: table or view does not exist error.

Any idea why this package is not getting compiled? We are totally lost as the output file has not thrown any error. Do I have to explicitly grant privileges to HTP_PERFSTAT schema?

TIA
Vidya

--------------010705080307090102050809-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------