How to clear / blacklist an ASR entry in Ops Center

Workaround for a bug if the serial number start with a “0”

SQL> DELETE FROM asr_activation WHERE serial_number = '0929FM104E';
 
 
SQL> INSERT INTO asr_activation
(serial_number,request_status,asr_status_cached,create_dtt) VALUES
('0929FM104E','blacklisted','blacklisted',sysdate);
 
 
SQL> SELECT * FROM asr_activation WHERE SERIAL_NUMBER LIKE '0929FM104E';

You might also like this. Oracle Ops Center ZFS, Device fail-over Scripts