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>