Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Error while running the SOA ORDERBOOKING TUTORIAL
660264
Member Posts: 6
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.
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.
Tagged:
Answers
-
Hi
Is your db listener listening on port 1522 or 1521? In the output of "lsnrctl services" that you have attached I do not see anything on 1522, the port that you have used in the DB connection -
Hi ,
I have installed Oracle database XE Edition on port 1522 as 1521 is used by olite database. Here is my listner status.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Listner Status
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<orahome>\BIN>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-JAN-2009 18:25
:05
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 19-JAN-2009 17:43:31
Uptime 1 days 0 hr. 41 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File <orahome>\network\admin\listener.ora
Listener Log File <orahome>\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mydomain.com)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Edited by: user9969930 on Jan 21, 2009 1:36 AM
This discussion has been closed.