Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Getting error while creating datasource in OBI console

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
-
3521884 wrote:We are getting below error while creating the datasource in OBI Console:-
I guess you mean the Weblogic console?
0 -
Hello Berg,
yes, you are correct, even i tried to add the parameter but no help.
Regards,
Abhi
0 -
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
0 -
Hello Joel,
Thank you for your help, I will try these options mentioned and update the blog.
Regards,
Abhi
0 -
Thanks Joel,
Problem solved, created the datasource with RAC option.
0