Problem with dbms_swrf_internal.unregister_database in 12.1.0.1

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Tue, 20 May 2014 08:31:06 -0500
Message-ID: <CAPZQniUibpkKff+S2aqMjq35RFod6qzivsb9xo9JvCUhLXxC7w_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 20 2014 - 15:31:06 CEST

Original text of this message