• 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

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 72 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 alecxe 7.5k points
0 votes
1 answer 8 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 Raphael Pacheco 4.9k points
0 votes
1 answer 120 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 jwilliam 3.9k points
0 votes
1 answer 2.2K 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