Skip to Main Content

Database Software

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!

XMLDB Web Service Acccessability On New Server

tc441059inMar 12 2012 — edited Mar 15 2012
I followed the XMLDB Web Services setup here http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb_web_services.htm. It worked just fine and I was able access the WSDL using the username:password@host:8080/orawsv/schema/pacakge_name?wsdl format.

I've setup a new server, same OS, same database version and used the RMAN duplicate database to transfer the database onto the new server. Now when I use http://username:password@new_host:8080/orawsv/schema/package_name?wsdl I get an "unable to connect" error - "can't establish a connection to the server new_host:8080"

I've verified that the setup is still correct:
sys> SELECT dbms_xdb.gethttpport FROM dual;

GETHTTPPORT
-----------
       8080


sys> XQUERY declare default element namespace "http://xmlns.oracle.com/xdb/xdbconfig.xsd"; (: :)
  2         (: This path is split over two lines for documentation purposes only.
  3            The path should actually be a single long line. :)
  4         for $doc in fn:doc("/xdbconfig.xml")/xdbconfig/sysconfig/protocolconfig/httpconfig/
  5          webappconfig/servletconfig/servlet-list/servlet[servlet-name='orawsv']
  6         return $doc
  7  /

Result Sequence
----------------------------------------------------------------------------------------------------------------

<servlet xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd">
  <servlet-name>orawsv</servlet-name>
  <servlet-language>C</servlet-language>
  <display-name>Oracle Query Web Service</display-name>
  <description>Servlet for issuing queries as a Web Service</description>
  <servlet-schema>XDB</servlet-schema>
  <security-role-ref>
    <description/>
    <role-name>XDB_WEBSERVICES</role-name>
    <role-link>XDB_WEBSERVICES</role-link>
  </security-role-ref>
</servlet>
Some things look OK, plus there doesn't appear to be anything during the setup that is either host or instance name specific. So I am a little at a loss why this error is happening. I tried rerunning the
DECLARE
  l_servlet_name VARCHAR2(32) := 'orawsv';
BEGIN
  DBMS_XDB.deleteServletMapping(l_servlet_name);

  DBMS_XDB.deleteServlet(l_servlet_name);

  DBMS_XDB.addServlet(
    name     => l_servlet_name,
    language => 'C',
    dispname => 'Oracle Query Web Service',
    descript => 'Servlet for issuing queries as a Web Service',
    schema   => 'XDB');

  DBMS_XDB.addServletSecRole(
    servname => l_servlet_name,
    rolename => 'XDB_WEBSERVICES',
    rolelink => 'XDB_WEBSERVICES');

  DBMS_XDB.addServletMapping(
    pattern => '/orawsv/*',
    name    => l_servlet_name);
END;
/
command and I still get the connection error.

Does anyone have any suggestions of things to try or look at next?

Regards, Tony
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2012
Added on Mar 12 2012
9 comments
717 views