Listener refused the connection with the following error:
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>
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
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
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.