TriniDBA

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]