Forum Stats

  • 3,839,156 Users
  • 2,262,456 Discussions
  • 7,900,869 Comments

Discussions

Native Oracle XML DB Web Service

aebrigham
aebrigham Member Posts: 4 Green Ribbon

Trying to determine where in the configuration of the Native Oracle XML DB Web Service does it know which database to communicate with by default, and how would you specify a different Instance?

If I submit the POST with the following SOAP Body with query text

      <query_text type="SQL">

        select * from v$instance

      </query_text>

How does it know the INSTANCE_NAME in the result, and if I wanted MYDB2 instead of MYDB, how would I achieve this?

      <ROWSET>

        <ROW>

          <INSTANCE_NUMBER>1</INSTANCE_NUMBER>

          <INSTANCE_NAME>MYDB</INSTANCE_NAME>

          <HOST_NAME>MYHOST</HOST_NAME>

          <VERSION>12.1.0.2.0</VERSION>

          <STARTUP_TIME>17-DEC-20</STARTUP_TIME>

          <STATUS>OPEN</STATUS>

          <PARALLEL>NO</PARALLEL>

          <THREAD_x0023_>1</THREAD_x0023_>

          <ARCHIVER>STARTED</ARCHIVER>

          <LOGINS>ALLOWED</LOGINS>

          <SHUTDOWN_PENDING>NO</SHUTDOWN_PENDING>

          <DATABASE_STATUS>ACTIVE</DATABASE_STATUS>

          <INSTANCE_ROLE>PRIMARY_INSTANCE</INSTANCE_ROLE>

          <ACTIVE_STATE>NORMAL</ACTIVE_STATE>

          <BLOCKED>NO</BLOCKED>

          <CON_ID>0</CON_ID>

          <INSTANCE_MODE>REGULAR</INSTANCE_MODE>

          <EDITION>EE</EDITION>

        </ROW>

      </ROWSET>

Tagged:

Best Answers

  • aebrigham
    aebrigham Member Posts: 4 Green Ribbon
    Answer ✓

    Just an update, and thank-you @Billy Verreynne, you lead me in the right direction, I was able to solve my issue. I executed the following commands...

    ALTER SYSTEM SET LOCAL_LISTENER='LISTENER_MYDB2';

    /

    BEGIN

      DBMS_XDB_CONFIG.SETHTTPSPORT(8444);

    END;

Answers