It's all about the answers!

Ask a question

Listener refused the connection with the following error:


Jirong Hu (1.5k9295258) | asked Aug 10 '11, 9:47 a.m.
Hi

I installed Oracle 11g on one server and Jazz on another. Now I am running the setup wizard and got this error while try to connect to Oracle. I use the following for JDBC location.

How can I find out if the parameter such as port number is right?

thin:JTS_USR/{password}@//CYSPQPVSPAAP002.cihs.ad.gov.on.ca:1521/orcl

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

Looks like no service is registered in the listener? How to register?

C:\Users\RTCAdmin>lsnrctl services OracleOraDb11g_home1TNSListner

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 10-AUG-2011 09:51
:36

Copyright (c) 1991, 2010, Oracle. All rights reserved.

TNS-01101: Could not find service name

C:\Users\RTCAdmin>

One answer



permanent link
William Hunsicker (40610) | answered Aug 30 '13, 3:09 p.m.
 Just curious, but did you install the Oracle client on both machines?  normally the JDBC needs to be able to get a hold of the ORA*.jar files to connect.  Installing the oracle client on both machines and then ensuring they can talk before trying to reach Oracle with the Jazz server would be a good idea. :)

Hope this helps.

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.