Current Position:Home > Is there any query to get all faulted instance Ids which should be recoverd

Is there any query to get all faulted instance Ids which should be recoverd

Update:11-30Source: network consolidation
Advertisement
Hi All,
I am working on a production Environment. I have four managed servers. Since the integration involves invoking legacy systems we are encountering either the JCA error or siebel adapter error ... so we wanted to recover as soon as faulted.If i have one managed servers i can easily find out the faulted instances .. since it was having four managed servers and more than 25 soa projects ... difficult to track it .... i need to click on each of the managed servers and get the faulted instances and recover it ...
Can we have a query which shows all faulted instances in managed servers so that i can go directly to COMPOSITE ID and recover it..instead of going to all the 25 soa managed projects...and recovering it.
Thanks in Advance,
Venugopal SSS Raja

The Best Answer

Advertisement
Hi Venu,
If I can understand your use case correctly, you want to monitor the status of the WLS instances.
If yes, then you can use WLST to connect to the server and fetch the status. You can change this script to fetch the information of all servers and display at once.
There is an example given @ http://weblogic-wonders.com/weblogic/2011/03/16/weblogic-server-state-using-wlst/
See if this helps.
Thanks,
Patrick
  • Is there any query to get all faulted instance Ids which should be recoverd Update:11-30

    Hi All, I am working on a production Environment. I have four managed servers. Since the integration involves invoking legacy systems we are encountering either the JCA error or siebel adapter error ... so we wanted to recover as soon as faulted.If i

  • How to create incident rule for SOA composite faulted instances Update:11-30

    Hi Experts, How can I create an incident rule for creating an incident when a SOA composite instance goes faulted. I want to notify the administrator when any of the SOA composite instance gets faulted but I am not able to undestand in my incident ru

  • Query works fine in DEV instance but not in PROD instance Update:10-11

    Hi, I got an exceptional situation. I wrote a query to get the sign-on audit information. The query works fine in Development instance and executes within 2 seconds. But if i run the same query in production instance it does not finish execution. I c

  • Store only the faulted instances and related  payload Update:11-30

    I'm working 0n soa 11.1.1.5 version.I have to store only the faulted instances and related payload in the database.I have configured the below properties in my composite.xml file <component name="BPELProcess" version="2.0"> <i

  • Query for updating prices if product IDs same Update:11-30

    I have a large Windows SQL 2000 database of products that need to have 2007 prices. I have another Windows SQL 2000 database that has the correct prices that I can import into Windows SQL 2000 as a new table. I want to be able to UPDATE the Prices wh

  • Query performance slow in one instance in RAC Update:11-30

    Hi We have 3 node RAC. When we test onw query it slow by 40% in one instance and always physical reads are hapenning in that instance. Below are the details. All the parameters are same. Users compains some times the query is slow. Thanks in Advance.

  • Querying v$lock table causes instance CPU to jump Update:11-30

    Hi all. I run several queries to find out metrics on my Oracle instance for monitoring purposes. One of the queries I tried using to give me a PercentLockutilization is SELECT round(NVL((count(b.sid)/a.value)*100,0.0),3) "Pct Lock Utilization" F

  • SQL to retrieve faulted instances and fault reason code for SOA composites Update:11-30

    Hi, Could you please provide me some SQL which will retrieve composite faults with details on a particular period? Thanks in advance.SELECT ID, COMPOSITE_DN, STATE, CREATED_TIME FROM COMPOSITE_INSTANCE. You can add filters for created_time and state.

  • Same Query...Same DB Instance....Different results Update:11-30

    Hi, I'm running into an issue in which I'm seeing inconsistent results. If I run a query against a static table (fully committed) sometimes I receive one result set and at other times I receive another result set.This does not seem to be limited to a

  • How to avoid saving mediator faulted instances in DB Update:11-30

    Hello All, I've the requirement of avoid saving data instance in the DB, because in my project is more important performance than instance tracking. I configured the general audit level in EM console and the specify audit level for bpel and mediator