DBConnect with Oracle Error

[nandipatisunil]

Oracle database connection issue.

Encountered the following error while trying to update: In handler 'databases': Error connecting to database: 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.

[lukejadamec]

I've seen this a lot, and my DBA usually tells me to do the opposite of what I'm doing regardless of what worked before.

For the database name, try a different case, the fully qualified name, not the fully qualified name.

This error is a problem with the database name.

[dwaddle]

ORA-12514 is an Oracle error which you may need to discuss with your Oracle DBA. Reading some things about this error, you may simply have the wrong JDBC connect string, possibly listing the wrong database name in the connect string.

Make sure you are connecting to the right host and port number, and that the database you are trying to connect to is defined to the TNS listener on the host you're connecting to. Your Oracle DBA should be able to help you figure this out.