000017427 - Oracle Listener refusing the connection request from Websphere - RSA Adaptive Authentication (On Premise)

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000017427
Applies ToRSA Adaptive Authentication (On Premise) 

The database server and connect descriptor must be configured in Websphere according to the Installation Guide for your AA version/service pack.  This manual will contain the instructions for configuring Websphere for Oracle. 

In v6.0.2.1, that is in the System Installation Guide, chapter 5, "Installing on IBM WebSphere", section "Setting Up an IBM WebSphere Application Server", subsection "Setting Up WebSphere with Oracle".

In v6.0.2.1 SP2, that is in the RSA Adaptive Authentication (On-Premise) 6.0.2.1 SP2 Installation Guide, Appendix B "Setting Up the Application Servers", section "Setting Up WebSphere with Oracle".  For v6.0.2.1 SP1 the equivalent is in Chapter 11.

In v7.0, that is in the RSA? Adaptive Authentication (On-Premise) 7.0 Installation and Upgrade Guide , Appendix A "Setting Up the Application Servers", section "Setting Up Websphere with Oracle".

IssueOracle Listener refusing the connection request from Websphere

Websphere log shows Oracle ORA-12514 errors and IBM DSRA0010E errors such as:

WARN [server.startup : 1] [] [] [org.hibernate.util.JDBCExceptionReporter] - <SQL Error: 12514, SQLState: 66000>
ERROR [server.startup : 1] [] [] [org.hibernate.util.JDBCExceptionReporter] - <Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
DSRA0010E: SQL State = 66000, Error Code = 12,514>
WARN [server.startup : 1] [] [] [org.hibernate.cfg.SettingsFactory] - <Could not obtain connection metadata>
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
DSRA0010E: SQL State = 66000, Error Code = 12,514

Cause

ORA-12514 is an Oracle database error code.  See Oracle? Database Error Messages manual for your Oracle version and release, for a description of ORA-12514.  You can also use the Oracle oraerr command to obtain this information.

DSRA0010E is an IBM Websphere message code.  See the IBM Websphere Application Server Messages manual for your Websphere version, for a description of DSRA0010E.


The connect descriptor configured in Websphere for AA does not match any of the database services configured for the Oracle listener process on the specified database server.
One possible cause is an incorrectly applied Oracle bug fix for CVE-2012-1675 (at http://www.oracle.com/technetwork/topics/security/alert-cve-2012-1675-1608180.html) .
Resolution

Suggested diagnostic steps:

  • Check which services are currently known to the listener by executing the followig Oracle command on your database server:  lsnrctl services
  • Check that the connection to the database is correctly configured according to the instructions in the Installation Guide for your AA version.
  • Check for any relevant event in the Oracle listener.log file.  Location of the listener.log is part of the output of the Oracle command:  lsnrctl status
Legacy Article IDa66532

Attachments

    Outcomes