Database Tuning (MOSC)

MOSC Banner

[11.2.0.3 on W2K8] Error while trying to install statspack

edited Oct 8, 2013 3:34AM in Database Tuning (MOSC) 12 commentsAnswered ✓
Hi,I've got the following problem when trying to install statspack on 11.2.0.3 database.

\>cd \Oracle\product\11.2.0\db\RDBMS\ADMIN

\Oracle\product\11.2.0\db\RDBMS\ADMIN>sqlplus sys/SMTESTmgr@SMTESTW as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Lun. Oct. 7 13:43:11 2013

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


ConnectÚ Ó :
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> @spcreate.Sql

Choose the PERFSTAT user's password
-----------------------------------
Not specifying a password will result in the installation FAILING

Entrez une valeur pour perfstat_password : perfstat
perfstat


Choose the Default tablespace for the PERFSTAT user
---------------------------------------------------
Below is the list of online tablespaces in this database which can

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center