Configuration:
- AC 6.1.1 (8770)
- rhel 7.3
- Oracle 12c
Issue:
We trying to connect Adobe Campaign to the oracle database with a TCPS connection, but it still not working.
My action:
- created the certificate
- create the wallet
- add the certificate to my trustore java (cacert)
- modify the tnsnames.ora
- create the slqnet.ora
-reboot the adobe campaign server
My files:
sqlnet.ora -->
SSL_VERSION=1.2
SSL_SERVER_DN_MATCH=NO
NAMES.DIRECTORY_PATH=(LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
SQLNET.WALLET_OVERRIDE=TRUE
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/etc/oracle/<%myNameWallet%>)))
SQLNET.AUTHENTICATION_SERVICES=(TCPS,NTS)
SSL_CLIENT_AUTHENTICATION=FALSE
SSL_CIPHER_SUITES=(SSL_RSA_WITH_AES_256_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA)
tnsnames.ora -->
<%myTnsName%>=(DESCRIPTION=(ADDRESS =(PROTOCOL=TCPS)(HOST=<%myHost%>)(PORT=<%myTcpsPort%>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<%myServiceName%>))(SECURITY=(SSL_SERVER_CERT_DN=<%myServerCert%>)))
Errors:
web log -->
2017-04-27 14:45:06.170+10 00001049 00001049 1 info log Starting 1 connection(s) on pool 'default <%myInstance%>' (Oracle, server='<%myTnsName%>', login='<%myLogin%>')
2017-04-27 14:45:06.261+10 00001049 00001049 1 error log ORA-210000 Oracle error: ORA-12518: TNS:listener could not hand off client connection (iRc=-2006)
2017-04-27 14:45:06.261+10 00001049 00001049 1 error log WDB-200000 Unable to connect to database '<%myTnsName%>' of type 'Oracle' with login '<%myLogin%>' (iRc=-2006)
2017-04-27 14:46:00.259+10 00001049 00001049 1 info log Stopping Web server (pid=4169, tid=4169)...
Do you have any idea for that ?
Thanks in advance.
Nolan