Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while running the SOA ORDERBOOKING TUTORIAL

660264Jan 20 2009 — edited Jan 21 2009
Hi,
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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 17 2009
Added on Jan 20 2009
2 comments
898 views