If you are running the statspack script as SYS, and still getting these
errors, then it appears that catalog.sql (and may be catproc.sql) was not
run (as sys) on this new database.
- Kirti
-----Original Message-----
Sent: Thursday, October 03, 2002 3:58 AM
To: Multiple recipients of list ORACLE-L
This errors I got,
I did the same installation on an other server same 8.1.72 and never I got
any errors with statspack.
Why those objects does'nt exists ?
How can fix this problem ?
thanks
grant select on V$FILESTATXS to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V$TEMPSTATXS to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V$SQLXS to PERFSTAT
*
ERROR at line 1:
ORA-01720: grant option does not exist for 'SYS.V_$SQL'
Grant succeeded.
grant select on V_$PARAMETER to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SYSTEM_PARAMETER to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$DATABASE to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$INSTANCE to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$LIBRARYCACHE to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$LATCH to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$LATCH_MISSES to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$LATCH_CHILDREN to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$LATCH_PARENT to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$ROLLSTAT to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$ROWCACHE to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SGA to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$BUFFER_POOL to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SGASTAT to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SYSTEM_EVENT to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SESSION to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SESSION_EVENT to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SYSSTAT to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$WAITSTAT to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SQLAREA to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SQL to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SQLTEXT to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$SESSTAT to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
grant select on V_$BUFFER_POOL_STATISTICS to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or view does not exist
-----Message d'origine-----
De: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Date: mercredi 2 octobre 2002 20:33
À: Multiple recipients of list ORACLE-L
Objet: RE: Help : X$KSPPI Oracle 8.1.7.2 STATSPACK
That's an Oracle internal table that is created during the database
creation
time.
What is the exact error you are receiving?
BTW, Do you use APT scripts by Steve Adams?
- Kirti
-----Original Message-----
Sent: Wednesday, October 02, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L
How to create this view X$KSPPI ?
I am trying to install statspack, and it missing this view. ! ! !
Regards
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting
services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting
services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
