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
Old 11-23-2016
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...
 

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... (1 Reply)
Discussion started by: cqldba
1 Replies

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; ... (4 Replies)
Discussion started by: vij_krr
4 Replies

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... (1 Reply)
Discussion started by: snallusami
1 Replies

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... (0 Replies)
Discussion started by: rcbandit
0 Replies

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. ... (1 Reply)
Discussion started by: Girish19
1 Replies
asadmin-get(1AS)						   User Commands						  asadmin-get(1AS)

NAME
asadmin-get, get - gets the values of the monitorable or configurable attributes SYNOPSIS
get --user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename] [--terse=false] [--echo=false] [--interactive=true] [--monitor=false] dotted_attribute_name Gets the values of attributes. If the --monitor option is set to true, the monitorable attributes are returned. If the --monitor option is set to false, the configurable attribute values are returned. On Solaris, quotes are needed when executing commands with * as the option value or operand. 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. Default is false. --echo setting to true will echo the command line statement on the standard output. Default is false. --interactive if set to true (default), only the required password options are prompted. --monitor defaults to false; if set to false, the configurable attribute values are returned. If set to true, the monitorable attribute values are returned. OPERANDS
attributename attribute name in the dotted notation. Example 1: Using get asadmin> get --user admin --password adminadmin --host localhost --port 4848 "server.resources.jdbc-resource.jdbc/PointBase.*" server.resources.jdbc-resource.jdbc/PointBase.description=<null> server.resources.jdbc-resource.jdbc/PointBase.enabled=true server.resources.jdbc-resource.jdbc/PointBase.jndi-name=jdbc/PointBase server.resources.jdbc-resource.jdbc/PointBase.object-type=user server.resources.jdbc-resource.jdbc/PointBase.pool-name=PointBasePool EXIT STATUS
0 command executed successfully 1 error in executing the command asadmin-set(1AS), asadmin-list(1AS) J2EE 1.4 SDK March 2004 asadmin-get(1AS)
All times are GMT -4. The time now is 04:11 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy