signing self signed certificates

sites:

http://www.g-loaded.eu/2005/11/10/be-your-own-ca/
http://www.eclectica.ca/howto/ssl-cert-howto.php

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

ubunut tips for myself

disable firewall:

ufw disable

log on to another linux server it takes a very long time before the password question:

change /etc/ssh/ssh_config

uncomment:

GSSAPIAuthentication no

X forwarding

ssh -XY user@machine

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

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.

Deployment BPEL process fails with revision error

During automatic ant deployment this error is shown:

Embedded error: The following error occurred while executing this line:
/oracle/opleveringen/obm/1.1.0.0/code/opm-integration/scripts/ant/bpel/common-build.xml:82: A problem occured while connecting to server "soatier2.test.ta-twd.rotterdam.nl" using port "80": bpel_CancelBasket_1.0.0-SNAPSHOT.jar failed to deploy. Exception message is:  Error deploying BPEL suitcase.
An error occurred while attempting to deploy the BPEL suitcase file "/appl/oracle/soa_cl_10.1.3/bpel/domains/OnlineBetaalModule/tmp/bpel_10725323.tmp"; the exception reported is: Process bpel://localhost/OnlineBetaalModule/CancelBasket~1.0.0-SNAPSHOT/ is being re-deployed to a Production Server with same revision number.Please modify the revision for the process.

In the BPELAdmin tab server the field productionServer is true, when this is changed to false and the soa container is restarted the deployment succeeds. After the deployment change it to true again and restart again.
Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

All contexts in Oracle Application server with opmnctl

opmnctl status -app -l | awk -F"|" '{ print $7 }'

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