Shulou(Shulou.com)06/01 Report--

1. For the sake of safety, it is recommended to stop and rebuild.

two。 If it is a rac environment, you need to modify the following parameters:

Alter system set cluster_database = false scope = spfile

3. Execute the following script to start cleaning, and the execution speed is very fast, because it is all drop. If you encounter an error in which a table does not exist, ignore it.

@? / rdbms/admin/catnoawr.sql4. Run the script to perform the rebuild

@? / rdbms/admin/catawrtb.sql5. Run a script to compile invalid objects

@? / rdbms/admin/utlrp.sql6. 11g run the following script

@? / rdbms/admin/execsvrm.sql encountered the following error when running this script:

BEGIN

*

ERROR at line 1:

ORA-04068: existing state of packages has been discarded

ORA-04061: existing state of package "SYS.DBMS_SWRF_INTERNAL" has been

Invalidated

ORA-04065: not executed, altered or dropped package "SYS.DBMS_SWRF_INTERNAL"

ORA-06508: PL/SQL: could not find program unit being called:

"SYS.DBMS_SWRF_INTERNAL"

ORA-06512: the at line 3 solution is to recompile the package:

Alter package dbms_swrf_internal compile

Alter package dbms_swrf_internal compile body;7. Re-implement step 6

8. Try to generate a report.

Exec dbms_workload_repository.create_snapshot; encountered the following error:

SQL > exec dbms_workload_repository.create_snapshot

BEGIN dbms_workload_repository.create_snapshot; END

*

ERROR at line 1:

ORA-13518: Invalid database id (819500514)

ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 99

ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 122

ORA-06512: at line 1 found an article on MOS about this problem.

ORA-13518: 'Invalid Database Id' On Call to DBMS_WORKLOAD_REPOSITORY Package [ID 984447.1]

Changes

Recently AWR was recreated using catnoawr.sql and catawrtb.sql.

Cause

When a function / procedure is called from DBMS_WORKLOAD_REPOSITORY package, it refers table WRM$_DATABASE_INSTANCE to get dbid information.

As the AWR repositories has been recreated, the table doesn't not have any data present in it.

SQL > select * from WRM$_DATABASE_INSTANCE

No rows selected

Solution

The WRM$_DATABASE_INSTANCE gets populated with instance information when the instance is rebooted.

So, If you have recreated AWR using catnoawr.sql, catawrtb.sql, then you need to bounce the Instance.

On restart, the table will be populated with the requisite information.

Hence, better option for recreating AWR is to use startup restrict method.

After the recreation activity is completed, shutdown the database and open it normally.

9. Problem resolved after restart

10. Modify rac related parameters

Alter system set cluster_database = truescope= spfile;11. Generate awr report

@ $ORACLE_HOME/rdbms/admin/awrrpt.sql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.