Purge data ESB/WSM

How to purge ESB instance data? [ID 453357.1]
How To Delete / Purge Non-Operational Data from the OWSM Schema / Database ? [ID 815974.1]

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Query size rman backups

set linesize 200 heading off
set heading on pagesize 200

column status format a10
column COMMAND_ID for a12
column time_taken_display format a10;
column input_bytes_display format a12;
column output_bytes_display format a12;
column output_bytes_per_sec_display format a10;
column ses_key format 9999999
column ses_recid format 9999999
column device_type format a10
column OutBytesPerSec for a13

SELECT b.session_key ses_key,
b.session_recid ses_recid,
b.session_stamp,
b.command_id,
b.input_type,
b.status,
to_char(b.start_time,'DD-MM-YY HH24:MI') "Start Time",
b.time_taken_display,
b.output_device_type device_type,
b.input_bytes_display,
b.output_bytes_display,
b.output_bytes_per_sec_display "OutBytesPerSec"
FROM v$rman_backup_job_details b
WHERE b.start_time > (SYSDATE - &)
ORDER BY b.start_time desc;

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Oracle ESB: No WebService Provider is registered at this URL

Error when webservice is clicked in esb control

No WebService Provider is registered at this URL

During startup ESB:

java.sql.SQLException: ORA-24067: exceeded maximum number of subscribers for queue
ORAESB.ESB_CONTROL

solution:

CREATE OR REPLACE PROCEDURE create_queue (qname VARCHAR2)
AS
qtablename VARCHAR2(110) := qname;

BEGIN

BEGIN
dbms_aqadm.stop_queue (queue_name => qname);
EXCEPTION
WHEN OTHERS THEN
null;
END;

BEGIN
dbms_aqadm.drop_queue (queue_name => qname);
EXCEPTION
WHEN OTHERS THEN
null;
END;

BEGIN
dbms_aqadm.drop_queue_table (Queue_table => qtablename);
EXCEPTION
WHEN OTHERS THEN
null;
END;

dbms_aqadm.create_queue_table(Queue_table => qtablename,
Queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE',
multiple_consumers => true,
compatible => '8.1');
dbms_aqadm.create_queue (Queue_name => qname,
Queue_table => qtablename);
dbms_aqadm.start_queue(qname);
END;
/

BEGIN
create_queue('ESB_CONTROL');
END;
/




Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.