This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 1) First step is to sudo as the unix user with weblogic access (replace YOUR_SUDO_USER with yours) | |
ssh YOUR_USER@YOUR_LINUX_SERVER | |
sudo su - YOUR_SUDO_USER | |
# 2) Locate your installed weblogic domain start file | |
find / -name startManagedWebLogic.sh -type f -print 2>/dev/null | |
#or if you use mlocate | |
locate startManagedWebLogic.sh | |
## After a while this command should print something like : | |
##/YOUR_SUDO_USER/weblogic/user_projects/domains/YOUR_DOMAIN/bin/startManagedWebLogic.sh |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--Audit Trail | |
-- SQL Query to provide detail audit trail via SQL (useful when a flowtrace can't be open) | |
-- SQL to get bpel ECID from ID Demande : | |
select ECID, ID, composite_dn | |
from soa_user.composite_instance | |
where title ='&BUSINESS_DEFINED_ID' | |
order by created_time desc; | |
--SQL to get detailed status of a bpel instance and his ECID Replace Flowtrace |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--Performance/Development Action | |
--Script to mass abort all running instances. (Usefull during perf testing to keep volumetry between runs) | |
update YOUR_YOUR_SOA_USER.composite_instance set state=16 where state=32; | |
update YOUR_YOUR_SOA_USER.work_item set state = 10, modify_date = sysdate where state<5; | |
update YOUR_YOUR_SOA_USER.cube_instance ci set ci.state = 8 , | |
ci.scope_revision = (select cit.scope_revision+1 from YOUR_YOUR_SOA_USER.cube_instance cit where cit.ecid = ci.ecid) , | |
ci.modify_date = sysdate where ci.state < 4; | |
update YOUR_YOUR_SOA_USER.dlv_message set state = 3 where state in (0, 2); | |
update YOUR_YOUR_SOA_USER.dlv_subscription set state = -1 where state=0; | |
COMMIT; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--Change this variable for your purge date value. In this case the Bpel purge purge all instance older than &purgeDays days | |
DECLARE purgeDays number := 72; | |
--TroubleShooting BPEL Purge | |
--Not purged instances | |
SELECT | |
ci.ecid AS ecid, | |
decode(ci.state,0, 'STATE_INITIATED(NOK)',1,'STATE_OPEN_RUNNING(OK)',2,'STATE_OPEN_SUSPENDED(OK)',3,'STATE_OPEN_FAULTED(OK)',4,'STATE_CLOSED_PENDING_CANCEL(OK)',5,'STATE_CLOSED_COMPLETED(NOK)',6,'STATE_CLOSED_FAULTED(NOK)', 7, 'STATE_CLOSED_CANCELLED(NOK)', 8, 'STATE_CLOSED_ABORTED(NOK)', 9, 'STATE_CLOSED_STALE(NOK)', 10, 'STATE_CLOSED_ROLLED_BACK(NOK)') AS state, | |
ci.composite_name AS composite_name, | |
ci.composite_revision AS composite_revision, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-------------------------------------------------------- | |
-- MIT License | |
-- Author Cedric Leruth | |
-- | |
--Permission is hereby granted, free of charge, to any person obtaining a copy | |
--of this software and associated documentation files (the "Software"), to deal | |
--in the Software without restriction, including without limitation the rights | |
--to use, copy, modify, merge, publish, distribute, sublicense, and/or sell | |
--copies of the Software, and to permit persons to whom the Software is | |
--furnished to do so, subject to the following conditions: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--Key BPEL Indicator (usefull to build a monitoring system with EM or Kibana, etc) | |
-- Replace soa_user with your own Oracle SOA Database Schema user | |
--Indentify bpel errors in the last 10 minutes | |
select ci.title, ci.ecid, cui.composite_name, cui.composite_revision, ci.created_time, | |
(SELECT count(1) FROM soa_user.REFERENCE_INSTANCE ri WHERE ri.ecid = ci.ecid and error_message is not null) + | |
(select count(1) from soa_user.bpel_faults_vw bf where bf.ecid = ci.ecid) as nbfaults | |
from soa_user.composite_instance ci | |
inner join soa_user.cube_instance cui on cui.ecid = ci.ecid | |
where (select count(1) from soa_user.bpel_faults_vw bf where bf.ecid = ci.ecid) !=0 | |
and ci.created_time >= sysdate - 10/(24*60); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!--fault-bindings.xml--> | |
<?xml version="1.0" encoding="UTF-8"?> | |
<faultPolicyBindings version="2.0.2" | |
xmlns="http://schemas.oracle.com/bpel/faultpolicy" | |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> | |
<composite faultPolicy="Faults_Policy"/> | |
</faultPolicyBindings> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Maven package Java | |
# Build your Java project | |
# Add steps that analyze code, save build artifacts, deploy, and more: | |
# https://docs.microsoft.com/azure/devops/pipelines/languages/java | |
trigger: | |
- master | |
variables: | |
# Agent VM image name |
NewerOlder