Oracle Analytics Cloud and Server

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

Connection Test Failed(DB Authentication)

Received Response
1
Views
2
Comments
Rank 3 - Community Apprentice

Hi Team,

I'm trying to do DB Authentication in OBIEE 12c but I'm facing below issues so please guide me to configure DB Authentication in OBIEE 12c.I'm able to connect DB through SQL developer.

Message icon - Error Connection test failed.

Message icon - Error IO Error: The Network Adapter could not establish the connection

<br/>oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:775)

<br/>oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:833)

<br/>oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:40)

<br/>oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)

<br/>weblogic.jdbc.common.internal.DataSourceUtil.testConnection0(DataSourceUtil.java:371)

<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/>...

Thanks in Advance ..

Regards,

Shaik

Answers

  • Explain what you in details, what step gave you that, what document you were following.

    Because otherwise can't do lot more than point you to the official doc ...

  • Rank 3 - Community Apprentice

    Hi Gianni Ceresa,

    Using below link I'm trying to configure DB Authentication.

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/wls/12c/04-ConfigDataSource/configds.htm

    In above link we have a Configuring a JDBC Data Source, in this I've done 8(eight) steps completely but when i'm going to 9th step like Test configuration at that time i'm facing issue like

    Message icon - Error Connection test failed.

    Message icon - Error IO Error: The Network Adapter could not establish the connection

    I've checked port opening both Ip's between client and server.Its working fine and I've test the connection  through SQL developer, there also working fine and connected.

    Please guide me where issue will happen and is their any way to analyze log files to debug this issue.

    Thanks,

    Shaik

Welcome!

It looks like you're new here. Sign in or register to get started.