2 Replies Latest reply: Apr 23, 2013 3:17 PM by user12040707 RSS

    Calling RESTful webservice getting ORA-01017: invalid username/password

    user12040707
      Calling RESTful webservice getting ORA-01017: invalid username/password

      Oracle Environment:
      Database 11.2.0.2
      Application Express 4.2.0
      apex_listener.2.0.1.64.14.25 - standalone


      Using generator: oracle.dbtools.rt.plsql.AnonymousBlockGenerator
      Performing JDBC request as: ABC
      </pre>
                          </p>
                          <p>
                          <pre>WebException [statusCode=503]
      Performing JDBC request as: ABC
      Caused by: oracle.dbtools.common.jdbc.ConnectionPoolException:
      The pool named: apex_rt is not correctly configured, error: ORA-01017: invalid username/password; logon denied


      Content of apex_rt.xml:

      <?xml version="1.0" encoding="UTF-8" standalone="no"?>
      <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
      <properties>
      <comment>Saved on Fri Apr 19 07:32:43 PDT 2013</comment>
      <entry key="db.password">@0536E4B04262FE7A14DC9BF15C8819E2AB58DC35F7AE96E479</en
      try>
      <entry key="db.username">APEX_REST_PUBLIC_USER</entry>
      </properties>


      When exporting the rest module, the parsing schema is set to ABC.
      This value is actually the workspace schema.

      wwv_flow_api.create_restful_module (
      p_id => 2632627939868451 + wwv_flow_api.g_id_offset
      ,p_name => 'clarity'
      ,p_parsing_schema => 'ABC'
      ,p_items_per_page => 25
      ,p_status => 'PUBLISHED'
      );

      It is unclear to me where to define APEX_REST_PUBLIC_USER as the value for parsing schema for the rest modules,
      do anyone know how to do this?
        • 1. Re: Calling RESTful webservice getting ORA-01017: invalid username/password
          Colm Divilly-Oracle
          user12040707 wrote:
          Calling RESTful webservice getting ORA-01017: invalid username/password

          Oracle Environment:
          Database 11.2.0.2
          Application Express 4.2.0
          apex_listener.2.0.1.64.14.25 - standalone


          Using generator: oracle.dbtools.rt.plsql.AnonymousBlockGenerator
          Performing JDBC request as: ABC
          </pre>
                              </p>
                              <p>
                              <pre>WebException [statusCode=503]
          Performing JDBC request as: ABC
          Caused by: oracle.dbtools.common.jdbc.ConnectionPoolException:
          The pool named: apex_rt is not correctly configured, error: ORA-01017: invalid username/password; logon denied

          The user name and/or password (probably the password) for the APEX_REST_PUBLIC_USER is not specified correctly. The user name is correct below, so double check the password, confirm you can connect as this user using the password specified in apex_rt.xml, using SQLPLUS or SQL Developer.
          Content of apex_rt.xml:

          <?xml version="1.0" encoding="UTF-8" standalone="no"?>
          <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
          <properties>
          <comment>Saved on Fri Apr 19 07:32:43 PDT 2013</comment>
          <entry key="db.password">******</en
          try>
          <entry key="db.username">APEX_REST_PUBLIC_USER</entry>
          </properties>


          When exporting the rest module, the parsing schema is set to ABC.
          This value is actually the workspace schema.

          wwv_flow_api.create_restful_module (
          p_id => 2632627939868451 + wwv_flow_api.g_id_offset
          ,p_name => 'clarity'
          ,p_parsing_schema => 'ABC'
          ,p_items_per_page => 25
          ,p_status => 'PUBLISHED'
          );

          It is unclear to me where to define APEX_REST_PUBLIC_USER as the value for parsing schema for the rest modules,
          do anyone know how to do this?
          The Parinsg schema value is correct, the RESTful Service belongs to the workspace named ABC, when the SQL/PL-SQL defined in the RESTful Service is invoked, it will be invoked as the ABC database user, thus only tables/schemas etc. that ABC is authorized to access will be accessible.
          • 2. Re: Calling RESTful webservice getting ORA-01017: invalid username/password
            user12040707
            Thanks for the details, very helpful - have now resolved the issue