Forum Stats

  • 3,782,263 Users
  • 2,254,627 Discussions
  • 7,880,030 Comments

Discussions

Error while running the SOA ORDERBOOKING TUTORIAL

660264
660264 Member Posts: 6
edited Jan 21, 2009 5:14AM in SOA Suite Discusssions
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.

Answers

  • 486536
    486536 Member Posts: 3
    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
  • 660264
    660264 Member Posts: 6
    edited Jan 21, 2009 5:14AM
    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.