{"id":1835,"date":"2010-10-15T15:25:40","date_gmt":"2010-10-15T20:25:40","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=1835"},"modified":"2011-01-03T15:52:18","modified_gmt":"2011-01-03T20:52:18","slug":"oracle-soa-10g-bpel-error-no-domains-accessible-to-the-user-logged-in","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=1835","title":{"rendered":"Oracle SOA 10g BPEL Error: No domains accessible to the user logged in."},"content":{"rendered":"

Error Message<\/h2><\/span>\n

When logging into BPEL console, got an error message<\/p>\n

No domains accessible to the user logged in.<\/pre>\n
Case One<\/h2><\/span>\n
* XP machine.
\n* Oracle 10g DB
\n* SOA 10.1.3.5<\/p>\n
Troubleshooting<\/h3><\/span>\n
* Check BPEL domain log:
\nC:\\product\\10.1.3.1\\OracleAS_2\\bpel\\domains\\default\\logs\\domain.log<\/p>\n
* Check BPEL system log:
\nC:\\product\\10.1.3.1\\OracleAS_2\\bpel\\system\\logs\\orabpel.log
\nC:\\product\\10.1.3.1\\OracleAS_2\\bpel\\system\\logs\\log.xml<\/p>\n
* Check opmn log for oc4j_soa:
\nC:\\product\\10.1.3.1\\OracleAS_2\\opmn\\logs\\default_group~oc4j_soa~default_group~1.log
\nand found:<\/p>\n
\r\n10\/10\/15 13:44:59 java.sql.SQLException: Io exception: The Network Adapter could not establish the connection\r\n10\/10\/15 13:44:59 \tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)\r\n...\r\nCannot lookup datasource type.\r\nThe process domain was unable to determine the database type.  The version table contains the vendor type for the current datasource.  The exception reported is: Cannot fetch a datasource connection.\r\nThe process domain was unable to establish a connection with the datasource with the connection URL \"jdbc\/BPELServerDataSourceWorkflow\".  The exception reported is: Io exception: The Network Adapter could not establish the connection\r\nPlease check that the machine hosting the datasource is physically connected to the network.  Otherwise, check that the datasource connection parameters (user\/password) is currently valid.\r\n\r\nPlease check that:\r\n     + the machine hosting the datasource is physically connected to the network.\r\n     + the connection pool properties as defined in the application server startup properties are valid.\r\n     + the database schema for OraBPEL has been installed in the datasource.\r\n<\/pre>\n
* Check oc4j_soa log.xml:
\nC:\\product\\10.1.3.1\\OracleAS_2\\j2ee\\oc4j_soa\\log\\oc4j_soa_default_group_1\\oc4j\\log.xml
\nand found:<\/p>\n
\r\n    2010-10-15T13:44:22.281-04:00<\/TSTZ_ORIGINATING>\r\n    tip<\/COMPONENT_ID>\r\n    <\/MSG_TYPE>\r\n    1<\/MSG_LEVEL>\r\n    esb.server.bootstrap<\/MODULE_ID>\r\n    11<\/THREAD_ID>\r\n    SYSTEM<\/USER_ID>\r\n  <\/HEADER>\r\n  \r\n    1277827932:82234:1287164655750:1<\/UNIQUE_ID>0<\/SEQ><\/EXEC_CONTEXT_ID>\r\n  <\/CORRELATION_DATA>\r\n  \r\n    ESB bootstrap: Failed to start ESB server as the repository is not reachable<\/MSG_TEXT>\r\n    \r\n  <\/PAYLOAD>\r\n<\/pre>\n
* Check oc4j_soa coreman.log:
\nC:\\product\\10.1.3.1\\OracleAS_2\\j2ee\\oc4j_soa\\log\\coreman.log
\nand Found:<\/p>\n
\r\ntarget exception:\r\n\r\njava.sql.SQLException: Listener refused the connection with the following error:\r\nORA-12514, TNS:listener does not currently know of service requested in connect descriptor\r\nThe Connection descriptor used by the client was:\r\n\/\/localhost:1521\/orcl\r\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)\r\n<\/pre>\n
Resolution<\/h3><\/span>\n
* Check database is up and running.
\n* Check logging into orabpel user.
\n* Restart SOA.<\/p>\n
Case Two<\/h2><\/span>\n
* Solaris OS
\n* Oracle 10g DB
\n* SOA 10.1.3.5<\/p>\n
Troubleshoot<\/h3><\/span>\n
* vi j2ee\/oc4j_soa\/log\/oc4j_soa_default_group_1\/oc4j\/log.xml<\/p>\n
\r\n\r\n  
\r\n    2010-10-15T19:34:44.447+00:00<\/TSTZ_ORIGINATING>\r\n    tip<\/COMPONENT_ID>\r\n    <\/MSG_TYPE>\r\n    1<\/MSG_LEVEL>\r\n    myhost<\/HOST_ID>\r\n    192.168.1.10<\/HOST_NWADDR>\r\n    esb.server.service.impl.soap<\/MODULE_ID>\r\n    10<\/THREAD_ID>\r\n    oracle<\/USER_ID>\r\n  <\/HEADER>\r\n  \r\n    1483312815:87239:1287171244788:0<\/UNIQUE_ID>34<\/SEQ><\/EXEC_CONTEXT_ID>\r\n  <\/CORRELATION_DATA>\r\n  \r\n    Registering ESB services to Oracle SOAP Provider failed<\/MSG_TEXT>\r\n    \n
Resolution<\/h3><\/span>\n
* Update orabpel password by editing system-jazn-data.xml file.
\nvi j2ee\/oc4j_soa\/config\/system-jazn-data.xml<\/p>\n
\r\n\r\n  pwForOrabpel<\/name>\r\n  120C6951EB9511DCBFF1AD21958DF927<\/guid>\r\n  !myBpelPassword<\/credentials>\r\n<\/user>\r\n<\/pre>\n
Notice the '!' before the new password so that the password will get encrypted when oc4j is restarted.
\n* Check same password is used in j2ee\/oc4j_soa\/config\/data-sources.xml<\/p>\n
\r\n\r\n  \r\n<\/connection-pool>\r\n<\/pre>\n
* Restart
\nopmnctl stopall
\nopmnctl startall<\/p>\n
References<\/h2><\/span>\n
* http:\/\/sathyam-soa.blogspot.com\/2009\/01\/oracle-bpel-console-throws-no-domains.html<\/a>
\n* http:\/\/onlineappsdba.com\/index.php\/2009\/04\/14\/how-to-reset-orabpel-oraesb-password-in-soa-suite-1013x\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Error Message When logging into BPEL console, got an error message No domains accessible to the user logged in. Case One * XP machine. * Oracle 10g DB * SOA 10.1.3.5 Troubleshooting * Check BPEL domain log: C:\\product\\10.1.3.1\\OracleAS_2\\bpel\\domains\\default\\logs\\domain.log * Check … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[73,69],"tags":[],"class_list":["post-1835","post","type-post","status-publish","format-standard","hentry","category-errors","category-oc4j"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-tB","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1835"}],"version-history":[{"count":8,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1835\/revisions"}],"predecessor-version":[{"id":1878,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1835\/revisions\/1878"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}