Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


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


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
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...
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Connect to Oracle database with JDBC drivers.
Girish19
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. ...... Shell Programming and Scripting
1
Shell Programming and Scripting
Cisco VPN server and client - connection drop
rcbandit
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...... IP Networking
0
IP Networking
JDBC Connection
snallusami
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...... Ubuntu
1
Ubuntu
Server Programming to keep on looking for client connection
vij_krr
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; ...... UNIX for Advanced & Expert Users
4
UNIX for Advanced & Expert Users

Featured Tech Videos