Products

CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort) CA Strong Authentication CA Rapid App Security CA Risk Authentication CA Advanced Authentication

Issue/Introduction

The environment is Oralce 19c and Riskminder version 9.1

I was trying to login to admin console to boot strap, but got errors to access the page.

Error Page Exception

SRVE0260E: The server cannot use the error page specified for your application to handle the Original Exception printed below.

Original Exception:

Error Message: java.lang.NullPointerException
Error Code: 500
Target Servlet: arcotadmin
Error Stack:
java.lang.NullPointerException
     at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:922)
     at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1235)
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
     at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:143)

When I look at the arcotadmin.log, it has oracle error to connect to the database.

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

)

Manually test, I was able to connect to the database without any issue.

../sbin/arwfutil vdb

Starting validation of WebFort database tables.

Output written to : /opt/CA/AdvAuth/logs/arcotwebfort-vdb-25-Mar-20.txt

Successfully validated WebFort database tables.

I don't see any misconfiguration in odbc.ini file or arcotcommon.ini. the configuration files will also be uploaded.

Any idea why it happened?

Environment

Release : 9.1

Component : RiskMinder(Arcot RiskFort)

Cause

The JDBC URL in arcotcommon.ini file is configured wrong. The URL has specified the SID but it is using the Servicename instead.

Resolution

The JDBC URL specified in arcotcommon.ini file is as follows -

URL.1=jdbc:oracle:thin:@host1ld297:1531:ARCOTDB

The above URL is fine if ARCOTDB is SID but if ARCOTDB is service name then the URL has to be in this format.

URL.1=jdbc:oracle:thin:@host1ld297:1531/ARCOTDB

Better way to specify the RAC URL is as follows in arcotcommon.ini file -

Specify a value for the URL parameter in the [arcot/db/primarydb] section. If necessary, also add it in the [arcot/db/backupdb] section of the INI file. Enter the URL in the following format:

URL.1=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=service_name)(SERVER=DEDICATED)))

For example:

URL.1=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.30.250.18)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=forwardinc)(SERVER=DEDICATED)))

Additional Information

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/advanced-authentication/9-1/installing/ca-strong-authentication-installation/strong-authentication-configuration-for-oracle-rac.html

Admin Console can't connect to the Oracle 19c database

Article ID: 187431

Updated On: