ORA-12514 error on **DBVisualizer**

Question

Please help with this error on DBVisualizer. No oracle or Sql is installed i just simply use DBVisualizer.

I have read lot of answers here on stackoverflow but not able to find a suitable answer.

Note : I used Oracle Thin Driver for connection.I have used latest updated version and also tried old version too.

An error occurred while establishing the connection:

Long Message:
Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Details:
   Type: java.sql.SQLException
   Error Code: 12514
   SQL State: 66000

Answer 1

Sounds to me like the environment isn't set to the right path for oracle drivers to be found. Has this worked before? I ask because you say:

"No oracle or Sql is installed"

Which is a little odd, in my opinion. Typically your environment must state "where to look" for db drivers.

Shot in the dark, but setting something like: TNS_ADMIN=/opt/oracle/instantclient_11_2 or TNS_ADMIN=C:\path\to\oracle\thin\drivers might work.

Next suggestion is to follow this and see if setting TNS_NAMES makes a difference:

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

Answer 2

What this error says is that the driver (which is btw properly loaded in DbVisualizer) is unable to establish connection with the database. There are tons of references to the "listener does not currently know of service requested" error message on the net.

In DbVisualizer I first suggest you change the Connection Type from Service to SID to see if that makes any difference. If neither of Service or SID works, does the server respond when you click the Ping Server button? If it doesn't you need to verify the listener settings in the Oracle server.

Answer 3

in place of orcl give your database name...this should work the above error