ORA12154 error TNS:could not resolve connection identfier error

Toad for Oracle & DevOps Toolkit
1

Hi,

I installed Toad for oracle 11.5.0.56. I have oracle 10g Release 2 (10.2) for Microsoft Windows (32-Bit). My operating system is Windows 7 64-bit. I am able connect to oracle using SQL plus, but not able to connect using Toad. I am getting the error mentioned in subject.

  • I have installed Oracle client in D drive.
  • I have also installed toad in program files folder and not program files(X86).
  • I have correct TNS names and environment variables.

Please help me. Thanks in Advance.

Message was edited by: Atuldas

2

I believe it’s a tnsnames.ora file issue

  1. On windows systems check the path for your tnsnames.ora file

  2. Make sure it exists and it’s placed in the correct place

  3. Check within this file, your service name, don’t confuse it with it’s alias

  4. check your global name using this SQL:
    select * from global_name

  5. Furthermore check 2 more links:

http://www.techonthenet.com/oracle/errors/ora12154.php

http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm

3

Hi,

Many thanks for your reply :). Bur No luck. After checking all the below tips. :frowning: , Please find my answers below for your tips in red.

I believe it’s a tnsnames.ora file issue

  1. On windows systems check the path for your tnsnames.ora file

tnsnames.ora path - D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN

TNS-ADMIN variable also has same path.
2) Make sure it exists and it’s placed in the correct place

Yes. I confirm that.

  1. Check within this file, your service name, don’t confuse it with it’s alias

I have attached my tnsnames.ora file. Please check and let me know if any issuesany issues. I am trying to connect to CRMPREP

  1. check your global name using this SQL:
    select * from global_name
    The above query returned CRMPREP.REGRESS.RDBMS.DEV.US.ORACLE.COM
    And after checking the below link i altered it according to the syntax db_name.db_name to CRMPREP.us.acme.com which i found in ini.ora file. I have also attached the ini.ora file for your reference.

Please check and let me know what can be done further. Many thanks for your help in advance.
init.ora (7.33 KB)

4

Hi,

Many thanks for your reply :). Bur No luck. After checking all the below tips. :frowning: , Please find my answers below for your tips in red.

I believe it’s a tnsnames.ora file issue

  1. On windows systems check the path for your tnsnames.ora file

tnsnames.ora path - D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN

TNS-ADMIN variable also has same path.
2) Make sure it exists and it’s placed in the correct place

Yes. I confirm that.

  1. Check within this file, your service name, don’t confuse it with it’s alias

I have attached my tnsnames.ora file. Please check and let me know if any issuesany issues. I am trying to connect to CRMPREP

  1. check your global name using this SQL:
    select * from global_name
    The above query returned CRMPREP.REGRESS.RDBMS.DEV.US.ORACLE.COM
    And after checking the below link i altered it according to the syntax db_name.db_name to CRMPREP.us.acme.com which i found in ini.ora file. I have also attached the ini.ora file for your reference.

Please check and let me know what can be done further. Many thanks for your help in advance.
LISTENER.ORA (867 Bytes)

5

Hi,

Many thanks for your reply :). Bur No luck. After checking all the below tips. :frowning: , Please find my answers below for your tips in red.

I believe it’s a tnsnames.ora file issue

  1. On windows systems check the path for your tnsnames.ora file

tnsnames.ora path - D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN

TNS-ADMIN variable also has same path.
2) Make sure it exists and it’s placed in the correct place

Yes. I confirm that.

  1. Check within this file, your service name, don’t confuse it with it’s alias

I have attached my tnsnames.ora file. Please check and let me know if any issuesany issues. I am trying to connect to CRMPREP

  1. check your global name using this SQL:
    select * from global_name
    The above query returned CRMPREP.REGRESS.RDBMS.DEV.US.ORACLE.COM
    And after checking the below link i altered it according to the syntax db_name.db_name to CRMPREP.us.acme.com which i found in ini.ora file. I have also attached the ini.ora file for your reference.

Please check and let me know what can be done further. Many thanks for your help in advance.
TNSNAMES.ORA (742 Bytes)

6

The Solution
Make sure that “TNSNAMES” is listed as one of the values of the NAMES. DIRECTORY_PATH parameter in the Oracle Net profile
Verify that a TNSNAMES.
Check that the net service name used as the connect identifier exists in the TNSNAMES.
Make sure there are no syntax errors anywhere in the TNSNAMES.

Regards,
Rachel Gomez