OS:linux suse 10
Oracle:11.1.0.7
安装Statspack在建完表空间后,不是要执行存储过程spcreat么?正常不是应该提示输入PERFSTAT用户的密码么?
我这里怎么一执行,一下就过去了,没等输密码就过去了,然后报错退出:
SQL> @spcreateChoose the PERFSTAT user's password
-----------------------------------
Not specifying a password will result in the installation FAILING&&perfstat_password
Choose the Default tablespace for the PERFSTAT user
---------------------------------------------------
Below is the list of online tablespaces in this database which can
store user data. Specifying the SYSTEM tablespace for the user's
default tablespace will result in the installation FAILING, as
using SYSTEM for performance data is not supported.Choose the PERFSTAT users's default tablespace. This is the tablespace
in which the STATSPACK tables and indexes will be created.TABLESPACE_NAME CONTENTS STATSPACK DEFAULT TABLESPACE
------------------------------ --------- ----------------------------
COMMON PERMANENT
NE5_1 PERMANENT
PDS PERMANENT
PERFSTAT PERMANENT
SYSAUX PERMANENT *
USERS PERMANENTPressing <return> will result in STATSPACK's recommended default
tablespace (identified by *) being used.Using tablespace &&DEFAULT_TABLESPACE as PERFSTAT default tablespace.Choose the Temporary tablespace for the PERFSTAT user
-----------------------------------------------------
Below is the list of online tablespaces in this database which can
store temporary data (e.g. for sort workareas). Specifying the SYSTEM
tablespace for the user's temporary tablespace will result in the
installation FAILING, as using SYSTEM for workareas is not supported.Choose the PERFSTAT user's Temporary tablespace.TABLESPACE_NAME CONTENTS DB DEFAULT TEMP TABLESPACE
------------------------------ --------- --------------------------
TEMP TEMPORARY *Pressing <return> will result in the database's default Temporary
tablespace (identified by *) being used.Using tablespace &&temporary_tablespace as PERFSTAT temporary tablespace.... Creating PERFSTAT user
identified by &&perfstat_password
*
ERROR at line 2:
ORA-00922: missing or invalid option
Oracle:11.1.0.7
安装Statspack在建完表空间后,不是要执行存储过程spcreat么?正常不是应该提示输入PERFSTAT用户的密码么?
我这里怎么一执行,一下就过去了,没等输密码就过去了,然后报错退出:
SQL> @spcreateChoose the PERFSTAT user's password
-----------------------------------
Not specifying a password will result in the installation FAILING&&perfstat_password
Choose the Default tablespace for the PERFSTAT user
---------------------------------------------------
Below is the list of online tablespaces in this database which can
store user data. Specifying the SYSTEM tablespace for the user's
default tablespace will result in the installation FAILING, as
using SYSTEM for performance data is not supported.Choose the PERFSTAT users's default tablespace. This is the tablespace
in which the STATSPACK tables and indexes will be created.TABLESPACE_NAME CONTENTS STATSPACK DEFAULT TABLESPACE
------------------------------ --------- ----------------------------
COMMON PERMANENT
NE5_1 PERMANENT
PDS PERMANENT
PERFSTAT PERMANENT
SYSAUX PERMANENT *
USERS PERMANENTPressing <return> will result in STATSPACK's recommended default
tablespace (identified by *) being used.Using tablespace &&DEFAULT_TABLESPACE as PERFSTAT default tablespace.Choose the Temporary tablespace for the PERFSTAT user
-----------------------------------------------------
Below is the list of online tablespaces in this database which can
store temporary data (e.g. for sort workareas). Specifying the SYSTEM
tablespace for the user's temporary tablespace will result in the
installation FAILING, as using SYSTEM for workareas is not supported.Choose the PERFSTAT user's Temporary tablespace.TABLESPACE_NAME CONTENTS DB DEFAULT TEMP TABLESPACE
------------------------------ --------- --------------------------
TEMP TEMPORARY *Pressing <return> will result in the database's default Temporary
tablespace (identified by *) being used.Using tablespace &&temporary_tablespace as PERFSTAT temporary tablespace.... Creating PERFSTAT user
identified by &&perfstat_password
*
ERROR at line 2:
ORA-00922: missing or invalid option
Choose the Default tablespace for the PERFSTAT user
---------------------------------------------------
Below is the list of online tablespaces in this database which can
store user data. Specifying the SYSTEM tablespace for the user's
default tablespace will result in the installation FAILING, as
using SYSTEM for performance data is not supported.Choose the PERFSTAT users's default tablespace. This is the tablespace
in which the STATSPACK tables and indexes will be created.TABLESPACE_NAME CONTENTS STATSPACK DEFAULT TABLESPACE
------------------------------ --------- ----------------------------
COMMON PERMANENT
NE5_1 PERMANENT
PDS PERMANENT
PERFSTAT PERMANENT
SYSAUX PERMANENT
USERS PERMANENTPressing <return> will result in STATSPACK's recommended default
tablespace (identified by *) being used.Using tablespace &&DEFAULT_TABLESPACE as PERFSTAT default tablespace.Choose the Temporary tablespace for the PERFSTAT user
-----------------------------------------------------
Below is the list of online tablespaces in this database which can
store temporary data (e.g. for sort workareas). Specifying the SYSTEM
tablespace for the user's temporary tablespace will result in the
installation FAILING, as using SYSTEM for workareas is not supported.Choose the PERFSTAT user's Temporary tablespace.TABLESPACE_NAME CONTENTS DB DEFAULT TEMP TABLESPACE
------------------------------ --------- --------------------------
TEMP TEMPORARY *Pressing <return> will result in the database's default Temporary
tablespace (identified by *) being used.Using tablespace &&temporary_tablespace as PERFSTAT temporary tablespace.... Creating PERFSTAT user
identified by &&perfstat_password
*
ERROR at line 2:
ORA-00922: missing or invalid option