Question about a local connection to a Oracle 64-bit database using a Oracle 32-bit client for Gen CSE

Document ID : KB000028828
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:
Windows CSE: Connecting to a Oracle 64-bit database with Oracle 32-bit client and using LOCAL connection.
According to the description of the option a. in TEC537685 the Net Service Name for the Encyclopedia Database (DBCSE) should be specified as the value of LOCAL environment variable.
However when different names are specified for each "Encyclopedia Database Name" and "Coordination Database Name" in the CSE configuration i.e. DBCSE for "Encyclopedia Database Name" , DBDIR for "Coordination Database Name", all tables are still created into the DBCSE database.
 
Answer:
If a standard “userid” is entered into the User ID field for each of Coordination & Encyclopedia dialogs, the LOCAL environment variable setting will be used for the target database because Oracle Net looks for the value of LOCAL/TWO_TASK when there is a standard userid/password connection using ORACLE_SID.
In above example because DBCSE is specified as the Net Service name in LOCAL that is used as the target database for all tables.
If the tables are required to be created in separate Coordination & Encyclopedia Databases, then separate Net Service names for each database should be specified with the option b. in TEC537685 and LOCAL should not be set.