• Register
0 votes
192 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?

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:

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.

9 7 4
38,600 points

Related questions

0 votes
1 answer 2 views
2 views
Problem: We have an application running locally where we're experiencing the following error: ORA-12514: TNS: listener does not currently know of service requested in connect descriptor
asked Apr 3 ummesalma 25.2k points
0 votes
1 answer 109 views
109 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 4 views
4 views
Problem: I get to keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11
asked Apr 3 ummesalma 25.2k points
0 votes
1 answer 14 views
14 views
Problem: tns listener was not given the service_name in connect_data
asked Feb 17 Dan phillip 4.8k points
0 votes
1 answer 4 views
4 views
Problem: I need to connect to the database without full connection string, Just i need to type sqlplus then i enter username and password, this is throwing below error. ERROR: ORA-12545: Connect failed because target host or object does not exist
asked Apr 3 ummesalma 25.2k points
0 votes
1 answer 3 views
3 views
Problem: When I try to run the application that tries to connect to db I got ORA-12543: TNS: destination host unreachable
asked Apr 3 ummesalma 25.2k points
0 votes
1 answer 2 views
2 views
Question: I want to connect with my Oracle database without installing Oracle Client. I downloaded: "Instant Client Package - Basic" and "Instant Client Package - SQL*Plus" Then I created folder on C:\Oracle\instantclient, where I extracted all packages. I have ... Port=1521))(CONNECT_DATA=(SID=address to SID))) everything works properly. Why SQL have a problem with recognize tnsnames.ora file?
asked 3 days ago Atik03 10.1k points
0 votes
1 answer 4 views
4 views
Problem: I use SQL developer and I made a connection to my database with the system user But when I try to proceed following I get the SQL Error ORA-00942 table or view does not exist.
asked Apr 3 ummesalma 25.2k points
0 votes
1 answer 3 views
3 views
Problem: I am getting the error when trying to connect to a server database from a client using the service name orcl. It is getting connected when I am using the other service name i.e. dms: Ora-27101: shared memory realm does not exist
asked Apr 3 ummesalma 25.2k points
0 votes
1 answer 4 views
4 views
Problem: When I try to execute the above code to save the function to the database, the environment (SQL*PLUS) hangs for a long time and at the end returns this error: ERROR at line 1: ORA-04021: timeout occurred while waiting to lock object What is the problem ??? Please!
asked Apr 3 ummesalma 25.2k points