Kbase P131692: Unable to connect to remote Oracle instance when ORACLE_HOME is set to wrong location
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/23/2008 |
|
Status: Verified
SYMPTOM(s):
Unable to connect to remote Oracle instance
Oracle error - 1012 see "Oracle Error Messages and Codes Manual". (1252)
Failed to connect to ORACLE database . (1451)
Dataserv.lg file shows that ORACLE_HOME environment variable was set to incorrect location
15:06:08 (pid 3732) : Remote ORACLE server begin. (1897)
15:06:08 (pid 3732) : Executable was compiled on Nov 2 2007 at 20:21:26 (5067)
15:06:08 (pid 3732) : Login to dataserver db as user X. (2689)
15:06:08 (pid 3732) : ORASRV version 14 (6440)
15:06:08 (pid 3732) : Using shared library D:\oracle\product\10.2.0\client_1\bin\OCI.DLL (oci 8.1)
15:06:08 (pid 3732) : ORACLE_HOME set to 'C:\oracle'
15:06:08 (pid 3732) : Login failure:
15:06:08 (pid 3732) : -Dsrv qt_debug: 0 (0x0 None) (6489)
15:06:08 (pid 3732) : Cursor limit: 84 (-c setting) (6490)
15:06:08 (pid 3732) : BROKER: The server could not open the foreign database. (1891)
15:06:08 (pid 3732) : Logoff from dataserver db as user <userid>@<database-id>. (2690)
15:06:08 (pid 3732) : Remote ORACLE server end. (1898)
FACT(s) (Environment):
All Supported Operating Systems
Oracle DataServer
Client is attempting to connect to a remote Oracle instance
Oracle networking is used to establish a connection to the Oracle instance on the remote host
AdminServer is used to manage the Oracle DataServer broker
CAUSE:
In the ubroker.properties file ORACLE_HOME was set to incorrect location
FIX:
Inspect the properties of the Oracle DataServer broker (eg. orabroker1) in the ubroker.properties file and correct the value of the ORACLE_HOME environment variable.