My Oracle Support Banner

Oiddiag Fails With: java.sql.SQLException: Io exception, Or ORA-12514, Or Error: java.sql.SQLException: Io exception: Connection reset (Doc ID 728194.1)

Last updated on OCTOBER 01, 2018

Applies to:

Oracle Internet Directory - Version 9.0.4 and later
Information in this document applies to any platform.

Symptoms

Running the oiddiag tool returns error after entering the ODS password. For example:

$ ./oiddiag collect_all=true
Enter fully domain-qualified database host name: mydbhost.mycompany.com
Enter database listener port number: 1521
Enter database service name(SERVICE_NAME in tnsnames.ora file): orcl
Enter ODS DB user password: [ODS db password] (default is same as orcladmin's password)
Now connecting to the Database
Error: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

After setting the environment variables correctly for the OID home and retrying oiddiag, now it returns a different error:

Error: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
//mydbhost.mycompany.com:1521/orcl

 

Or oiddiag may return the following error:

>oiddiag collect_all=true
Enter fully domain-qualified database host name: mydbhost.mycompany.com
Enter database listener port number: 389
Enter database service name(SERVICE_NAME in tnsnames.ora file): oid
Enter ODS DB user password: *
Enter ODS DB user password: Now connecting to the Database
Error: java.sql.SQLException: Io exception: Connection reset
>

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.