Awrload Import Datagrams ORA-20104, ORA-06512 error handling

1, awrload Import datagram ORA-20104, ORA-06512 error

Sql> @?/rdbms/admin/awrload.sql ~~~~~~~~~~ AWR LOAD ~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ This script would load the AWR data from a dump file. The ~ ~ script would prompt users for the following information: ~ ~ (1) Name of directory object ~ ~ (2) Name of dump file ~ ~ (3) staging schema name to load AWR data into ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Specify the Directory Name ~~~~~~~~~~~~~~~~~~~~~~~~~~ Directory Name Directory Path ------------------------------ ------------------------------------------------- Impdp_dir_2/u01/expdp_dir Choose a Directory Name from the list above (case-sensitive). Enter value for directory_name:impdp_dir_2 Using the Dump directory:impdp_dir_2 Specify the Name of the Dump File to Load ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Specify the prefix of the dump file (. dmp) to load: Enter value for file_name:sbd_39791_39978 Loading from the file name:sbd_39791_39978.dmp Staging Schema to Load AWR Snapshot Data ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The next step is to create the staging schema Where the AWR snapshot data would be loaded. After loading the data into the staging schema, The data would be transferred into the AWR tables In the SYS schema. The default staging schema name is awr_stage. To use the this name, press <return> to continue, otherwise enter An alternative. Enter value for schema_name: Using the Staging schema Name:awr_stage Declare * ERROR at line 1: Ora-20104:schema name ' Awr_stage ' already exists Ora-06512:at Line 17 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production With the partitioning option

2. Cause analysis

Awr_stage is when Awrload.sql imports the AWR data, the user is created by default to temporarily store the imported data, and when the data import is complete, Oracle automatically drop the user.

Since the Awr_tage user already exists, this problem occurs when the AWR data was not properly ended before it was imported.

3. Treatment method

Manually delete Awr_stage users

sql> drop user awr_stage cascade;

User dropped.

4. Re-use Awrload.sql Import

Successfully imported AWR data.

Sql> @?/rdbms/admin/awrload.sql

~~~~~~~~~~

AWR LOAD

~~~~~~~~~~

Using tablespace TEMP as the temporary tablespace for Awr_stage ... Creating awr_stage User | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | Loading the AWR data from the following | Directory/file: | /u01/expdp_dir | Sbd_39791_39978.dmp | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | AWR Load Started ... | | This operation would take a few moments. The | Progress of the AWR load operation can be | Monitored in the following directory/file: | /u01/expdp_dir | Sbd_39791_39978.log | ... Dropping awr_stage user End of AWR Load Sql>

This article Li Junjie (Network Name: casing), engaged in "system architecture, operating systems, storage devices, databases, middleware, applications" six levels of systematic performance optimization work

Welcome to the System performance Optimization Professional group, to discuss performance optimization technology together. Group number: 258187244

Awrload Import Datagrams ORA-20104, ORA-06512 error handling