ORA-00604错误:安装STATSPACK!
在公司测试环境安装STATSPACK报错
其步骤如下:
Alter System Set job_queue_processes =10 Scope = both;
Alter System Set timed_statistics = True;
create tablespace perfstat
datafile 'd:\oracle9i\oradata\sun\perfstat.dbf'
size 500M
extent management local;
@ 'D:\Oracle9i\rdbms\admin\spcreate.sql'
以上是我执行的脚本
在执行过程中已输入perfstat用户的密码、默认表空间、临时表空间,然后就报错,请求帮助!
内容如下:
Choose the PERFSTAT user's temporary tablespace.
Specifying the SYSTEM tablespace will result in the installation
FAILING, as using SYSTEM for the temporary tablespace is not recommended.
Specify PERFSTAT user's temporary tablespace.
输入 temporary_tablespace 的值: temp
Using temp for the temporary tablespace
PL/SQL 过程已成功完成。
用户已更改。
NOTE:
SPCUSR complete. Please check spcusr.lis for any errors.
SQL>
SQL> --
SQL> -- Build the tables and synonyms
SQL> connect perfstat/&&perfstat_password
ERROR:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-20001: Login error!
ORA-06512: 在line 6
警告: 您不再连接到 ORACLE。
SQL> @@spctab
SQL> Rem
SQL> Rem $Header: spctab.sql 16-apr-2002.14:54:46 vbarrier Exp $
SQL> Rem
SQL> Rem spctab.sql
SQL> Rem
SQL> Rem Copyright (c) 1999, 2002, Oracle Corporation. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem spctab.sql
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem SQL*PLUS command file to create tables to hold
SQL> Rem start and end "snapshot" statistical information
SQL> Rem
SQL> Rem NOTES
SQL> Rem Should be run as STATSPACK user, PERFSTAT
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem vbarrier 03/20/02 - 2143634
SQL> Rem vbarrier 03/05/02 - Segment Statistics
SQL> Rem cdialeri 02/07/02 - 2218573
SQL> Rem cdialeri 01/30/02 - 2184717
SQL> Rem cdialeri 01/11/02 - 9.2 - features 2
SQL> Rem cdialeri 11/30/01 - 9.2 - features 1
SQL> Rem cdialeri 04/22/01 - Undostat changes
.........................