TCPS SSL connection core dumps

From: <dbaplusplus_at_hotmail.com>
Date: 29 May 2006 14:06:40 -0700
Message-ID: <1148936800.011582.52750@i39g2000cwa.googlegroups.com>

I am using Oracle 9.2.0.5 on HP UNIX 11i.

I am trying to use SSL. I have setup certificates etc using Oracle instructions. When I connect without SSL (i.e., TCP protocol), everything works fine.

Sqlplus hrdb/hrdb_at_pdev

However, when I connect using ssl:

pdev=>sqlplus hrdb/hrdb_at_pdev_ssl

SQL*Plus: Release 9.2.0.5.0 - Production on Mon May 29 16:50:36 2006

Illegal instruction(coredump)

COredump apperas to be some kind of shared libraray problem, but I don't know what?

I have setup:
LD_LIBRARY_PATH=/oracle/product/9.2.0/lib:/oracle/product/9.2.0/lib32 SHLIB_PATH=/oracle/product/9.2.0/lib32:/oracle/product/9.2.0/lib

When I run adapters command, I do see: Installed Oracle Net transport protocols are:

    IPC
   IPC
    BEQ
    TCP/IP
    SSL
    RAW Installed Oracle Net naming methods are:

    Local Naming (tnsnames.ora)
    Oracle Directory Naming
    Oracle Host Naming
    Oracle Names Server Naming

Installed Oracle Advanced Security options are:

    RC4 40-bit encryption
    RC4 56-bit encryption
    RC4 128-bit encryption
    RC4 256-bit encryption
    DES40 40-bit encryption
    DES 56-bit encryption
    3DES 112-bit encryption
    3DES 168-bit encryption

    AES 128-bit encryption
    AES 192-bit encryption
    AES 256-bit encryption

MD5 crypto-checksumming
SHA-1 crypto-checksumming
pdev=>

So what could be wrong.

Any help will be appreciated.

**************************** listener.ora
********************************

# LISTENER.ORA Network Configuration File: /devdb/oracle/network/admin/listener.ora # Generated by Oracle configuration tools.

WALLET_LOCATION =
  (SOURCE =
    (METHOD = FILE)
    (METHOD_DATA =
(DIRECTORY = /devdb/oracle/wallet)
    )
  )

LISTENER_SSL =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pqmss01.na.jnj.com)(PORT =
9010))

)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = pqmss01.na.jnj.com)(PORT =
2484))

)
)

SID_LIST_LISTENER_SSL =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = pdev.na.jnj.com)
(ORACLE_HOME = /oracle/product/9.2.0)
(SID_NAME = pdev)

    )
  )

sqlnet.ora ********************************* # SQLNET.ORA Network Configuration File: /devdb/oracle/network/admin/sqlnet.ora # Generated by Oracle configuration tools.

WALLET_LOCATION =
  (SOURCE =
    (METHOD = FILE)
    (METHOD_DATA =
(DIRECTORY = /devdb/oracle/wallet)
    )
  )
SSL_CLIENT_AUTHENTICATION = TRUE
SSL_VERSION = 3.0
SQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS, TCP) NAMES.DIRECTORY_PATH=(TNSNAMES)
SSL_SERVER_DN_MATCH = YES

tnsnames.ora
# Generated by Oracle configuration tools.

PDEV_SSL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = pqmss01.na.jnj.com)(PORT =
2484))

)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdev.na.jnj.com)

(SECURITY=(SSL_SERVER_CERT_DN="cn=pdev,cn=OracleContext,dc=na,dc=jnj,dc=com"))

)
)

PDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pqmss01.na.jnj.com)(PORT =
9010))

    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdev.na.jnj.com)

    )
  ) Received on Mon May 29 2006 - 16:06:40 CDT