Discussion :

[yaya0057]

Bonjour à tous,

J'essaye désespérement d'effectuer un statspack sur une base oracle 10G, mais je n'arrive même pas à installer le produit. J'ai suivi bêtement le tuto mais quand je lance voilà ce que cela me donne:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
 
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           
------------------------------ --------- ----------------------------           
PERFTBS                        PERMANENT                                        
SYSAUX                         PERMANENT *                                      
USERS                          PERMANENT                                        
 
Pressing <return> will result in STATSPACK's recommended default
tablespace (identified by *) being used.
 
Enter value for default_tablespace: PERFTBS
 
Using tablespace PERFTBS 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             
------------------------------ --------- --------------------------             
PERFTBS_TMP                    TEMPORARY                                        
TEMP                           TEMPORARY *                                      
 
Pressing <return> will result in the database's default Temporary
tablespace (identified by *) being used.
 
Enter value for temporary_tablespace: PERFTBS_TBS
 
Using tablespace PERFTBS_TBS as PERFSTAT temporary tablespace.                  
 
 
... Creating PERFSTAT user
create user perfstat
            *
ERROR at line 1:
ORA-01920: user name 'PERFSTAT' conflicts with another user or role name

Est ce qu cela pourrait être un problème de droit.

Et lorsque j'essaye de faire un drop je joins le fichier trace car il est un peu long

Merci