ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 187431

calendar_today

Updated On:

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? 

 

 

 

 

Cause

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

Environment

Release : 9.1

Component : RiskMinder(Arcot RiskFort)

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