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 MARCH 08, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms