Hello everyone,
I am testing the Pre-Built Developer VMs Oracle Database 12c (12.2.0.1.0) with native Web Services and I can't access the WSDL because I can't authenticate with any user, it always shows me the loging window.
I have configured Web Services for Oracle XML DB as we currently do in version 11.2.0.4, I have also reviewed the documentation for version 12:
https://docs.oracle.com/database/121/ADXDB/xdb_web_services.htm#GUID-8F1319B4-297E-461D-8F57-EAC4C63EBC03__CHDIICEJ
This is the script I used:
SQL> CONNECT / AS SYSDBA
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;
SQL> SELECT dbms_xdb.gethttpport FROM dual
GETHTTPPORT
---------------------------------------
9021
--Create a NOWS user
ALTER SESSION SET "_ORACLE_SCRIPT"=true;
CREATE USER nows IDENTIFIED BY passwd ACCOUNT UNLOCK PROFILE default;
GRANT RESOURCE, CREATE SESSION TO nows;
--Grants to xdb_webservices
GRANT xdb_webservices TO nows;
GRANT xdb_webservices_over_http TO nows;
GRANT xdb_webservices_with_public TO nows;
GRANT SELECT ON dual TO nows;
And now when I ask for the WSDL (http://localhost:9021/orawsv?wsdl) from the web browser I can't login with NOWS, nor with SYS. I never retrieve the WSDL and therefore I can't never invoke the web service.
Any idea? I am doing something wrong?
Thanks.