Thursday, November 26, 2009

No domains accessible to the user logged in-BPEL console issue

YOu have done a fresh install of SOA Suite and when trying to open the bpel console it is giving following error.


No domains accessible to the user logged in.

What does it mean.

The domains are not accessible that means the process is not able to get the data from the schemas in database.so you need to check if your database and listener is up and running or not and you need to check your data source.

Go to your em console

The container usually oc4j_soa

go to administration tab and go to task in jdbc resouces.

If issue is there in bpel console check the connection pool

BPELPM_COnnection_POOL


Then check the data sources which are associated with this connectin pool if they are all up and running.

If test does not succed.Check the user and password.

Check the URL which contains the information about the database where the port and SID mentioned in the URL are correct or not.


Correct it and test the connection again.REstart the server and you will be able to log in to the bpel console.


In the worst case your schema might have corrupted so you need to drop you shcmea and recreate it.Before dropping schema please stop the SOA suite.

Got o data base.Log in as sys as sysdba

and do

drop user orabpel cascade
drop user oraesb cascade
drop user orawsm cascade

One schema gets delete.go to SOA Suite irca.bat and run it to recreate the schemas.

Then start your SOA suite got to em console and point the connection to the new schema created.

Again restart the server and check u will be able to log in to the bpel console.

No comments: