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:
Est ce qu cela pourrait être un problème de droit.
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
Et lorsque j'essaye de faire un drop je joins le fichier trace car il est un peu long
Merci
Partager