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