• Register
0 votes

Problem :

I have an application which is running locally where I am facing the following error:

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

Already I have tested the connection using TNSPing which resolved correctly also I have tried SQLPlus to try connecting but it failed with the same error as above. I used following syntax for SQLPlus:

sqlplus username/password@addressname[or host name]

I have already verified following action items:

·         TNS Listener on the server is running properly.

·         Oracle itself on the server is running properly.

Does anybody have any solution on my problem?

6 5 3
7,540 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

I also had the same error and the solution for it was to make sure in tnsnames.ora the SERVICE_NAME must be a valid service name in your database. To find out the valid service names in your database, you must use the following query in oracle:

select value from v$parameter where name='service_names'

Also I updated tnsnames.ora as follows:

      (ADDRESS = (PROTOCOL = TCP)(HOST = *<validhost>*)(PORT = *<validport>*))
      (SERVICE_NAME = *<servicenamefromDB>*)

After that I ran following command:

sqlplus user@TEST

And Success!! The listener is basically trying to tell you that your service_name that you are using is not the valid service according to the DB.

9 7 4
38,600 points

Related questions

0 votes
1 answer 92 views
Problem : We have the application running locally where we are experiencing the below error: &ldquo;ORA-12514: TNS:listener does not currently know of service requested in connect descriptor&rdquo; I have already tested the connection using the TNSPing which resolved it correctly ... running. We are unable to know of any changes that were made to my environment. Anything else that we can test?
asked Jan 6, 2020 alecxe 7.5k points
0 votes
1 answer 15 views
0 votes
1 answer 18 views
Problem: I am trying to enable CORS on one of the very specific actions in my Asp.net Web Api. Please find below my code and tell me if I am missing anything: [Route("api/mycontroller/myaction")] [HttpPost] [EnableCors("https://example.com", "*", "post")] public ... http method 'OPTIONS'." I also tried to remove the [HttpPost] annotation but to no avail. Have I made any mistake in my above code?
asked Aug 19, 2020 Raphael Pacheco 4.9k points
0 votes
1 answer 144 views
Problem : I am very new to node.js and MySQL and I have just started setting up and also trying out some basic code. But, I am unable to make even the simple connection to a server for some reason. I have also installed a newest MySQL ... ; console.log("Connected!"); }); My Error: &ldquo;Client does not support authentication protocol requested by server consider upgrading mysql client&rdquo;
asked Jan 30, 2020 jwilliam 3.9k points
0 votes
1 answer 2.8K views
Problem : I need to build the Spring-Boot *.war with maven, but I keep facing below error: [WARNING] The requested profile "pom.xml" could not be activated because it does not exist. After completely running the mvn: clean. After the success my ... : Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile (default-compile) on project webconsultas: Fatal error compiling
asked Dec 24, 2019 alecxe 7.5k points
0 votes
1 answer 31 views
Problem : We are currently migrating our servers (2005 to 2008) and our host backed up our SQL database and transferred it to our new server. I have transferred our website files and changed our IP address in our connection string and also in our global. ... our new server, but when I want to launch a page that connects to our SQL I get the below error : SQL_Server_does_not_exist_or_access_denied.
asked Dec 19, 2019 alecxe 7.5k points
0 votes
1 answer 2.8K views
Problem : I want to configure the hibernate orm mapping tool to my java class and want to use PostgreSQL as my database also I have configured the password as "password". But when I tried to run the application, I am facing following error ... in thread "main" org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
asked Dec 4, 2019 alecxe 7.5k points
0 votes
1 answer 115 views
Problem : I am using my home network to share my files between devices in my household with no problem, but very recently I had to re-install the Windows 10, after that, no devices were shown under the Network in File Explorer. I can surely ping my devices ... Home network System error 6118 has occurred. The list of servers for this workgroup is not currently available. What seems to be a problem?
asked Feb 3, 2020 jwilliam 3.9k points
0 votes
1 answer 6 views
Please tell me how to resolve this error
asked Jan 4 TeamScript 9.5k points
2 votes
1 answer 47 views
Problem : I am very new to SQL Server 2008 Management Studio. I have recently connected my SQL Server 2008 Management Studio with Windows authentication. After that I am facing below error "The request failed or the service did not respond in a timely fashion. Consult the event ... to fix above error from past couple of days but I am unable to fix it. Can somebody guide me in fixing above error ?
asked Mar 25, 2020 morrisBson 3.2k points