Problem: Using Multiple Oracle Instances with ArcStorm

Solution or Workaround

Problem

There are two Oracle instances, 'oracle1' and 'oracle2' and two ArcStorm databases, called 'asdb1' and 'asdb2'. When registering 'oracle1' tables to 'asdb1' and 'oracle2' tables to 'asdb2', and starting wservice, it can only register to 'oracle1' tables with either 'asdb1' and 'asdb2'.

Cause

The Oracle environmental variable ORACLE_SID has been explicitly set.

Solution

Do not set the Oracle environmental variable ORACLE_SID. Instead, specify the Oracle instance to be used in SETCONNECTINFO.

For example, if SQL*NET version 1 is being used,

SETCONNECTINFO oracle storm/storm@T:node:sidname

where 'sidname' is the Oracle instance.

Note:
Consult Oracle documentation for additional information regarding how to specify an Oracle instance during connections.

Article ID:000001372

Software:

Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Using multiple Oracle instances with ArcStorm

Solution or Workaround

Discover more on this topic