Connection to DB from client server through jdbc:Oracle:Oci8 fail Post: 302986330

Sponsored Content

Special Forums IP Networking Connection to DB from client server through jdbc:Oracle:Oci8 fail Post 302986330 by udara on Wednesday 23rd of November 2016 06:50:47 PM

11-23-2016

Registered User

Connection to DB from client server through jdbc:Oracle:Oci8 fail

We tried to use to connect to DB using jdbc:Oracle:Oci8:@<SERVICE-A>. Connection fail / refuse with one DB .But its working with other databases.
But through toad, jdbc thin client were able to connect. But this has happen suddenly and were able to connect previously. How to navigate this issue to resolve.

alternative arrangement :
we currently connecting to DB Through JDBC Thin Client(

Code:

ODI_MASTER_URL=jdbc:oracle:thin:@oda-nc-tst-scan:1521/<SERVICE-A>

Issue found: connection through jdbc:Oracle:Oci8:@<SERVICE-A>

error:
-----

Code:

Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Connection reset
        at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
        at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:943)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:873)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)
        at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:99)
       at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)

at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)

---------- Post updated at 05:50 AM ---------- Previous update was at 05:43 AM ----------

How to trace specific connection come to DB using port, service name, username, oci8.

Please note now same user already connected through (jdbc:oracle:thin:@oda-nc-tst-scan:1521/<SERVICE-A>)

Last edited by Don Cragun; 11-23-2016 at 11:38 PM.. Reason: Made guesses at where CODE and ICODE tags should be added...

udara

View Public Profile for udara

Find all posts by udara

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unix to Sql Server via JDBC

I am trying to connect SQL SERVER VIA JDCB. Following is something I tried and will appreciate any help what I am doing wrong Here's what I did, I tried several variations, but I keep getting this error: Exception in thread "main" java.sql.SQLException: Unable to connect. Invalid URL I...

2. UNIX for Advanced & Expert Users

Server Programming to keep on looking for client connection

Hi I wrote a server Program in C, Here it is, this is a just socket creation alone, bool myclass::CreateSocket() { struct sockaddr_in sockaddr_in; sockaddr_in.sin_family = AF_INET; sockaddr_in.sin_port = 1100; sockaddr_in.sin_addr.s_addr = INADDR_ANY; ...

3. Ubuntu

JDBC Connection

Hi, I am using ubuntu os.I need some information about JDBC connection. 1.how to connect eclipse with apache tomcat server 2.I am using mysql database,how to to find the database location 3.How to set the classpath 4.How to connect Mysql with java using eclipse.I need step by step procedure...

4. IP Networking

Cisco VPN server and client - connection drop

I have a Cisco 1841 router configured as Easy VPN Server. Here is the configuration of the router: Cisco# Cisco#show running-config Building configuration... Current configura - Pastebin.com I have a Centos 5.7 server with installed Cisco VPN client for Linux. The client successfully...

5. Shell Programming and Scripting

Connect to Oracle database with JDBC drivers.

Hi All, We are having LINUX server. I would like to connect to oracle database from server to with the help of shell script and execute a procedure. We dont have oracle installed to use sqlplus and connect to database. Do we have any command to connect to database using JDBC drivers. ...

LEARN ABOUT SUNOS

asadmin-list-jdbc-resources

asadmin-list-jdbc-resources(1AS)				   User Commands				  asadmin-list-jdbc-resources(1AS)

NAME

       asadmin-list-jdbc-resources, list-jdbc-resources - gets all the JDBC resources

SYNOPSIS

       list-jdbc-resources  --user  admin_user [--password admin_password][--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename]
       [--terse=false] [--echo=false] [--interactive=true]

       Lists all the JDBC resources. This command is supported in remote mode only.

OPTIONS

       --user		       authorized domain application server administrative username.

       --password	       password to administer the domain application server.

       --host		       machine name where the domain application server is running.

       --port		       port number of the domain application server listening for administration requests.

       --secure 	       if true, uses SSL/TLS to communicate with the domain application server.

       --passwordfile	       file containing the domain application server password.

       --terse		       indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
			       formatted data for consumption by a script.

       --echo		       setting to true will echo the command line statement on the standard output.

       --interactive	       prompts you for the required options that are not already specified.

       Example 1: Using the list-jdbc-resources command

       asadmin> list-jdbc-resources --user admin1
       --password adminadmin1 --host pigeon --port 5001
       sample_jdbc_resource
       Command list-jdbc-resources executed successfully

       Where: sample_jdbc_resource is the JDBC resource listed.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-create-jdbc-resource(1AS), asadmin-delete-jdbc-resource(1AS)

J2EE 1.4 SDK							    March 2004					  asadmin-list-jdbc-resources(1AS)