It's all about the answers!

Ask a question

Listener refused the connection with the following error


Karl Weinert (2.0k42536) | asked Jun 04 '12, 1:59 p.m.
JAZZ DEVELOPER
When testing the connection to my oracle database I get the following error

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: //localhost:1521/orcl


One answer



permanent link
Karl Weinert (2.0k42536) | answered Jun 04 '12, 2:03 p.m.
JAZZ DEVELOPER
edited Jun 04 '12, 2:04 p.m.
I checked ...Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora and it turns out I had installed my service to use the fully qualified name (orcl.ibm.com)

I changed //localhost:1521/orcl  to //localhost:1521/orcl.ibm.com and was able to connect.

here is what the tnsnames.ora file has in it:
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.ibm.com)
    )
  )


Your answer


Register or to post your answer.