Error while running the SOA ORDERBOOKING TUTORIAL
660264Jan 20 2009 — edited Jan 21 2009Hi,
I have created the SOA ORDER BOOKING Tutorial sucessfully with our any ERRORS. While running the Deployed process iam getting the following errors :
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR:--
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
file:/<orahome>/bpel/domains/default/tmp/.bpel_SOAOrderBooking_1.0_937b09d1bd8dae1b33b028b2871aef63.tmp/OrderSequence.wsdl [ OrderSequence_ptt::OrderSequence(OrderSequenceInput_msg,OrderSequenceOutputCollection) ] - WSIF JCA Execute of operation 'OrderSequence' failed due to: Could not create/access the TopLink Session.
This session is used to connect to the datastore. [Caused by: Listener refused the connection with the following error:
ORA-12516, TNS:no appropriate service handler found
The Connection descriptor used by the client was: mydomain.com:1522:XE
]
; nested exception is:
ORABPEL-11622
Could not create/access the TopLink Session.
This session is used to connect to the datastore. [Caused by: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
mydomain.com:1522:XE
]
See root exception for the specific exception. You may need to configure the connection settings in the deployment descriptor (i.e. $J2EE_HOME/application-deployments/default/DbAdapter/oc4j-ra.xml) and restart the server. Caused by Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.3.0) (Build 070608)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
mydomain.com:1522:XE.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
My database is up and i have tested the connection that i have created (jdbc/soademo) . Every thing is working fine.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsnrctl services:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<oraclehome>\BIN>lsnrctl services
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-JAN-2009 15:10
:01
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: mymachine, pid: 7540>
(ADDRESS=(PROTOCOL=tcp)(HOST=mydomain.com)(PORT=1271))
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:138 refused:0 state:ready
LOCAL SERVER
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:138 refused:0 state:ready
LOCAL SERVER
The command completed successfully
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Can anyone help me out with this problem.