this is a follow up on This page isn’t redirecting properly.
a very simple test-case to reproduce this on 11.2.0.4 on linux x86_64:
in short, this generates a self-signed certificate and loads it to the oracle wallet ( thanks to tyler muth for providing the steps ).
wget http://www.openssl.org/contrib/ssl.ca-0.1.tar.gz tar -axf ssl.ca-0.1.tar.gz orapki wallet create -wallet . -pwd Welcome1 -auto_login orapki wallet add -wallet . -dn 'cn=blubb, ou=blubb, ou=blubb, dc=blubb, dc=blubb' -keysize 2048 -pwd Welcome1 orapki wallet export -wallet . -dn 'cn=blubb, ou=blubb, ou=blubb, dc=blubb, dc=blubb' -request certreq.crs -pwd Welcome1 cp certreq.csr ssl.ca-0.1/ cd ssl.ca-0.1/ ./new-root-ca.sh ./sign-server-cert.sh certreq cd .. orapki wallet add -wallet . -trusted_cert -cert ssl.ca-0.1/ca.crt -pwd Welcome1 orapki wallet add -wallet . -user_cert -cert ssl.ca-0.1/certreq.crt -pwd Welcome1 orapki wallet display -wallet .
once the wallet is ready adjust the sqlnet.ora for the database to include the following:
WALLET_LOCATION= (SOURCE=(METHOD=FILE)(METHOD_DATA= (DIRECTORY=[PATH_TO_YOUR_WALLET]))) SSL_CLIENT_AUTHENTICATION=FALSE
… and bounce the instance. bumm:
select * from v$wallet; * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 11336 Session ID: 36 Serial number: 57
this does not reproduce with 12.1.0.1
assigned to oracle development…
Update 2014-JUN-05: Bug 14327886 : ORA-7445 [__INTEL_NEW_MEMCPY()+52] AND ORA-03113 WITH SELECT ON V$WALLET