Kbase 19076: Connecting To Two Oracle Schema Holders With The Same Oracle Instance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/21/2003 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
User is trying to connect to than one schema image that uses the same instance, via the same Progress session
User can only connect to 1 Oracle database locally for update. Error 1259 is encountered when trying to connect to a second Oracle database locally.
You can NOT connect to more than one local ORACLE database for updates at a time. (1259)
FIX:
To avoid this, do the following:
1. Make sure that each Oracle database has a unique logical database name. 2. To modify the logical name, refer to Solution 18896
3. All connection to Oracle must be via SQL*Net or Oracle DataServer broker.