Article

Getting error (1252) when connecting to an Oracle 10g or 11g database when Oracle 9i is also installed

« Go Back

Information

 
Article Number000010123
EnvironmentOracle 9i and 10g/11g are both installed on the machine
Oracle 9i
Oracle 10g
Oracle 11g
Oracle DataServer
Windows
Question/Problem Description
Getting error (1252) when connecting to an Oracle database via the unified Oracle DataServer broker
Could not connect to "<Database name>" as user "<User name>"

 

ORACLE error see "ORACLE Error Messages and Codes Manual". (1252)


The dataserv.lg contains the following messages:
Using shared library d:\oracle\ora92\bin\OCI.DLL (oci 8.1)
ORACLE_HOME set to 'c:\oracle\product\10.1.0'
Login failure: ÊÀqŠŠ
BROKER: The server could not open the foreign database. (1891)
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
The DataServer engine picks the wrong OCI. The shared library OCI.DLL from Oracle 9i is used instead of the one from Oracle 10g.
Resolution

In order for the dataserver to select the dll you do not need to modify the PATH as previously suggested but by setting environment variable "ORADLLPATHNAME"..

 

 

For example, if oci.dll is available in c:\oracle\oracle11rg-32\bin\ directory, then %ORADLLPATHNAME% should be

 

c:\oracle\ oracle11rg-32\bin\oci.dll

Also make sure that the ORACLE_HOME environment variable matches Environment property of the unified Oracle DataServer broker.

Modify the value of the ORACLE_HOME environment variable of the unified Oracle DataServer broker from the Progress Explorer tool, and point it to the correct Oracle directory.

This value can be found in the registry:
      HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORACLE_HOME

Workaround
Notes
Attachment 
Last Modified Date9/13/2015 3:38 PM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025