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

Problem: When configuring the TNS settings using the Oracle Net Configuration Assistant, the follow error appears:

Connecting… ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. The test did not succeed.

Solution: Mismatch between hostnames in tnsnames.ora and listener.ora.

1. Make a note computer name by checking My Computer Properties. You may also check %COMPUTERNAME% or %USERDOMAIN%.

2. Make a note of the computer’s full domain name.

3. Check the computer’s IP address using ipconfig /all (you may also check hosts file).

4. Ensure you can ping the hostname and IP address.

5. Check the tnsnames.ora file to ensure that contains the correct hostname or IP address.

6. Make a note of the instance’s SID.

7.Run ‘tnsping SID’.

8. Check listener.ora to ensure that the correct machine name or IP address is in the file.

9. Ensure that the listener is started. It can be restarted using ‘lsnrctl reload’.

[amazon asin=0071496610&template=iframe image&chan=default]     [amazon asin=1849687307&template=iframe image&chan=default]     [amazon asin=0071598758&template=iframe image&chan=default]

  1. I was suffering this problem but after uninstall my antivirus the database was connect again
    So don’t worry and do it….

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.