Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Getting error while creating datasource in OBI console

Received Response
31
Views
5
Comments
User_B7ZTH
User_B7ZTH Rank 5 - Community Champion
edited Aug 13, 2024 5:41PM in Oracle Analytics Forum

Hello Experts,

We have upgraded our OBI environment to Oracle Business Intelligence 12.2.1.3.0.

We are getting below error while creating the datasource in OBI Console:-

Could not establish a connection because of java.lang.IllegalArgumentException: ONS configuration failed<br/>weblogic.jdbc.common.internal.DataSourceUtil.testConnection0(DataSourceUtil.java:423)<br/>weblogic.jdbc.common.internal.DataSourceUtil.access$000(DataSourceUtil.java:24)<br/>weblogic.jdbc.common.internal.DataSourceUtil$1.run(DataSourceUtil.java:285)<br/>java.security.AccessController.doPrivileged(Native Method)<br/>weblogic.jdbc.common.internal.DataSourceUtil.testConnection(DataSourceUtil.java:282)<br/>com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:937)<br/>com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:524)<br/>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br/>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br/>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br/>java.lang.reflect.Method.invoke(Method.java:498)<br/>org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:870)<br/>org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)<br/>org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)<br/>org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)<br/>org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)<br/>org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)<br/>org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)<br/>org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)<br/>org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)<br/>...

I have tried to google it and got the below link

https://stackoverflow.com/questions/48294023/weblogic-12c-database-connection-error

But its not helping we are getting the same error.

Can anyone have idea, do i need to configure anything extra in configuration file.

Thanks & Regards,

Abhi

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    3521884 wrote:We are getting below error while creating the datasource in OBI Console:-

    I guess you mean the Weblogic console?

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    Hello Berg,

    yes, you are correct, even i tried to add the parameter but no help.

    Regards,

    Abhi

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    Take a look at this document - 12.2.1.3 auto enables a feature for RAC. Unfortunately, if you have a non RAC database, you'll get the issues you're facing. The document gives you a number of workaround options.

    Oracle Support Document 2308193.1 (FMW 12.2.1.3.0: "ONS configuration failed" or "oracle.ons.NoServersAvailable: Subscription time out") can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2308193.1

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    Hello Joel,

    Thank you for your help, I will try these options mentioned and update the blog.

    Regards,

    Abhi

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    Thanks Joel,

    Problem solved, created the datasource with RAC option.