Kbase P176293: Client session freezes when connecting to Oracle database via Dataserver broker
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2010 |
|
Status: Unverified
SYMPTOM(s):
Client session freezes when connecting to Oracle database via Dataserver broker
Broker process spawns _ORASRV process indicating that the broker has processed the connection request
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- Parent pid = 8140 child is 8141
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- Child pid = 8141
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- Remote ORACLE server begin. (1897)
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- Executable was compiled on Feb 9 2010 at 19:38:10 (5067)
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- Login to dataserver db as user X. (2689)
[YY/MM/DD@HH:MM:SS.###+0100] P-002964 T-000001 1 BROKER -- ORACLE server is spawned. (1892)
[YY/MM/DD@HH:MM:SS.###+0100] P-002964 T-000001 1 BROKER -- Server pid is 8140 (1994)
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- ORASRV version 15 (6440)
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- Using shared library /oracle/app/oracle/product/11.1.0/lib32/libclntsh.so (oci 8.1) (14874)
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- ORACLE_HOME set to '/oracle/app/oracle/product/11.1.0' (14875)
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- ORACLE_SID set to 'oracle11' (14877)
[YY/MM/DD@HH:MM:SS.###+0100] P-008140 T-000001 1 ORA -- OCI call OCIHandleAlloc <0>
Local connection on SOLARIS using SQLPLUS with SQL*NET works
Local connection (client => schema holder => Oracle) on SOLARIS with SQL*NET (i.e username@orainstance) works
Local connection (client => schema holder => Oracle) on SOLARIS without SQL*NET works
Remote connection (client => schema holder => _probrkr => _orasrv => Oracle) on SOLARIS using SQL*NET results fails with errors 1252 and 1451
"ORACLE error -1012 see "ORACLE Error Messages and Codes Manual". (1252)
** not logged on
Failed to connect to ORACLE database ocustima. (1451)
Affects 32-bit and 64-bit DataServer for Oracle product
Stack trace from _ORASRV generated with kill -9 appears to show that the hang is occurring in Oracle libraries
FACT(s) (Environment):
OpenEdge 10.1C
OpenEdge 10.2x
Solaris 10
Oracle 11g
CAUSE:
Bug# OE00175173
FIX:
Use Oracle SQL*Net connectivity