Thursday, March 31, 2011

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.

Monday, March 28, 2011

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.

Wednesday, March 16, 2011

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.