Oracle Database Discussions

Hi all.

We migrated from 9i 32bit to 11g 64bit almost successfully. Except one thing

We have a package that uses external (native linux) library libcrypt.so for passwords encryption.

Now while executing

select pwd_utils.crypt('123') from dual

i get

SQL Error: ORA-28575: unable to open RPC connection to external procedure agent

i've already googled and searched this forum for solution, but failed.

All recommendations are about listener config, but i think our config is correct:

listener.ora:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(SDU = 32767)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32767)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product)
(PROGRAM = extproc)
(ENVS="EXTPROC_DLLS=ANY")
)
)

CONNECT_TIMEOUT = 60

and

tnsnames.ora:


ORCL =
(DESCRIPTION =
(SDU = 32767)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
(SERVER = DEDICATED)
)
)

INST1_HTTP =
(DESCRIPTION =
(SDU = 32767)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(SDU = 32767)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

also, tnsping extproc_connection_data works fine:

$ tnsping extproc_connection_data

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 11-JUL-2010 16:55:54

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32767) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO)))
OK (0 msec)

OS Info: ubuntu 10.04 LTS, kernel version 2.6.32-22-generic-pae

Thank you in advance.