Re: Problem with dbms_swrf_internal.unregister_database in 12.1.0.1

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Tue, 20 May 2014 12:30:01 -0500
Message-ID: <CAPZQniWdznXagMC9eJ82SmHVr+NG5X0cn-TmYr4caSUoGcTkfw_at_mail.gmail.com>

*grin* I am very familiar with the ways to escalate; I just don't like to babysit all my SRs. And yes, MOS is looking into now. My reason for posting here is to see if anyone else might have some insight and/or insider knowledge that can be made public. My philosophy is "it never hurts to ask". :)

On Tue, May 20, 2014 at 12:20 PM, Seth Miller <sethmiller.sm_at_gmail.com>wrote:

> 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_at_gmail.com>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
>>
>
>

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 20 2014 - 19:30:01 CEST