Consultor Eletrônico



Kbase P116470: AppServer agent cannot connect to remote Oracle instance
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   7/18/2008
Status: Unverified

SYMPTOM(s):

AppServer agent cannot connect to remote Oracle instance

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

Progress client (prowin32.exe) can connect to remote Oracle instance using Oracle networking

AppServer running on Windows

Not using the Adminserver administered Progress DataServer for Oracle broker

Executable was compiled on Dec 8 2005 at 21:26:58 (5067)
Login to dataserver db as user <username>@<oracle_sid>. (2689)
Unable to load shared library
11:04:01 : -Dsrv qt_debug: 0 (0x0 None) (6489)
11:04:01 : Cursor limit: 84 (-c setting) (6490)
11:04:01 : Logoff from dataserver db as user <username>@<oracle_sid>. (2690)


P-005180 T-004336 1 AS -- Logging level set to = 4
P-005180 T-004336 1 AS -- Log entry types activated: ASPlumbing,DB.Connects
P-005180 T-004336 2 AS AS Starting application server for asbrokerHO. (5560)
P-005180 T-004336 2 AS AS Application Server Startup. (5473)
P-005180 T-004336 2 AS CONN Connected to database <dbname>, user number <#>. (9543)
P-005180 T-004336 2 AS CONN Connected to database <dbname>, user number <#>. (9543)
P-005180 T-004336 2 AS CONN Connected to database <dbname>, user number <#>. (9543)
P-005180 T-004336 1 AS -- ORACLE error -1012 see "ORACLE Error Messages and Codes Manual". (1252)

FACT(s) (Environment):

Oracle DataServer
Windows NT 32 Intel/Windows 2000
OpenEdge 10.1A
Oracle 9i

CAUSE:

%ORACLE_HOME%\bin was not set or not correctly set.

FIX:

Add %ORACLE_HOME%\bin;%PATH% to the PATH environment variable in the AppServer's broker environment variables section.