It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,884
×2,352

question asked: Jun 04 '12, 1:59 p.m.
question was seen: 11,563 times
last updated: Jun 04 '12, 2:04 p.m.

Related questions

Listener refused the connection with the following error

0
Karl Weinert (2.0k●5●27●36) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Karl Weinert (2.0k●5●27●36) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.