Re: Problem with dbms_swrf_internal.unregister_database in 12.1.0.1
- From: Seth Miller <sethmiller.sm@xxxxxxxxx>
- To: sacrophyte@xxxxxxxxx
- Date: Tue, 20 May 2014 12:20:01 -0500
Charles,
This looks like a question that only MOS will be able to answer. The first
response to MOS taking too long to respond is to escalate. MOS not only
suggests this, they provide a detailed document on how to do it
effectively. 166650.1
Seth Miller
On Tue, May 20, 2014 at 8:31 AM, Charles Schultz <sacrophyte@xxxxxxxxx>wrote:
> Good morning, listers,
>
> I am following the instructions found in "How To remove Workload
> Repository information related to an old DBID from workload repository (Doc
> ID 1251795.1)"; I realize it specifically says it is for "Release 10.2 to
> 11.2", but I am unable to find similar documents or instructions for 12c,
> so this is all I have available to me. My database is vanilla OSEE 12.1.0.1
> on Solaris 10.
>
> When I attempt to unregister a database from AWR by DBID, I get the
> following error.
>
> SQL > exec dbms_swrf_internal.unregister_database(2595040291);
> BEGIN dbms_swrf_internal.unregister_database(2595040291); END;
>
> *
> ERROR at line 1:
> ORA-13553: operation failed - missing parameter [SRCDBID]
> ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 193
> ORA-06512: at line 1
>
>
> However, this error does not jive with the description found in the
> package:
> SQL> desc dbms_swrf_internal
> ...
> PROCEDURE UNREGISTER_DATABASE
> Argument Name Type In/Out Default?
> ------------------------------ ----------------------- ------ --------
> DBID NUMBER IN
> SKIP_NOTEXIST BOOLEAN IN DEFAULT
> ...
>
> I have filed a case with Oracle but they are (VERY) slow to acknowledge it.
>
> So here is my question - what is the proper syntax?
>
> --
> Charles Schultz
>
Other related posts:
