12c运行awrload脚本报错

s_chrison

数据库版本 12.1.0.1.0
操作系统版本  CentOS 6.3

awr数据来源正常，导入awr数据报错，步骤和错误信息：

1. SYS@mals01 SQL> conn /as sysdba
   
2. SYS@mals01 SQL> alter session set container=pdb;
   
3. 
   
4. Session altered.
   
5. 
   
6. SYS@mals01 SQL> @?/rdbms/admin/awrload
   
7. ~~~~~~~~~~
   
8. AWR LOAD
   
9. ~~~~~~~~~~
   
10. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    
11. ~  This script will load the AWR data from a dump file. The   ~
    
12. ~  script will prompt users for the following information:    ~
    
13. ~     (1) name of directory object                            ~
    
14. ~     (2) name of dump file                                   ~
    
15. ~     (3) staging schema name to load AWR data into           ~
    
16. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    
17. 
    
18. Specify the Directory Name
    
19. ~~~~~~~~~~~~~~~~~~~~~~~~~~
    
20. 
    
21. Directory Name                 Directory Path
    
22. ------------------------------ -------------------------------------------------
    
23. AWR_DUMP_DIR                   /home/oracle/awr
    
24. OPATCH_LOG_DIR                 /oracle/app/oracle/product/12.1.0/QOpatch
    
25. OPATCH_SCRIPT_DIR              /oracle/app/oracle/product/12.1.0/QOpatch
    
26. ORACLE_BASE                    /
    
27. ORACLE_HOME                    /
    
28. ORACLE_OCM_CONFIG_DIR          /oracle/app/oracle/product/12.1.0/ccr/hosts/oraS1
    
29.                                2c01/state
    
30. 
    
31. ORACLE_OCM_CONFIG_DIR2         /oracle/app/oracle/product/12.1.0/ccr/state
    
32. XSDDIR                         /ade/b/3593327372/oracle/rdbms/xml/schema
    
33. 
    
34. Choose a Directory Name from the list above (case-sensitive).
    
35. 
    
36. Enter value for directory_name: AWR_DUMP_DIR
    
37. 
    
38. Using the dump directory: AWR_DUMP_DIR
    
39. 
    
40. Specify the Name of the Dump File to Load
    
41. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    
42. Please specify the prefix of the dump file (.dmp) to load:
    
43. 
    
44. Enter value for file_name: awrdat_50_56
    
45. 
    
46. Loading from the file name: awrdat_50_56.dmp
    
47. 
    
48. Staging Schema to Load AWR Snapshot Data
    
49. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    
50. The next step is to create the staging schema
    
51. where the AWR snapshot data will be loaded.
    
52. After loading the data into the staging schema,
    
53. the data will be transferred into the AWR tables
    
54. in the SYS schema.
    
55. 
    
56. 
    
57. The default staging schema name is AWR_STAGE.
    
58. To use this name, press <return> to continue, otherwise enter
    
59. an alternative.
    
60. 
    
61. Enter value for schema_name:
    
62. 
    
63. Using the staging schema name: AWR_STAGE
    
64. 
    
65. Choose the Default tablespace for the AWR_STAGE user
    
66. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    
67. Choose the AWR_STAGE users's default tablespace.  This is the
    
68. tablespace in which the AWR data will be staged.
    
69. 
    
70. TABLESPACE_NAME                CONTENTS  DEFAULT TABLESPACE
    
71. ------------------------------ --------- ------------------
    
72. SYSAUX                         PERMANENT *
    
73. USERS                          PERMANENT
    
74. 
    
75. Pressing <return> will result in the recommended default
    
76. tablespace (identified by *) being used.
    
77. 
    
78. Enter value for default_tablespace: users
    
79. 
    
80. Using tablespace USERS as the default tablespace for the AWR_STAGE
    
81. 
    
82. 
    
83. Choose the Temporary tablespace for the AWR_STAGE user
    
84. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    
85. Choose the AWR_STAGE user's temporary tablespace.
    
86. 
    
87. TABLESPACE_NAME                CONTENTS  DEFAULT TEMP TABLESPACE
    
88. ------------------------------ --------- -----------------------
    
89. TEMP                           TEMPORARY *
    
90. 
    
91. Pressing <return> will result in the database's default temporary
    
92. tablespace (identified by *) being used.
    
93. 
    
94. Enter value for temporary_tablespace:
    
95. 
    
96. Using tablespace TEMP as the temporary tablespace for AWR_STAGE
    
97. 
    
98. 
    
99. ... Creating AWR_STAGE user
    
100. 
     
101. |
     
102. | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     
103. |  Loading the AWR data from the following
     
104. |  directory/file:
     
105. |   /home/oracle/awr
     
106. |   awrdat_50_56.dmp
     
107. | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     
108. |
     
109. |  *** AWR Load Started ...
     
110. |
     
111. |  This operation will take a few moments. The
     
112. |  progress of the AWR load operation can be
     
113. |  monitored in the following directory/file:
     
114. |   /home/oracle/awr
     
115. |   awrdat_50_56.log
     
116. |
     
117. Register 1: dbid 1228956769 src_name 1228956769 src_dbid 1228956769
     
118. begin
     
119. *
     
120. ERROR at line 1:
     
121. ORA-20105: unable to move AWR data to SYS
     
122. ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 4552
     
123. ORA-65040: operation not allowed from within a pluggable database
     
124. ORA-06512: at line 3
     
125. 
     
126. 
     
127. ... Dropping AWR_STAGE user
     
128. 
     
129. End of AWR Load

复制代码

是哪里出了问题？

s_chrison

使用CDB，用户名大写，导入成功。

结贴