• Register
0 votes
114 views

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?

7.5k 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:

TEST =
   (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = *<validhost>*)(PORT = *<validport>*))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (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.

36.1k points

Related questions

0 votes
1 answer 55 views
55 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 104 views
104 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 1.5K views
1.5K 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 21 views
21 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 65 views
65 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 jwilliam 3.9k points